Your task is to design a database for a School, considering only the following points: (a)...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 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
Systems analysis and design
ISBN: ?978-1118808177
5th edition
Authors: Alan Dennis, Barbara Haley Wixom, Roberta m. Roth
Posted Date:
Students also viewed these databases questions
-
A course in economics was taught to two groups of students, one in a classroom situation and the other online. There were 24 students in each group. The students were first paired according to...
-
A professor has been asked to teach a course in social science statistics off-campus to a class of graduate students enrolled in the Continuing Education Program of the University. Because the...
-
A professor has been asked to teach a course in social science statistics off-campus to a class of graduate students enrolled in the Continuing Education Program of the University. Because the...
-
A saver invests 100,000 in a savings account which pays a stated annual rate of interest of 4.5% compounded quarterly. Assuming no additional deposits or withdrawals, how much is in the account at...
-
Write the orbital diagram for the ground state of the arsenic atom. Give all orbitals.
-
Charles is a 60% partner in CD Partnership, a calendar year partnership. For 2023, Charles received a Schedule K-1 that reported his share of partnership items as follows: In addition, Charles and...
-
Determine whether the random variable x is discrete or continuous. Explain your reasoning. (a) Let x represent the number of lightning strikes that occur in Wyoming during the month of June. (b) Let...
-
The following table gives the systolic blood pressure (SBP), body size (QUET), age (AGE), and smoking history (SMK = 0 if a nonsmoker, SMK = 1 if a current or previous smoker) for a hypothetical...
-
You think the political solutions presented by the author are still valid or are other strategies required? "A System at Risk is a comprehensive analysis of the transportation dilemma in the United...
-
In a pest-eradication program, sterilized male flies are released into the general population each day. Ninety percent of those flies will survive a given day. How many flies should be released each...
-
A company has two manufacturing departments Shaping and Painting. The company uses job - order costing and provides the following estimated overhead costs for the month of May: Beginning - of -...
-
A patient asked the pharmacist at Redwing Pharmacy if she could get her diazepam prescription transferred to Redwing from Bluewing Pharmacy, which was in another part of the town. The pharmacist said...
-
For each of the following events, how would an economist using a 10-year-old market basket create a bias in measuring the change in the cost of living today? a. A typical family owns more cars than...
-
Mary, a patient at Primrose Pharmacy, requested a refill of her diazepam prescription on June 12. The prescription was issued on April 15 and written for one refill, which she received on May 10....
-
Describe the short-run effects of each of the following shocks on the aggregate price level and on aggregate output. a. The government sharply increases the minimum wage, raising the wages of many...
-
A patient presented a prescription to the pharmacy for Oxycontin 10 mg, #60, 1 tablet bid. The patient had no insurance and told the pharmacist that she could only afford to pay for 20 tablets...
-
A perfectly competitive firm has the following fixed and variable costs in the short run. The market price for the firm's product is $140. Output FC VC TC TR Profit/Loss 0 $75 $0 ___ ___ ___ 1 75 90...
-
1. Advertising for eyeglasses _________ (increases/decreases) the price of eyeglasses because advertising promotes _________. 2. An advertisement that succeeds in getting consumers to try the product...
-
The Amberssen Specialty Company is a chain of 12 retail stores that sell a variety of imported gift items, gourmet chocolates, cheeses, and wines in the Toronto area. Amberssen has an IS staff of...
-
Should the analysis phase be eliminated or reduced when we intend to use a software package instead of custom development or outsourcing?
-
Describe two ways to handle a situation in which there are a large number of use cases.
-
The balance sheet of Dot Co. for the year ended 31 December 20X2, together with comparative figures for the previous year, is shown in Figure 13.7 (all figures :000). You are informed that there were...
-
Under IFRS, a group is a set of entities that the parent: A. Significantly influences. B. Owns a majority of the voting power in. C. Jointly controls. D. Controls.
-
Under IFRS 10, control over an entity means: A. Power to govern its financial and operating policies. B. The right to appoint the majority of its Board members. C. Power to affect the variable...
Study smarter with the SolutionInn App