Question

Problem: Consider the scenario of the following ER diagram for a company database. Write SQL statements to create the corresponding relations and capture as many of the constraints as possible. If you cannot capture some constraints, explain why. Employee SSN first name last name (phone) Manages Works-in Has-kids Child name date-of-birth Employees (ssn, firstname, lastname, dno, dname, hours) Dept (dno, dname, budget, mgr ssn) Dependents (ssn, name, date of birth) Employee_phone (ssn, phone) Department dno dname budget

          Problem:
Consider the scenario of the following ER diagram for a company database. Write SQL
statements to create the corresponding relations and capture as many of the constraints as
possible. If you cannot capture some constraints, explain why.
Employee
SSN
first name
last name
(phone)
Manages
Works-in
Has-kids
Child
name
date-of-birth
Employees (ssn, firstname, lastname, dno, dname, hours)
Dept (dno, dname, budget, mgr ssn)
Dependents (ssn, name, date of birth)
Employee_phone (ssn, phone)
Department
dno
dname
budget

Show more…

Problem:
Consider the scenario of the following ER diagram for a company database. Write SQL
statements to create the corresponding relations and capture as many of the constraints as
possible. If you cannot capture some constraints, explain why.
Employee
SSN
first name
last name
(phone)
Manages
Works-in
Has-kids
Child
name
date-of-birth
Employees (ssn, firstname, lastname, dno, dname, hours)
Dept (dno, dname, budget, mgr ssn)
Dependents (ssn, name, date of birth)
Employeephone (ssn, phone)
Department
dno
dname
budget

Added by Samantha O.

Computer Science and Information Technology

Trishna Knowledge Systems 2018 Edition

Instant Answer

Solved by Expert Dominador Tan

12/01/2023

Step 1

Step 1: Create the Employees table with constraints ```sql CREATE TABLE Employees ( ssn INT PRIMARY KEY, firstname VARCHAR(50), lastname VARCHAR(50), dno INT, dname VARCHAR(50), hours INT, FOREIGN KEY (dno) REFERENCES Dept(dno) ); ``` Show more…

Show all steps

lock

Thanks for your feedback!

Problem: Consider the scenario of the following ER diagram for a company database. Write SQL statements to create the corresponding relations and capture as many of the constraints as possible. If you cannot capture some constraints, explain why. Employees (ssn, firstname, lastname, dno, dname, hours) Dept (dno, dname, budget, mgr_ssn) Dependents (ssn, name, date_of_birth) Employee_phone (ssn, phone)

Play audio

Feedback

Powered by NumerAI

Dominador Tan and 57 other subject AP CS educators are ready to help you.

Ask a new question

Labs

Want to see this concept in action?

NEW

Explore this concept interactively to see how it behaves as you change inputs.

View Labs

Key Concepts

Recommended Videos

Recommended Textbooks

Transcript

Ace is your personal tutor. It breaks down any question with clear steps so you can learn.

Start Using Ace

Continue solving this problem

Create a free account to:

View full step-by-step solution
Ask follow-up questions with Ace AI
Save progress and study later