Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions

Question

What is the difference between Needs and GAP Analyses?

Answered: 1 week ago

Question

What are ERP suites? Are HCMSs part of ERPs?

Answered: 1 week ago