Identify the foreign keys

Assignment Help Database Management System

Reference no: EM133993362

Assignment:

Consider the following relations for a company Database Application:

Employee (Eno, Name, Sex, Dob, Doj, Designation, Basic_Pay, Dept_No)

Department (Dept No, Name)

Project (Proj No, Name, Dept_No)

Worksfor (Eno, Proj No, Date, Hours)

The attributes specified for each relation are self-explanatory. However the business rules are stated as follows.

A department can control a project. An employee can work on any number of projects on day. However an employee cannot work more than once on a project he/she worked on that day. The primary keys are underlined.

i. Identify the foreign keys.

ii. Write SQL statements to implement the above schema.

Reference no: EM133993362

Questions Cloud

Discuss interprofessional collaboration skills : Discuss effective communication and interprofessional collaboration skills that you could apply to effectuate the required change.

Describe at least five critical best practices : Identify and describe at least five critical best practices that form the foundation of an effective governance regime.

Why is it still possible that the power supply may be faulty : Dave suspects that a power supply is faulty, but he uses use a power supply tester to measure its voltage output and find it to be acceptable.

What do you think happened in reality at sorelle bakery : Summarize set of events which took place from context of OD. Conduct independent research on internet. What do you think happened in reality at Sorelle Bakery?

Identify the foreign keys : Identify the foreign keys. Write SQL statements to implement the above schema.

Identify and analyse marketing opportunities : You need to complete the following activities: Identify and analyse marketing opportunities. Determine scope of each marketing opportunity.

How many search results did he receive back from google : He searched in Google for templates for Memo templates in Microsoft Word. How many search results did he receive back from Google?

Which change mechanisms the statement best summarizes : This change mechanism involves the introduction of new technologies aimed at subtly altering. This statement BEST summarizes which change mechanisms?

Develop a data model for the vila health clinic : Using the data points provided, develop a data model for the Vila Health clinic; apply your knowledge of data modeling concepts.

User Account

All Pages