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 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
Get step-by-step solutions from verified subject matter experts
