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...
-
A position control system may be constructed by using an AC motor and AC components, as shown in Figure P8.13.The syncro and control transformer may be considered to be a transformer with a rotating...
-
Calculate the internal energy per \(\mathrm{kg}\) of superheated steam at 10 bar and a temperature of \(300^{\circ} \mathrm{C}\). Find, also change in internal energy if this steam is expanded to 1.4...
-
(a) Use Figure \(7.2 a\) to calculate the kinetic energies of the two carts at \(t=30,60\), and \(90 \mathrm{~ms}\). (b) What is the kinetic energy of the system at each instant? Figure 7.2...
-
Use the information in Exercise 25 to compute total cost for each revenue-generating area if Prosperous Bank uses the step method of cost allocation.
-
6. 7. 8. If one of the diameters of the circle x + y-2x-6y+6=0 is a chord of another circle 'C', whose centre is at (2, 1), then its radius is Let Bi (i = 1, 2, 3) be three independent events in a...
-
Parent owns an 80% interest in Sub and at 12/31/11, Parent's investment in Sub on an equity basis was equal to 80% of Sub's stockholders' equity. During 2012, Sub sells inventory to Parent for...
-
Exercise 3: Exchange Rates USDCNY 6.76 EURUSD = $1.30 GBPUSD=$1.57 USDMXN = 12.7 USDJPY = 85.18 CADUSD=$0.96 1.How many yuan could Bank X get for 100,000 USD? 2.How many USD could Bank X get for...
-
Describe the rule-making process of the EPA, including a discussion of the Federal Register and U.S. Code of Federal Regulations (C.F.R.)
-
In a response to public outcry over the Internal Revenue Service's (IRS) extent and abuse of power, the Federal government has decided to disband the IRS in favor of creating a new administrative...
-
Provide Cost/benefit analysis of 3 companies who implemented their supply chain ( reduction of carbon emission in transporation) 1. Provide Impact of performance - compare revenue or results for...
-
On December 31, 2023, LS Corporation revoked its S election. LS Corporation had been an S corporation since its inception in 2018. When may LS Corporation reelect S corporation status without IRS...
-
How do you navigate to the Expense Transactions report? Multiple choice question. From the Navigation Bar, go to Reports > Expenses tab > click on the Filter down-arrow > in the Date field, select...
-
Air Conditioning Engineering 5th Edition by W P Jones (pdf copy is available on the internet) 1. List the factors in the environment which affect the body's feeling of comfort and describe how they...
-
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 the following time series data. a. Construct a time series plot. What type of pattern exists in the data? b. Show the four-quarter and centered moving average values for this time series. c....
-
Refer to exercise 35. a. Deseasonalize the time series using the adjusted seasonal indexes computed in part (c) of exercise 35. b. Using Minitab or Excel, compute the linear trend regression equation...
-
The following table reports prices and usage quantities for two items in 2009 and 2011. a. Compute price relatives for each item in 2011 using 2009 as the base period. b. Compute an unweighted...
Study smarter with the SolutionInn App