Question: Question 1 (15 marks) The relational database below contains two related tables - Manager and Sub-ordinate: Iname 501 Sub-ordinate table: Primary key = Sub -code,

Question 1 (15 marks) The relational database below contains two related tables - "Manager" and "Sub-ordinate": Iname 501 Sub-ordinate table: Primary key = Sub -code, Foreign key = Man -code Sub-code Sub Sub-deptSub Sub-phone Sub -Man-code areacode renew Date 10010 zzzsales 688 123445677 2017-11-14 10011 xxx Jaccount 1606 1234567899 2017-11-16 501 10012 yyy IT 2 32 345678900 2017-11-13 502 10013 ece sales 2 34 454577777 2017-10-13 503 10014 lii sales 231 436436885 2017-10-23503 10015 sdg account 175 1676446322 2017-10-30 504 10016 Jewt legal 789 232317879 2017-12-30 502 "Manager" table: Primary key = Man -code, No Foreign key Man-code Man - Iname Man-fname Man -Initial Man-areacode Man-phone 501abcabenbve F S615 |123445678 502 werte hjjkgdf B 6 15 2 34567890 503 zxcvb pooliuu X 234 3 45678901 a. From the above data, what type of relationships: one-to-one, one-to- many, or many-to-many, do the above two tables have? Explain your answer. (5 marks) b. The above database contains an error in the data. Identify and describe this error. (5 marks) c. Why does Manager" table has no foreign key and why does "Sub- ordinate" table has foreign key? Describe the use of primary and foreign keys in databases. Illustrate with examples in your answers

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 General Management Questions!

Question 1 (15 marks) The relational database below contains two related tables - "Manager" and "Sub-ordinate": name 1688 "Sub-ordinate" table: Primary key = Sub-code, Foreign key = Man -code...

Question 2 The relational database below contains two related tables - Supplier and Product: Product table: Primary key = Prod-code, Foreign key = Supp-code Prod-code Prod -name Prod -desript Prod...

Question 2 The relational database below contains two related tables - "Supplier" and "Product": "Product" table: Primary key = Prod-code, Foreign key = Supp-code Prod-cod Prod Prod -d Prod -sto Prod...

The relational database below contains two related tables - Supplier and Product Product table: Primary key = Prod-code, Foreign key = Supp-code Prod-code Prod -name Prod -desript Prod -stocktype...

The relational database below contains two related tables - Supplier and Product: Product table: Primary key = Prod-code, Foreign key = Supp-code Prod-code Prod -name Prod -desript Prod -stocktype...

This is a database related question FIGURE P3.17 THE CHO3 TRANSCO DATABASE TABLES Table name: TRUCK Database name: Cho3 TransCo Primary key: TRUCK NUM Foreign key: BASE CODE, TYPE CODE TRUCK NUM BASE...

database management system, pdf is attached COURSEWORK SECOND SEMESTER 2019/2020 SESSION (A192) COURSE CODE & NAME : BKAS3053 DATABASE MANAGEMENT SYSTEM LECTURER'S NAME : ASSOC. PROF. TS. DR. AIDI...

database management system COURSEWORK SECOND SEMESTER 2019/2020 SESSION (A192) COURSE CODE & NAME : BKAS3053 DATABASE MANAGEMENT SYSTEM LECTURER'S NAME : ASSOC. PROF. TS. DR. AIDI AHMI DR. MOHD...

Question 1 (40 marks) Refer to Table 1. Write the Excel formula for each cell marked with "" in column C such that formula could be copied and pasted into columns D and E using Microsoft Excel...

Question 4 (25 marks) Case: Retail Database Design You have engaged a software vendor to design a database to capture both retail outlets essential data. The key areas of your concerns are sales...

Write a reflection essay on the topic: Practical Connection of Course Concepts. At UC, it is a priority that students are provided with strong educational programs and courses that allow them to be...

Porsche Ind. has been busy analyzing a new product. It has determined that an operating cash flow of $16,700 will result in a zero net present value, which is a company requirement for project...

Over time, you should change the composition of your investment portfolio in response to change in your Question content area bottom Part 1 A . investment goals. B . life circumstances. C . market...

Cane Company manufactures two products. called Alpha and Beta that sell for $ 1 5 0 and $ 1 0 5 , respectively. Each product uses only one type of raw material that costs $ 5 per pound. The company...