Question: Question 3 Write the DML codes to create each of the tables shown above [4 Marks] Write the DDL codes to insert the data into

Question 3

  1. Write the DML codes to create each of the tables shown above [4 Marks]

  1. Write the DDL codes to insert the data into the tables as shown above. [4 Marks]

c) Identify the Superkeys for staff relation. [5 Marks]

d) Based on the tables of the above given schema, write SQL integrity enhancement features for the following constraints:

  1. bookID in Borrow must be the one that exist as code in Book .
  2. Salary must be an integer value above 0.
  3. joinedDate is not present or future dates. [12 Marks]

Answer the code show studio management the output.

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!

Q:

Question 3 Write the DML codes to create each of the tables shown above [4 Marks] Write the DDL codes to insert the data into the tables as shown above. [4 Marks] c) Identify the Superkeys for staff...

Q:

Question 3 Write the DML codes to create each of the tables shown above [4 Marks] Write the DDL codes to insert the data into the tables as shown above. [4 Marks] Identify the Superkeys for staff...

Q:

Write the SQL queries to insert the data into the tables as shown above.Question 3 The following Figure 1 shows some portion of the database of a company on medical claims. Refer to the relations,...

Q:

The following Figure 1 shows some portion of the database of a company on medical claims. Refer to the relations, Claim, Employee and Claim Type shown in the diagram and answer the following...

Q:

the following figure 1 shows some portion of the database of a company on medical claimsQuestion 3 The following Figure 1 shows some portion of the database of a company on medical claims. Refer to...

Q:

Graffiti Busters Lab 2A DDL Objectives: 1. Given an ERD, define tables and constraints on the data, using the Create Table statement in SQL Server. 2. Alter the definition of an existing table using...

Q:

1. CAN CASHAPP U 5$ TO DO THIS Write the SQL statements for creating the tables for the Employee Projects Database. Save these statements in a script called M05_LastNameFirstName_CreateTables (where...

Q:

This assignment will have you create tables and write SQl code for the three tables shown below as pa of the Orange Krate data model using Stored Procedure(SPROC) Title Type Genre PK Title Type ID...

Q:

Question No: 0 2 Consider the following relational schema for BITS where students enroll for an exam. Student ( BITSID , Name, DateOfBirth, Gender, DateOfAdmission, BranchID ) ; Branch ( BranchID ,...

Q:

Hello! I have attempted to answer the two subquery challenges in BOLD at the end of the database created below, but I am unsure of my answers. I don't have SQL available to execute the subqueries to...

Q:

You have a deal with a publisher an will receive payments over the next 5 years as follows: $10k, $20k, $30k, $40k, & $50k (from p=1 to p=5). After year five you receive annuity of $85k from the...

Q:

Passing down to the ground state, excited Ag 109 nuclei emit either gamma quanta with energy 87keV or K conversion electrons whose binding energy is 26 keV. Find the velocity of these electrons.

Q:

Family members are q , , as one family member's feelings and behaviors affect all the other members. independent relevant interdependent harmonious

Q:

Townson Company had gross wages of $180,000 during the week ended December 10. All earnings are subject to the social security tax, while the amount of wages subject to federal and state unemployment...

Q:

1 How did inventory reduction in the supply chain lead to improved competitiveness at Xerox? Once the problems of introducing just-in-time production systems had been solved at the Xerox plant making...

Q:

Select the top two product lines (in terms of sales) for your firm or one that you know well. Using the headings in Table 1.1, fill in the details for characteristics of both product lines. Aim to...

Q:

1 What are the key lessons from this case for dealing effectively with disruptions to the supply chain? In March, 2000, a thunderstorm struck the Philips semiconductor plant at Albuquerque in New...