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...
-
Consider Gizmo, a small manufacturing company whose management wishes to reduce overhead by installing a new, energyefficient heating system. The new system costs $100,000. Due to the companys...
-
An internal control questionnaire indicates that an approved receiving report accompanies every check request. To test this control, an auditor could select and examine: a. Receiving reports, to...
-
Vassar Corp. has incurred substantial losses for several years and has decided to declare bankruptcy. The company petitioned the court for protection from creditors on March 31, 2010, and submitted...
-
Wind blows through a 7 x 10 ft garage door with a speed of 2 ft/s as shown. Determine the average speed of the air through the two 3 x 4 ft windows. 16 ft 3ft 3ft -22 ft- 2 ft/s 10ft! 30
-
1. Is it true, as Jack Carter claims, that we cant be accused of being discriminatory because we hire mostly women and minorities anyway? 2. How should Jennifer and her company address the sexual...
-
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?
-
Carbon tetrachloride displays a triple point at 249.0 K and a melting point (at 1 atm) of 250.3 K. Which state of carbon tetrachloride is more dense, the solid or the liquid? Explain.
-
A golf ball hit from a tee accelerates from rest to a speed of \(40.0 \mathrm{~m} / \mathrm{s}\) relative to the Earth reference frame. By what percent does the mass of the ball increase as it is hit?
-
An electron moving at \(0.80 c_{0}\) relative to the Earth reference frame travels the \(100-\mathrm{m}\) length of a building. What is the length of the building according to an observer moving...
-
With the product solution you created for the previous application exercise, prepare a list of product features and the benefit or benefits associated with each feature. If you were a salesperson...
-
One end of a vertical spring of spring constant \(k=1500 \mathrm{~N} / \mathrm{m}\) is attached to the floor. You compress the spring so that it is \(2.40 \mathrm{~m}\) shorter than its relaxed...
-
Two linear vectors of magnitudes 3 and 4 are added. The magnitude of the resultant vector is (a) 1, (b) 7, (c) between 1 and
-
(a) Find a solution of the initial-value problem consisting of the differential equation in Example 3 and each of the initial conditions: y(0) = 2, y(0) = -2, and y(1/4) + = 1. (b) Find the solution...
-
U.S. households have become smaller over the years. The following table from the 2010 GSS contains information on the number of people currently aged 18 years or older living in a respondent's...
-
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...
-
Compare and contrast different deadlock prevention techniques such as resource ordering, the "hold and wait" condition, and preemptive resource allocation. Which methods are most effective for...
-
The following information is taken from Aden Company's records: Product Group Units Cost/Unit Market/Unit A 1 700 $1.10 $0.90 B 1 250 1.50 1.55 C 2 150 4.90 5.15 D 2 100 6.50 6.40 E 3 80 25.00 24.60...
-
American Food Services, Incorporated leased a packaging machine from Barton and Barton Corporation. Barton and Barton completed construction of the machine on January 1, 2024. The lease agreement for...
Study smarter with the SolutionInn App