rn Make sure that you explain in detail all your steps - thoughts. You may get extra
Fantastic news! We've Found the answer you've been seeking!
Question:
rn
Transcribed Image Text:
Make sure that you explain in detail all your steps - thoughts. You may get extra points for an appropriate observation, you may lose some marks due to an obscure solution. 1. Your task is to design a database for a School, considering only the following points: (a) Every INSTRUCTOR in the database will have also but not only a name (composite attribute (5 points)), an address, and a telephone number (multi valued attribute (5 points)). (b) An instructor may teach different COURSEs, and every course is taught by only 1 instructor (5 points) (c) Be careful because we want to be able to select the instructors by their surname, i.e. to query the database by instructor's surname (5 points) (d) A STUDENT follows different courses, and every course is followed by more than 1 student (5 points) (e) The database memorizes the grades of every student (10 points) (f) The database stores also special students, who do not follow any course (5 points) (g) Every course has pre-requisites, which are courses too (10 points) (h) Some courses are divided into SECTIONS (5 points) with the only (5 points) attributes "Section_id", "day" and "time". Please notive that the attribute Section_id is unique ONLY within the course entity, e.g. we may have 2 sections having Section_id = 1, day= Friday, time = 10.00 one for the course CMPE 351 and one for the course CMPE 561. Questions: (i) {5 + 5 points} Design the ER diagram and schema (ii) {5 + 5 points} Which type of relationships do you have? Discuss both the cardinality and the participation constraints (iii) {10 points} Give the corresponding relational schema of your database (iv) {5 points} Give a possible snapshot of your database containing at least 5 (If mean full 5 points more) entries Make sure that you explain in detail all your steps - thoughts. You may get extra points for an appropriate observation, you may lose some marks due to an obscure solution. 1. Your task is to design a database for a School, considering only the following points: (a) Every INSTRUCTOR in the database will have also but not only a name (composite attribute (5 points)), an address, and a telephone number (multi valued attribute (5 points)). (b) An instructor may teach different COURSEs, and every course is taught by only 1 instructor (5 points) (c) Be careful because we want to be able to select the instructors by their surname, i.e. to query the database by instructor's surname (5 points) (d) A STUDENT follows different courses, and every course is followed by more than 1 student (5 points) (e) The database memorizes the grades of every student (10 points) (f) The database stores also special students, who do not follow any course (5 points) (g) Every course has pre-requisites, which are courses too (10 points) (h) Some courses are divided into SECTIONS (5 points) with the only (5 points) attributes "Section_id", "day" and "time". Please notive that the attribute Section_id is unique ONLY within the course entity, e.g. we may have 2 sections having Section_id = 1, day= Friday, time = 10.00 one for the course CMPE 351 and one for the course CMPE 561. Questions: (i) {5 + 5 points} Design the ER diagram and schema (ii) {5 + 5 points} Which type of relationships do you have? Discuss both the cardinality and the participation constraints (iii) {10 points} Give the corresponding relational schema of your database (iv) {5 points} Give a possible snapshot of your database containing at least 5 (If mean full 5 points more) entries
Expert Answer:
Related Book For
Posted Date:
Students also viewed these databases questions
-
The norm of a linear transformation TA: Rn Rn can be defined by where the maximum is taken over all nonzero x in Rn. (The subscript indicates that the norm of the linear transformation on the left is...
-
Suppose that f: Rn R and g: Rn Rn are differentiable on Rn and that there exist r > 0 and a Rn such that Dg(x) is the identity matrix, I, for all x Br(a). Prove that there is a function h: Br(a) {a}...
-
Let 5: Rn Rn and T: Rn Rn be linear transformations with matrices A and B respectively. [Theorem 3.] (a) Show that B2 = B if and only if T2 = 7 (where T2 means T o T). (b) Show that B2 = 1 if and...
-
The Chief Financial Officer at Ford Motor Company is said to usea hybrid-costing system. Define the hybrid-costing system. Explainthe advantages to this company to use this system. I want a 10 page 2...
-
On April 19, 2005, KPMG agreed to pay $22 million to the SEC to settle its lawsuit with the SEC in connection with the alleged fraud. Go to the SEC's web site to read about the settlement of this...
-
When do companies have to consider country or political risk?
-
Explain why it is important to report communicable diseases, adverse drug reactions, and infectious diseases.
-
After the partnership has been operating for a year, the Capital accounts of Martin and Steven are $30,000 and $20,000, respectively. Sania buys a one-sixth interest in the partnership by investing...
-
A process with no beginning work in process inventory completed and transferred out 81000 units during a period and had 45000 units in the ending work in process inventory that were 30% complete....
-
In this mini-case you will perform some procedures required as a part of audit planning. For ease your audit manager has already organized the workpapers and completed several of the required...
-
A small Chinese restaurant has a seating capacity of 6. It is observed that the average customer will stay in the restaurant (occupy a seat) for 20 minutes (exponentially distributed). Customers...
-
Given an instance of Stream s and Collection c, which of the following are valid ways of creating a parallel stream? (Choose three.) A. c.parallel() B. c.parallel().parallelStream() C....
-
Which can independently fill in the blank to output No dessert today? A. get("No dessert today") B. orElse("No dessert today") C. orElseGet(() -> "No dessert today") D. orElseThrow() E. None of the...
-
What are private portfolio flows? What factors do you believe are most important in determining the amount and direction of such flows?
-
How do the trade policies of developed countries affect the ability of less developed countries to benefit from greater participation in the world economy? How do nontrade domestic economic policies...
-
What is the output of the following application? A. 100 B. 200 C. 250 D. The code does not compile because of line j1. E. None of the above. package savings; import java.util. function. *; public...
-
ABC, Inc. just paid dividend of $5.21. The dividends are expected to grow at 7.63% each year forever. The required rate of return on the stock is 11.01%. What is today's price of the stock? Enter...
-
Refer to the information from Exercise 22-19. Use the information to determine the (1) Weighted average contribution margin , (2) Break-even point in units, and (3) Number of units of each product...
-
Why may the top managers of a firm be tempted to use misleading estimates of revenues and expenses? How may managers be able to boost the reported earnings of their firm?
-
Who typically files Form 1040EZ? Which tax form do most other individual taxpayers file?
-
This month you made a mortgage payment of $ 700, of which $ 600 was an interest payment and $ 100 a payment of the loan principal. You are in the 25% marginal tax bracket. What is the tax savings as...
-
Consider an \(S U(3)\) nonabelian gauge theory with coupling to eight real scalar fields in the adjoint representation, \(\phi^{a}\) for \(a=1, \ldots, 8\). The covariant derivative is then...
-
Recall that Programming Exercise 3 in Chapter 8 asked you to design a program that lets the user enter the total rainfall for each of 12 months into an array. The program should calculate and display...
-
(a) Use the definition of the Fermi coupling constant in Eq. (5.2.7) and the low-momentum limit of the tree-level contribution to the scattering \(e^{-} \bar{u}_{e} ightarrow \mu^{-} \bar{u}_{\mu}\)...
Study smarter with the SolutionInn App