We are given the following relational database schema for a database that keeps track of student...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
We are given the following relational database schema for a database that keeps track of student enrollment in courses and the books adopted for each course. STUDENT COURSE Course# Cname Dept Ssn Name Major Bdate BOOK ADOPTION Course# Semester Book.ISBN ENROLL Ssn Course# Semester Grade TEXTBOOK ISBN Title Publisher Author a. Consider the COURSE relation. Assuming that names of courses are unique, list all the superkeys, keys, candidate keys, and select a primary key. i. Superkeys: ii. Keys: iii. Candidate keys: iv. Primary key: b. Select and underline the primary key in each relation (in the schema above). Justify your choices and state any assumption that you make. c. Circle all foreign keys and specify the referential integrity constraints by drawing directed arcs on the schema diagram on the previous page. d. Draw an ER diagram that would correspond to the relational schema above. (Drawing by hand is OK.) We are given the following relational database schema for a database that keeps track of student enrollment in courses and the books adopted for each course. STUDENT COURSE Course# Cname Dept Ssn Name Major Bdate BOOK ADOPTION Course# Semester Book.ISBN ENROLL Ssn Course# Semester Grade TEXTBOOK ISBN Title Publisher Author a. Consider the COURSE relation. Assuming that names of courses are unique, list all the superkeys, keys, candidate keys, and select a primary key. i. Superkeys: ii. Keys: iii. Candidate keys: iv. Primary key: b. Select and underline the primary key in each relation (in the schema above). Justify your choices and state any assumption that you make. c. Circle all foreign keys and specify the referential integrity constraints by drawing directed arcs on the schema diagram on the previous page. d. Draw an ER diagram that would correspond to the relational schema above. (Drawing by hand is OK.)
Expert Answer:
Answer rating: 100% (QA)
ACOURSE RELATION i Super keys Course Cname Course Cnam... View the full answer
Related Book For
Auditing and Assurance services an integrated approach
ISBN: 978-0132575959
14th Edition
Authors: Alvin a. arens, Randal j. elder, Mark s. Beasley
Posted Date:
Students also viewed these programming questions
-
Consider the following relations for a database that keeps track of business trips of salespersons in a sales office: SALESPERSON (SSN, Name, Start_Year, Dept_No) TRIP (SSN, From_City, To_City,...
-
Consider the following relations for a database that keeps track of student enrollment in courses and the books adopted for each course: STUDENT (SSN, Name, Major, Bdate) COURSE (Course#, Quarter,...
-
We are given the following probability distribution. a. Calculate the mean, variance, and standard deviation. b. Suppose that Y = 3X + 2. For each value of X, determine the value of Y. What is the...
-
Scott incorporates his sole proprietorship as Superior Corporation and transfers its assets to Superior in exchange for all 100 shares of Superior stock and four $7,500 interest-bearing notes. The...
-
Provide an example of a prepaid expense. The adjusting entry associated with a prepaid expense always includes a debit and credit to which account classifications?
-
1. From the information provided in the case, do you think Target Canada demonstrated good planning in regard to its expansion into Canada? Identify at least three things the company did (right or...
-
You need to understand the approach described in question 3 in More Genetic TIPS before answering this question. A gene that is normally expressed in pancreatic cells was cloned and then subjected to...
-
Denny Asbestos Removal Company removes potentially toxic asbestos insulation and related products from buildings. The companys estimator has been involved in a long-simmering dispute with the on-site...
-
Show that the mean square estimate is the mean of the posterior den- sity. Show this by differentiating eq. (13) at the lecture slides with respect to and set the obtained gradient to zero. Now the...
-
Because Natalie has had such a successful first few months, she is considering other opportunities to develop her business. One opportunity is the sale of fine European juicing machines. The owner of...
-
1. Jack James is completing the audit of the purchases payables payments cycle. Which one of the following procedures that Jack is performing would test payables for completeness? a) Select a sample...
-
For both Twitter and Facebook forecasts the Income Statement Uses the sales growth assumption to forecast sales for the next fiscal year. Use costlevel assumptions to forecast all the operating...
-
Suppose that a stock price has an expected return of 16% per annum and a volatility of 30% per annum. When the stock price at the end of a certain day is $50, calculate the following: (a) The...
-
Companys dividend next year is expected to be $1.00 (D1). The stock price is $20. The company is expected to have a constant 4.25% constant growth rate in dividends. What is the companys cost of...
-
Is the answer correct? The graph of a y = f(x) is shown. 6 + 5 14 m ~ 1 -6 -5 -4 -3 2 -1 -1 -2 -3 A w -4 -5- -6+ 1 2 3 4 The domain of f(x) is x = [-3,3] The domain of g(x) = notation) S 6 f(x) is a ...
-
Let f(x) = 1 x-4 g(f(x)) = and g(x)= = 3 - X +4. Find the following functions. Simplify your answers. f(g(x)) =
-
A 85-cm long solenoid is to produce a magnetic field of 0.85 mT at its center. How much current should the solenoid carry if it has 2000 turns of wire? A. Normal format with 3 SF
-
Identify one local business that uses a perpetual inventory system and another that uses a periodic system. Interview an individual in each organization who is familiar with the inventory system and...
-
In the audit of the James Mobley Company, you are concerned about the possibility of contingent liabilities resulting from income tax disputes. Discuss the procedures you could use for an extensive...
-
Multiple Choice Questions The following questions concern the planning of the engagement. Select the best response. a. Which of the following is an effective audit planning procedure that helps...
-
Assume that a sample of 100 units was obtained in sampling the inventory in Question. Assume further that the following three misstatements were found: Calculate adjusted misstatement bounds for the...
-
One difference between accounting for a governmental (not-for-profit) unit and a commercial (for-profit) enterprise is that a governmental unit should a. Not record depreciation expense in any of its...
-
Carson Citys general fund issued purchase orders of $630,000 to vendors for supplies. Which of the following entries should the city make to record this transaction? Debit Credit Q. ENCUMBRANCES...
-
Belle Valley incurred $100,000 of salaries and wages for the month ended March 31, 20X2. How should this be recorded on that date? c. Expenditures Salaries and Wages Debit Vouchers Payable Salaries...
Study smarter with the SolutionInn App