Question: 1. Implement the following branch table: Table's Primary Key Character of size 16 and cannot be null Character of size 1 and cannot be null

 1. Implement the following branch table: Table's Primary Key Character of

1. Implement the following branch table: Table's Primary Key Character of size 16 and cannot be null Character of size 1 and cannot be null DATETIME and cannot be null Double with default o staffNo fName IName position sex DOB salary branchNo SL21 SG37 SG14 SA9 SG5 SL41 John Ann David Mary Susan Julie White Beech Ford Howe Brand Lee Manager M Assistant F Supervisor M Assistant F Manager F Assistant F 1-Oct-45 10-Nov-60 24-Mar-58 19-Feb-70 3-Jun-40 13-Jun-65 30000.00 12000.00 18000.00 9000.00 24000.00 9000.00 B005 B003 B003 B007 B003 B005 Character of size 4 and cannot be null 2. Write the 6 INSERT statements to add the rows shown. 3. Write a single SQL statement to show the unique positions in the table. 4. Write a single SQL statement to show the employees in branch number B003

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!