LAIL 1. Database Design Assume that you are the database developer for this task, complete the...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
LAIL 1. Database Design Assume that you are the database developer for this task, complete the information-level design for the new database for "MIT_short_courses" that satisfies the constraints and user view requirements given below. Create a Crow's Foot Notation Entity Relationship Diagram (ERD) to support the following business operations. MIT is planning to design a data model to hold information relating to their Courses, Students, Coordinators, Instructors and Classes. User requirement/ business rule 1: As a database designer for "MIT_short_courses", you need to ensure that each student can register for one or more short courses. You need to store students' details including students ID, first name, last name, gender, age, and postal code. User requirement/ business rule 2: Each course has one Coordinator assigned to look after general administration of the course. However, each Coordinator may be assigned to one or more courses. System stores Coordinator's code, name and the school he/she attached to. Each course offers zero or more classes. Some courses are research based they do not offer classes. Each Course has an ID (for unique identification), title, credits and prerequisites. User requirement/ business rule 3: Each class has an ID, Section no, Date and Time. Each class is taught by an instructor. Instructors can teach in one or more scheduled classes. However, some Instructors are working with research students therefore no classes allocated to them in the system. Write down any assumptions you have made, if they are not explicitly described here. While completing the information-level design you are required to answer questions given below. a. Identify and list entities described in the given case scenario. b. ER diagram (5 Marks) Add attributes to those entities and select suitable primary keys for each entity. Represent the structure of your database visually by using the entity-relationship (ER) diagram. 1. You are required to mark all cardinality on the relationships. if you make any assumptions (When you mark cardinality) about data that are not explicitly given in the problem, these must be described. (5 Marks) II. You are required to use a software tool to create the ER diagram. You can use draw.io[2], Lucidchart [1], Visio or any other software tool to create the ER diagram. Note: All many to many relationships must be replaced with bridge tables. (20 Marks) LAIL 1. Database Design Assume that you are the database developer for this task, complete the information-level design for the new database for "MIT_short_courses" that satisfies the constraints and user view requirements given below. Create a Crow's Foot Notation Entity Relationship Diagram (ERD) to support the following business operations. MIT is planning to design a data model to hold information relating to their Courses, Students, Coordinators, Instructors and Classes. User requirement/ business rule 1: As a database designer for "MIT_short_courses", you need to ensure that each student can register for one or more short courses. You need to store students' details including students ID, first name, last name, gender, age, and postal code. User requirement/ business rule 2: Each course has one Coordinator assigned to look after general administration of the course. However, each Coordinator may be assigned to one or more courses. System stores Coordinator's code, name and the school he/she attached to. Each course offers zero or more classes. Some courses are research based they do not offer classes. Each Course has an ID (for unique identification), title, credits and prerequisites. User requirement/ business rule 3: Each class has an ID, Section no, Date and Time. Each class is taught by an instructor. Instructors can teach in one or more scheduled classes. However, some Instructors are working with research students therefore no classes allocated to them in the system. Write down any assumptions you have made, if they are not explicitly described here. While completing the information-level design you are required to answer questions given below. a. Identify and list entities described in the given case scenario. b. ER diagram (5 Marks) Add attributes to those entities and select suitable primary keys for each entity. Represent the structure of your database visually by using the entity-relationship (ER) diagram. 1. You are required to mark all cardinality on the relationships. if you make any assumptions (When you mark cardinality) about data that are not explicitly given in the problem, these must be described. (5 Marks) II. You are required to use a software tool to create the ER diagram. You can use draw.io[2], Lucidchart [1], Visio or any other software tool to create the ER diagram. Note: All many to many relationships must be replaced with bridge tables. (20 Marks)
Expert Answer:
Related Book For
College Accounting A Contemporary Approach
ISBN: 978-0077639730
3rd edition
Authors: David Haddock, John Price, Michael Farina
Posted Date:
Students also viewed these databases questions
-
The new line character is utilized solely as the last person in each message. On association with the server, a client can possibly (I) question the situation with a client by sending the client's...
-
The General Auditors Office (GAO) of ABC jurisdiction issued a report on the XYZ Electric Cooperative, a large member-owned utility. This report reviewed the work of MNO Consulting. MNO found...
-
An experiment to compare the tension bond strength of polymer latex modified mortar (Portland cement mortar to which polymer latex emulsions have been added during mixing) to that of unmodified...
-
John discovered a $400 tax deduction. In order to calculate its cash benefit, should he use his marginal or average tax bracket? Why?
-
What is the relationship between globalization and nationalism in the current-day world?
-
Mike Cichanowski founded Wenonah Canoe and later purchased Current Designs, a company that designs and manufactures kayaks. The kayak-manufacturing facility is located just a few minutes from the...
-
Crane Company, a machinery dealer, leased a machine to Turtle Corporation on January 1, 2025. The lease is for an 8-year period and requires equal annual payments of $64,240 at the beginning of each...
-
During 2020, you were hired as the Chief Financial Officer for MC Travel Inc., a fairly young travel company that is growing quickly. A key accounting staff member has prepared the financial...
-
On July 1,the first day of their fiscal year, the City of Denver sold bonds with a face value of $10,000,000 at 102 percent par. The bonds bear annual interest at 6 percent; interest is payable...
-
There has been a debate around the advantages and disadvantages of using performance ratings as part of the performance review process. Cite two (2) sources FOR ratings and two (2) sources AGAINST...
-
Sweeten Company had no jobs in progress at the beginning of the year and no beginning inventories. It started, completed, and sold only two jobs during the year-Job P and Job Q. The company uses a...
-
Below are the restated amounts of net income and retained earnings for Volunteers Incorporated and Raiders Incorporated for the period 2015 to 2024. Volunteers began operations in 2016, while Raiders...
-
The plant asset and accumulated depreciation accounts of Pell Corporation had the following balances at December 31, 2023: Land Land improvements Building Equipment Automobiles Plant Asset...
-
Splish Ltd. issued a $1,133,000, 10-year bond dated January 1, 2023. The bond was sold to yield 12% effective interest. The bond paid 10% interest on January 1 and July 1 each year. The company's...
-
A differential amplifier is used with a thermocouple sensor in the way shown in Figure 3.8. What values of R and R, would give a circuit which has an output of 10 mV for a temperature difference...
-
Ball bearings are widely used in industrial applications. You work for an industrial food machinery manufacturer and your role is to design the driveshaft assembly on a new type of equipment that...
-
The following transactions occurred at several different businesses and are not related. INSTRUCTIONS Analyze each of the transactions. For each transaction, set up T accounts. Record the effects of...
-
Does the employee bear any part of the SUTA tax? Explain.
-
What is the accounting cycle? Discuss.
-
A mixture containing \(15 \mathrm{~mol}\) per cent ethane, \(35 \mathrm{~mol}\) per cent propane, and \(50 \mathrm{~mol}\) per cent n-butane is brought to a condition of \(40^{\circ} \mathrm{C}\) at...
-
Ethyl alcohol and hexane form an azeotrope containing \(33.2 \mathrm{~mol}\) per cent ethanol at \(58.7^{\circ} \mathrm{C}\) and \(1 \mathrm{~atm}\) pressure. Determine the van Laar parameters at...
-
n-heptane and toluene form an ideal solution mixture. At \(373 \mathrm{~K}\), their vapour pressures are \(106 \mathrm{kPa}\) and \(74 \mathrm{kPa}\) respectively. Determine the composition of the...
Study smarter with the SolutionInn App