Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started