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...
-
Greek Peak is a ski resort in upstate New York. The company sells lift tickets, ski lessons, and ski equipment. It operates several restaurants and rents townhouses to vacationing skiers. The...
-
In Exercises determine whether the statement is true or false. If it is false, explain why or give an example that shows it is false. The acceleration of an object is the derivative of the speed.
-
Daniel Charon is the loan officer of the Georgian Bay Bank. Georgian Bay Bank has a loan of \($540,000\) outstanding from Regional Delivery Service Ltd., a company specializing in the delivery of...
-
The beginning inventory at Midnight Supplies and data on purchases and sales for a three-month period ending March 31 are as follows: Instructions 1. Record the inventory, purchases, and cost of...
-
what step in this process gives you the most trouble and why in making a purchase? Or, what step do you find yourself constantly overlooking and how do you plan to resolve that issue once and for all...
-
The finance director of RM plc is considering several investment projects and has collected the following information about them. Projects D and E are mutually exclusive. The capital available for...
-
Tom, James and Alex operate a coffee shop as a partnership. The partnership agreement stipulates that all partners are to share the residual. Profits equally once the salary of Tom, the caf manager,...
-
A company estimates the following manufacturing costs at the beginning of the period: direct labor, $532,000; direct materials, $196,000; and factory overhead, $123,000. Required: 1. Compute its...
-
7) A coin is tossed and a standard six-sided die is rolled. a) How many different outcomes are possible? b) What is the probability of flipping tails and rolling a number greater than 4? 8) The...
-
You get two attempts on this assignment? Why? Because people get creative and add extra symbols in the Boxes and then it's wrong. This way you have a second attempt to get the questions correct....
-
Use the table to calculate the total Calories ineach food. Calorie Content and Examples of Carbohydrates, Proteinsand Fats Type of biomolecule Representative foods Calorie content (Cal/g)...
-
7. Petra's custom ornaments personalizes ornaments on the spot. She has a small kiosk at the mall, where customers walk up, select the ornament and specify the personalization. Petra can have up to...
-
Which answer choice correctly completes the folloiwng statement? " Ways to 'game' the budgeting process include ________." Group of answer choices "delaying sales if just short of a target"...
-
TRUE OR FALSE: 1. Banks with a significantly large share of fixed-interest rate home loans are less exposed to interest rate risks. 2. Although Australian banks are pretty big, they are not...
-
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.
-
Pennant Corporation acquired 80 percent of Saylor Company's common stock for \($12,000,000\) in cash. At the date of acquisition, Saylor's \($3,000,000\) of reported net assets were fairly stated,...
-
Palm Resorts acquired its 70 percent interest in Sun City on January 1, 2014, for \($35,200,000.\) The fair value of the 30 percent non-controlling interest at the date of acquisition was...
-
Peregrine Company acquired 80 percent of Sparrow Company's common stock for \($22,000,000\) in cash; fees paid to an outside firm to estimate the earning power of Sparrow and the fair values of its...
Study smarter with the SolutionInn App