3:07 PM Mon 9 May .. SOR 34% elearning.nust.na Read the following scenario carefully and answer the questions that follo

[answerhappygod]

3 07 Pm Mon 9 May Sor 34 Elearning Nust Na Read The Following Scenario Carefully And Answer The Questions That Follo 1 (39.83 KiB) Viewed 57 times

3 07 Pm Mon 9 May Sor 34 Elearning Nust Na Read The Following Scenario Carefully And Answer The Questions That Follo 2 (55.16 KiB) Viewed 57 times

3 07 Pm Mon 9 May Sor 34 Elearning Nust Na Read The Following Scenario Carefully And Answer The Questions That Follo 3 (19.46 KiB) Viewed 57 times

3:07 PM Mon 9 May .. SOR 34% elearning.nust.na Read the following scenario carefully and answer the questions that follow. A company transports many chemical Products from one location to another on behalf of a registered Customer. Each transport operation is called a Job, which involves picking up one or more Loads of the same product from a customer's requested start location and delivers it to a customer's requested destination. A unique number is given for each Job and for each Load when they are created. A Load is transported using a particular Transport Unit, which consists of a lorry, a driver, a container (for carrying the product) and occasionally specialist loading equipment (such as Jacks and Pumps). A container is fixed to a trailer so it needs to be coupled to a lorry at the start of a Job. Transport operations are run from 5 regional Depots. Jobs are allocated to individual depots to service. Depots are usually located near to pick up points such as chemical plants. Depots hold, manage and maintain their own transport units which are permanently allocated to them to 1

service Jobs. A container, and sometimes associated loading equipment, may on occasions be left at destinations or pick-ups after a Job is finished. But normally transport units are held at the base Depot they belong. Question 1 (60 marks) i. ii. up draw an ER diagram for the described database. [15 marks] Map the logical data model for the ER diagram you drew in (i) above. Show the resultant relations at each Normal Form to 3NF [20 marks) Present the physical data model. [10 marks) Use appropriate SQL statements to implement the described database on Microsoft SQL Server Management Studio. [15 marks) iv. Question 2 (40 marks) Consider the following Employee Table EmployeeID HireDate FirstName Surname 1 2 3 4 15 Sept 2005 Peter 23 April 2006 John 12 March 2004 Susan 2 Dec 2001 Sam Jones Bonds Khanye Beukes Occupation Monthly Salary Nurse N$25000 Accountant N$35000 Teacher N$15000 Army N$55000 commander Accountant N$35000 Software N$80000 developer 5 6 2 Dec 2001 01 January 2020 Ndiye Owen Makwali Mbambo N N

1. ii. Write the SQL statements To create the Employee table. To populate the shown records into the table. To delete the records of all employees employed as Accountant. iv. To show the details of highest paid employee. To remove all the records in the Employee table [9 marks] [15 marks) [7 marks] [6 marks) [4 marks] V. 3