QUESTION THREE 3.1 Create an ERD for each of the following descriptions 3.3.1 3.2 EMP N...

Transcribed Image Text:

QUESTION THREE 3.1 Create an ERD for each of the following descriptions 3.3.1 3.2 EMP N O 215 216 QUESTIONS FOUR Using the Employee table below, write the rational schema and draw it's dependency diagram. Identify all dependencies. 217 218 219 220 4.1 4.2 4.3 Each of the Spar's divisions is composed of many departments. Each of those departments has many employees assigned to it, but each employee works for only one department. Each department is managed by one employee, and each of those managers can manage only one department at a time. (5) 3.3.2 Shoprite operates many shops. Each shop is located in a region. Each region can be "home" to many of the Shoprite shops. Each shop employs many employees, but each of those employees is employed by only one shop. (5) Using practical example, discuss what SQL is and the distinction between DDL and DML as well as how SQL functions fits in both of them (10) EMP_NAM CUST N O E SPHELELE 15 BOKHOSI 16 THEMBA LEFA 16 14 VALENTINE 14 PROMISE 18 Identify all dependencies. CUST_NAM CUST_PHON PROD_N 0 0834528787 10 HUGUETTE E TANDIWE TANDIWE BUSISIWE BUSISIWE GIRLY E 0784521635 12 0784521635 15 0618578542 12 0618578542 13 0829687841 13 E SOAP PROD_NAM DATE BRAID [20 MARKS] PHONE PEN LAPTOP [25 MARKS] LAPTOP 20/03/201 2 20/03/201 2 21/04/201 2 22/04/201 2 22/04/201 2 22/04/201 2 Using the Employee table above, write the rational schema and draw it's dependency diagram. (8) (9) Create a database whose table(s) is at least in 3rd normal form, showing the dependency diagram and the rational schema for each table. (8) QUESTION THREE 3.1 Create an ERD for each of the following descriptions 3.3.1 3.2 EMP N O 215 216 QUESTIONS FOUR Using the Employee table below, write the rational schema and draw it's dependency diagram. Identify all dependencies. 217 218 219 220 4.1 4.2 4.3 Each of the Spar's divisions is composed of many departments. Each of those departments has many employees assigned to it, but each employee works for only one department. Each department is managed by one employee, and each of those managers can manage only one department at a time. (5) 3.3.2 Shoprite operates many shops. Each shop is located in a region. Each region can be "home" to many of the Shoprite shops. Each shop employs many employees, but each of those employees is employed by only one shop. (5) Using practical example, discuss what SQL is and the distinction between DDL and DML as well as how SQL functions fits in both of them (10) EMP_NAM CUST N O E SPHELELE 15 BOKHOSI 16 THEMBA LEFA 16 14 VALENTINE 14 PROMISE 18 Identify all dependencies. CUST_NAM CUST_PHON PROD_N 0 0834528787 10 HUGUETTE E TANDIWE TANDIWE BUSISIWE BUSISIWE GIRLY E 0784521635 12 0784521635 15 0618578542 12 0618578542 13 0829687841 13 E SOAP PROD_NAM DATE BRAID [20 MARKS] PHONE PEN LAPTOP [25 MARKS] LAPTOP 20/03/201 2 20/03/201 2 21/04/201 2 22/04/201 2 22/04/201 2 22/04/201 2 Using the Employee table above, write the rational schema and draw it's dependency diagram. (8) (9) Create a database whose table(s) is at least in 3rd normal form, showing the dependency diagram and the rational schema for each table. (8)

Answer rating: 100% (QA)

Division Ras Each Each Each Each Answer The above ER diagram it interpre... View the full answer