Determine the relationships among the four entities in Figure 7-15. List primary keys for each entity and
Question:
Determine the relationships among the four entities in Figure 7-15. List primary keys for each entity and any foreign keys necessary to establish the relationships and maintain referential integrity. Pay particular attention to the data contained in TUTOR REPORTS when you set up its primary key.
Transcribed Image Text:
TUTOR (TutorID, CertDate, Status) MATCH HISTORY (MatchID, TutorlD, StudentID, StartDate, EndDate) TutorID CertDate Status 1/05/2008 Active 1/05/2008 Temp Stop 1/05/2008 Dropped 5/22/2008 Active 5/22/2008 Active 5/22/2008 Temp Stop 5/22/2008 Active 100 MatchID TutorID StudentID StartDate EndDate 101 3000 1/10/2008 100 102 103 101 3001 1/15/2008 5/15/2008 104 3002 2/10/2008 3003 5/28/2008 3 102 3/01/2008 105 106 106 3004 6/01/2008 103 6/15/2008 STUDENT (StudentID, Read) 3005 6/01/2008 3006 6/01/2008 104 6/28/2008 104 StudentID Read 3000 2.3 3001 5.6 3002 1.3 TUTOR REPORT (MatchID, Month, Hours, Lessons) 3003 3.3 Month 1 6/08 MatchID Hours Lessons 3004 2.7 4 3005 4.8 4| 6/08 8. 3006 7.8 5 6/08 4 4 3007 1.5 4 7/08 10 7/08 4
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 66% (6 reviews)
Tutor Primary key TutorID Foreign key none Student Primary key StudentID Foreign key no...View the full answer
Answered By
PALASH JHANWAR
I am a Chartered Accountant with AIR 45 in CA - IPCC. I am a Merit Holder ( B.Com ). The following is my educational details.
PLEASE ACCESS MY RESUME FROM THE FOLLOWING LINK: https://drive.google.com/file/d/1hYR1uch-ff6MRC_cDB07K6VqY9kQ3SFL/view?usp=sharing
3.80+
3+ 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
-
Determine the relationships among the four relations in Figure 7-17. List primary keys for each relation and any foreign keys necessary to establish the relationships and maintain referential...
-
1. To what events must the SBRU booking system respond? Create a complete event table listing the event, trigger, source, use case, response, and destination for each event. Be sure to consider only...
-
1. Explain the advantages of locating the PRIDE database in the clouded. Flores and his partners could place it on one of their own servers in the practice. Give reasons why it would be unwise for...
-
1. What is the present value (PV") of an offer of $15,000 two years from now if the Opportunity Cost of Capital (OCC) is $12% per annum? 2. What is the PV of an offer to receive $12,000 three years...
-
A computer technology firm wishes to check whether the speed of a new processor exceeds that of an existing processor when used in one of its popular laptop computer models. Accordingly, it measures...
-
A university has 807 faculty members. For each faculty member, the number of refereed publications was recorded. This number is not directly available on the database, so requires the investigator to...
-
How can a paralegal assist a lawyer with the voir dire of the jury?
-
Jasper is single and is a computer software consultant with a college degree. He feels that one of the reasons for his success is that he continually updates his knowledge by taking classes at the...
-
What are the 6 leading factors that lead to maximization of the company value?
-
Caterpillar Inc. manufactures and sells earth-moving equipment. Presented below is information on its receivables and allowance for credit losses from its 2018 Form 10-K. The Recorded Investments in...
-
Explain the processing order of a correlated subquery.
-
Care must be exercised when writing triggers for a database. What are some of the problems that could be encountered?
-
Confidence Interval for Sample of Size n 1 Based on the article An Effective Confidence Interval for the Mean with Samples of Size One and Two, by Wall, Boen, and Tweedie (American Statistician,...
-
This chapter briefly introduces the UCITA as a means of regulating the increasing volume of e-commerce and electronic contracts. Not everyone, however, is in favor of the UCITA. Using the Internet,...
-
Assume the same facts as in Problem 38, except that the executor sold the house on May 2, 2019, for $138,000. What value is used by the executor in the estate tax return? Problem 38 Kermit Ames died...
-
Zipcar is a car sharing service that Cambridge, Massachusetts, residents Robin Chase and Antje Danielson launched in 2000. Scott Griffith, a former Boeing engineer, now leads the firm. Although...
-
Why did Mendels work refute the blending hypothesis of inheritance?
-
What is the difference between cross-fertilization and self-fertilization?
-
A ray of light in air strikes a glass surface. Is there a range of angles for which total internal reflection occurs? Explain.
-
Define a traverse in Surveying?
-
The ALU supported set on less than (slt) using just the sign bit of the adder. Lets try a set on less than operation using the values -7 ten and 6 ten . To make it simpler to follow the example, lets...
-
A simple check for overfl ow during addition is to see if the CarryIn to the most significant bit is not the same as the CarryOut of the most significant bit. Prove that this check is the same as in...
-
Rewrite the equations on page B-44 for a carry-lookahead logic for a 16-bit adder using a new notation. First, use the names for the CarryIn signals of the individual bits of the adder. That is, use...
-
Ala was prosecuted for murder of his friend Sam. Ala admitted that they had argued and that he had punched Sam, knocking him down. However, when testifying in his own defence, he claimed that the...
-
Going back to this week's recording, revise what you learnt about the doctrine of precedent. In the famous House of Lords case of Donoghue v Stevenson [1932] AC 562, the Court determined that the...
-
Joker invites Batman and Robin to his home for tea. Peter Paralegal who is also attending the meeting, presents a will he prepared. He asks Batman and Robin to be physically present when Joker signs...
Walsh Functions In Signal And Systems Analysis And Design 1st Edition - ISBN: 0442282982 - Free Book
Study smarter with the SolutionInn App