Because of referential integrity, before any row can be entered into the SECTION table, the CourseID to
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 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.
Transcribed Image Text:
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)
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 60% (15 reviews)
See the SECTIONFK ...View the full answer
Answered By
Charles mwangi
I am a postgraduate in chemistry (Industrial chemistry with management),with writing experience for more than 3 years.I have specialized in content development,questions,term papers and assignments.Majoring in chemistry,information science,management,human resource management,accounting,business law,marketing,psychology,excl expert ,education and engineering.I have tutored in other different platforms where my DNA includes three key aspects i.e,quality papers,timely and free from any academic malpractices.I frequently engage clients in each and every step to ensure quality service delivery.This is to ensure sustainability of the tutoring aspects as well as the credibility of the platform.
4.30+
2+ Reviews
10+ Question Solved
Related Book For
Essentials of Database Management
ISBN: 978-0133405682
1st edition
Authors: Jeffrey A. Hoffer, Heikki Topi, Ramesh Venkataraman
Question Posted:
Students also viewed these Computer science 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?
-
. 4. Bank overdrafts repayable on * 1 point demand may be included in the cash and cash equivalent balance. True O False
-
An estimated 1.8 million students take on student loans to pay ever-rising tuition and room and board (The New York Times, April 17, 2009). It is also known that the average cumulative debt of recent...
-
The file azcounties.dat gives data from the 2000 U.S. Census on population and housing unit counts for the counties in Arizona (excluding Maricopa County and Pima County, which are much larger than...
-
When to use a settlement brochure?
-
Multiple-Choice Questions 1. The key difference between residual income and economic value added is that EVA a. Uses the actual cost of capital for the company rather than a minimum required cost of...
-
E10.5 (LO 1, 2) (Treatment of Various Costs) Ben Sisko Supply Company, a newly formed corpora- tion, incurred the following expenditures related to Land, to Buildings, and to Machinery and Equipment....
-
A telemarketer is planning to set up a phone bank to bilk widows with a Ponzi scheme. His past experience (prior to his most recent incarceration) suggests that each phone will be in use half the...
-
Which student has the highest Read score? The database tracks an adult literacy program. Tutors complete a certification class offered by the agency. Students complete an assessment interview that...
-
Choose Oracle data types for the attributes in the normalized relations that you created in Problem and Exercise 19 in Chapter 4. Data from Exercise 19. Figure 4-35 includes an EER diagram for a...
-
State the closed World Assumption.
-
The following balances were extracted from the books of Mr Try, a window cleaner. He has no knowledge of double entry bookkeeping but records everything correctly. His year end is 30 June and the...
-
R. Jack gives you the following information as at 31 March 2018: Jack's mark-up is 40% on 'cost of goods sold'. His average inventory during the year was 17,000. Draw up a statement of profit or loss...
-
Gail Dawson is the owner of a retail business. She has employed an inexperienced bookkeeper to maintain her accounting records. (a) On 31 March 2016, the end of the business's accounting year, the...
-
The following trading account is extracted from the statement of profit or loss for the year ending 31 December 2015 and is given to you by the owner of the business, S. Vane: Vane says that he...
-
The following information is available for the years 2014, 2015 and 2015: The inventory valuations used above at the end of 2014 and at the end of 2015 were inaccurate. The inventory at 31 December...
-
Sometimes neon signs located near a powerful radio station are seen to glow faintly at night, even though they are not turned on. What is happening?
-
You've been asked to take over leadership of a group of paralegals that once had a reputation for being a tight-knit, supportive team, but you quickly figure out that this team is in danger of...
-
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...
-
Haliburton Mills Inc. is a large producer of men's and women's clothing. The company uses standard costs for all of its products. The standard costs and actual costs for a recent period are given...
-
A block with a mass of 11 kg is placed on a inclined plane with an angle of inclination of 45 degrees. The coefficient of kinetic friction between the block and the surface is 0 . 2 . a . Calculate...
-
Hengxi has calculated that he needs $105,000 his first year of retirement to maintain his standard of living. He expects to receive $3,500 per month from his employer defined-benefit pension and...
Study smarter with the SolutionInn App