Question: Run Project management database Run 4 tables based on the diagram below Include all of constraints based on the ERD diagram and based on your

Run Project management database
Run 4 tables based on the diagram below
1. Include all of constraints based on the ERD diagram and based on your assumptions
2. Include primary key and foreign key
3. Use identity function for the primary key in the Project table
Populate each table with 5-10 records

project Pname: varchar(15) Pnumber: int(11) Plocation varchar(15) Dnum: int(11) department Dname: varchar(15) Dnumber: int(11) Mgr_ssn: char(9) Mgr_start_date: date HI ++ ++ works_on Essn: char(9) Pno: int(11) Hours: decimal(3, 1) employee Fname: varchar(100) Minit char(1) Lname: varchar(100) Ssn char(9) Bdate: date Adress: varchar(100) Sex: char(1) Salary: decimal(10, 2) Super_ssn: char(9) Dno: int(11)

Step by Step Solution

★★★★★

3.40 Rating (150 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Based on the EntityRelationship Diagram ERD provided we can write the SQL statements to create the four tables with all the necessary constraints incl... View full answer

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!

What is a brand, how is it identified, how is it codified, how is it developed and what values should it reflect? Illustrate with an example what is described in the definitions.

Kendra has been collecting empty bottles and cashing them in for money at regular intervals. She receives 15 cents for each bottle and collects an average of 500 bottles per week. The market rate of...

Consider the COMPANY database described in Figure 5.6. Using the syntax of Oracle triggers, write active rules to do the following: a. Whenever an employees project assignments are changed, check if...

When considering banning a toxic chemical, why should replacement substances or processes be part of the decision?

The syntheses shown here are unlikely to occur as written. What is wrong witheach? 1. Mg 2. * CH3CH2CH3 (a) CH3CH2CH2F C (c) F CH2 Br () CH2 (CH3)2CULI Ether NBS CCl4 " CH3

The vice president of sales and the vice president of manufacturing are arguing about whether their salaries are product costs or period costs. How would you settle the argument?

Walds equation can also be proved by using renewal reward processes. Let N be a stopping time for the sequence of independent and identically distributed random variables Xi,i 1. (a) Let N1 = N....

The town of Hillsboro recently purchased a 55-acre tract of farm land, and it has $550,000 budgeted to develop recreational facilities. The impetus for the purchase was the need for more soccer...

A bank offers a loan that will require you to pay 7 % interest compounded monthly. Which of the following is closest to the EAR charged by the bank? 5 . 7 8 % 8 . 6 8 % 7 . 2 3 % 1 4 . 4 6 %

What motivates a parent to bribe key people to get their kid admitted to a prestigious university? That is the ethical question of Operation Varsity Blues. In March 2019, the story broke of an...

(c) Assuming that the perpetual inventory method is used and costs are computed at the time of each withdrawal, what is the gross profit if the inventory is valued at FIFO? (d) Why is it stated that...

Compute the value of the test statistic for the following sample, for testing H0: m = 50 versus H1: m Answered: 1 week ago

One $\mathrm{J} / \mathrm{kg}$ is equal to (a) $1 \mathrm{kPa} \cdot \mathrm{m}^{3}$ (b) $1 \mathrm{kN} \cdot \mathrm{m} / \mathrm{kg}$ (c) $0.001 \mathrm{~kJ}$ (d) \(1 \mathrm{~N} \cdot...

On 5 January, the day of her successful grand opening of Hair Affair Pty Ltd, Kate Brown collected $$2280$ in cash for hair styling services, and paid $$400$ in wages and $$92$ for rent. Kate...

For the four unrelated situations, A-D, calculate the unknown amounts indicated by the letters appearing in each column: A B Beginning Assets... Liabilities. $28,000 $12,000 $28,000 $ (d) 18,600...

The following items could appear on a bank reconciliation: a. Outstanding checks b. Deposits in transit c. NSF check d. Bank collection of our note receivable e. Interest earned on bank balance f....

H How do you get loss from disposal of discontinued segment net of tax and income from operations of disconuinted segment net of tax ? Superb Homes Corporation provided he following statement o net...

A business had revenues of $280,000 and operating expenses of $315,000. Did the business (a) Incur a net loss (b) Realize net income?

Find a company in your area that uses BPMN. Interview analysts and users about this business process modeling approach. What do they think of it? How useful is it? Ask for some examples of diagrams...

Change the recurring costs in Problem and Exercise 5-43 to $40,000 and redo the analysis. Problem and Exercise 5-43 Change the time horizon in Problem and Exercise 5-35 to three years and redo the...

Draw a use case diagram for the situation described in Problem and Exercise 7-40. Problem and Exercise 7-40 Starting with a context diagram, draw as many nested DFDs as you consider necessary to...

A particle moving in the xy-plane has velocity at t = 0. It undergoes acceleration where b and c are constants. Find an expression for the particles velocity at a later time t?

Ships A and B leave port together. For the next two hours, ship A travels at 20 mph in a direction 30 west of north while ship B travels 20 east of north at 25 mph. a. What is the distance between...

A high-speed drill rotating ccw at 2400 rpm comes to a halt in 2.5 s. a. What is the magnitude of the drills angular acceleration? b. How many revolutions does it make as it stops?