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 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!