Question: Because of referential integrity, before any row can be entered into the SECTION table, the CourseID to be entered must already exist in the COURSE

Because of referential integrity, before any row can be entered into the SECTION table, the CourseID to be entered must already exist in the COURSE table. Write an SQL assertion that will enforce this constraint.

The class scheduling 3NF relations along with some sample data shown in Figure 6-10. Not shown in this figure are data for an ASSIGNMENT relation, which represents a many-to-many relationship between faculty and sections.

STUDENT (StudentID, StudentName) QUALIFIED (FacultylD, CourselD, DateQualified) StudentID StudentName FacultylD CourselD DateQualified 38214 Letersky Altvater 2143 ISM 3112 9/1988 54907 2143 ISM 3113 9/1988 66324 Aiken 3467 ISM 4212 9/1995 70542 Marra 3467 ISM 4930 9/1996 4756 ISM 3113 9/1991 4756 ISM 3112 9/1991 .. FACULTY (FacultyID, FacultyName) SECTION (SectionNo, Semester, CourselD) FacultyID FacultyName SectionNo Semester CourselD 2143 Birkin 2712 1-2008 ISM 3113 3467 Berndt 2713 1-2008 ISM 3113 4756 Collins 2714 1-2008 ISM 4212 2715 1-2008 ISM 4930 .. COURSE (CourselD, CourseName) REGISTRATION (StudentID, SectionNo, Semester) CourselD CourseName StudentID SectionNo Semester ISM 3113 ISM 3112 Syst Analysis Syst Design Database Networking 38214 2714 2714 1-2008 1-2008 54907 54907 ISM 4212 2715 1-2008 ISM 4930 66324 2713 1-2008 FIGURE 6-10 Class scheduling relations (missing ASSIGNMENT)

Step by Step Solution

★★★★★

3.47 Rating (176 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

See the SECTIONFK ... 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 Essentials Database Management Questions!

Define the term referential integrity constraint. Why is referential integrity important? How is the term foreign key used in the context of referential integrity?

What is referential integrity? Describe how it is enforced when a new foreign key value is created, when a row containing a primary key is deleted, and when a primary key value is changed.

Why are entity integrity and referential integrity important in a database?

BYGB/ISGB 7973: ASSIGNMENT 2 DATABASE MANAGEMENT SQL Assignment Part I You may want to use the CreateTable_TG.ddl that we used for the TradeGroup an exemplar for this question. This exercise is based...

Microsoft Access Assignment: Please Post Link to Download: 6-36. Use SQL to define the following view: StudentID StudentName 38214 Letersky 54907 Altvater 54907 Altvater 66324 Aiken 6-37. Because of...

Because of referential integrity, before any row can be entered into the SECTION table, the CourseID to be entered must already exist in the COURSE table. Write an SQL assertion that will enforce...

. To enforce referential integrity, before any row can be entered into the SECTION table, the CourseID to be entered must already exist in the COURSE table. Write an SQL assertion that will enforce...

Because of referential integrity, before any row can be entered into the SECTION table, the CourseID to be entered must already exist in the COURSE table. Write an SQL assertion that will enforce...

5-36. Use SQL to define the following view: STUDENTID STUDENTNAME 5-37. To enforce referential in- tegrity, before any row can be entered into the SECTION table, the CourseD to be entered must...

For this set of Review Questions, we will create and use a database for the Wedgewood Pacific Corporation (WPC) that is similar to the Microsoft Access database we created and used in Chapters 1 and...

Suppose that you had information that consumption expenditures for a particular good were a function of income, given by the relationship C = 1,200 + 0.3Y where C is consumption expenditure and Y is...

An extract of the Pre-adjustment trial balance of Tokia Holiday Accommodation (Pty) Ltd for the year ended 28 February 2022 are presented to you. Debit Credit Insurance paid in advance 18 000 Rentals...

Retained Earnings (RE) at the end of the reporting period (Jan-Dec) is calculated as follows: Question 4 Select one: a. RE Jan 1 (+) Net Income (-) Stock Dividends paid/declared (=) RE Dec 31 b. RE...

What strengths would you bring to a governing board? Regulatory board? Advisory board?

For each function f (n) and time t in the following table, determine the largest size n of a problem P that can be solved in time t if the algorithm for solving P takes f (n) microseconds (one entry...

Given an n-element array X, Algorithm D calls Algorithm E on each element X[i]. Algorithm E runs in O(i) time when it is called on element X[i]. What is the worst-case running time of Algorithm D?

Al and Bob are arguing about their algorithms. Al claims his O(nlogn)-time method is always faster than Bobs O(n 2 )-time method. To settle the issue, they perform a set of experiments. To Als...

Find the indicated probability. Round to three decimal places. 27) A test consists of 10 true/false questions. To pass the test a student must answer at least 9 questions correctly. If a student...

Brooks Company leases a machine from TCS Company on 1 / 1 / 2 3 . Given: wet ered 5 out of g question Asset FMV $ 1 0 0 , 0 0 0 Asset Book Value $ 8 5 , 0 0 0 January 1 payments $ 2 0 , 7 1 1...

Upton Computers makes bulk purchases of small computers, stocks them in conveniently located warehouses, ships them to its chain of retail stores, and has a staff to advise customers and help them...