Question: a) Considering the above scenario, list the column names under the repeating and the non-repeating groups. Also identify the primary keys and the foreign keys

a) Considering the above scenario, list the column names under the repeating and the non-repeating groups. Also identify the primary keys and the foreign keys for both the groups. (8 marks) Fundamentals of Relational Database Management Systems (COMP 20002.1) - Fall - 22- CW2 (Assignment) - ALL - QP b) Considering your answer for Task 2a, normalize the solution to convert it into 2nd Normal Form (2 NF). Also identify the primary keys and the foreign keys. (12 marks) c) Normalize the solution of 2NF to 3 NF by identifying the transitive dependency for the solution of Task 2b. Also identify the primary keys and the foreign keys. (15 marks)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Using the manual rating model, you have calculated the rate per $1,000 and total premium amount for the Mammoth Mart proposal, and you have provided both values to the sales representative. She is...

database Task 2: Consider the scenario given below to answer the following questions. (Total: 50 marks) a) Considering the above scenario, list the column names under the repeating and the...

i have all answers except question D Task 2: Consider the scenario given below to answer the following questions. (Total: 50 marks) PHARMACY INFORMATION SYSTEM, APOLLO HOSPITALS Patient Prescription...

Task 2: Consider the scenario given below to answer the following questions. (Total: 50 marks) a) Considering the above scenario, list the column names under the repeating and the non-repeating...

Please I need help with the Part 3 and 4 Questions of this exercise. Thank you. Exercise: Hotel Schema Overview Hotel Software Guild is a resort hotel on the West Arm of Lake Minnetonka. It is a...

Convert Data Models to Database Design (20 pts) Note: This assignment can optionally be completed in teams or pairs. If you choose to submit the assignment this way, you must indicate clearly on your...

Note: While it is understood that groups may share their expertise and communicate with each other, each group's work must reflect sufficient individual group effort to merit its grade. Sharing...

The UT system is trying to create and convert their student records into digital form. The idea behind this database is to list all students in UT system colleges/universities with their Name, major,...

Project Specification: 1. Part A: Entity Relationship Diagram 1. Your first task is to study the Case study requirements and gather as much knowledge to list all the main Entities and attributes. 2....

Assignment brief Quiet Attic Films is a film production company based in London, England who specialize in making short information films and advertisements for television. They want you to design...

The company is expected to generate $179 million in free cash flow per year over the next 3 years (FCFF1, FCFF2 and FCFF3). After that, cash flows are expected to increase by 1.8% continuously. The...

D. J. Hills checkbook and February bank statement show the following: Requirement 1. Prepare Hills bank reconciliation at February28. Date Check No. Item Check Deposit Balance $ S15 500 615 575 497...

The structure of a process has no bearing on its efficiency. True False

CT Corp Comprehensive Question Canadian Tire Corporation, Limited ( Canadian Tire ) is a family of companies that includes a retail segment and a financial services division, among others. The retail...

2 Why is establishing competent communication so important for soldiers in Iraq? Do you think such training would have been more or less important for soldiers in Europe during World War II?

4 Is this more of an issue in high schools and middle schools than in elementary schools? What would you do if your college or university suddenly adopted a uniform policy?

A Do you think soldiers can learn communication skills from a video game? Do you think this method of training would be more or less effective than classroom instruction?