Design a complete Entitity Relation Diagram (ERD) for the following scenario The following gives the specific...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Design a complete Entitity Relation Diagram (ERD) for the following scenario The following gives the specific requirements for a University. 1. There are many academic sections in the university. Each academic section is recorded with academic section Id, name and long name. 2. Each academic section offers many units; each unit is recorded with unit Id, unit code, name, credit and the academic section that offers the unit. 3. One unit can be offered in many teaching periods. Each teaching period is recorded with teaching period Id, year, teaching period of the year, start date,end date, break start date and break end date. 4. Each person is recorded with person Id, password, family name, given name,title, email and date of birth. 5. Each student is recorded with student Id, student type (i.e. international or local). 6. One staff works for an academic section. We record their staff Id, office, phone and the academic section they work for. 7. The database also records what units a student is enrolled in, and the grade and mark a student gains in each unit. Design a complete Entitity Relation Diagram (ERD) for the following scenario The following gives the specific requirements for a University. 1. There are many academic sections in the university. Each academic section is recorded with academic section Id, name and long name. 2. Each academic section offers many units; each unit is recorded with unit Id, unit code, name, credit and the academic section that offers the unit. 3. One unit can be offered in many teaching periods. Each teaching period is recorded with teaching period Id, year, teaching period of the year, start date,end date, break start date and break end date. 4. Each person is recorded with person Id, password, family name, given name,title, email and date of birth. 5. Each student is recorded with student Id, student type (i.e. international or local). 6. One staff works for an academic section. We record their staff Id, office, phone and the academic section they work for. 7. The database also records what units a student is enrolled in, and the grade and mark a student gains in each unit.
Expert Answer:
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these programming questions
-
read the following article titled, "The Effect of Intercultural Education on the Ethnocentrism Levels of Prospective Teachers," written by Selma Aslantas and published in March 2019.(Links to an...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Case Study: Quick Fix Dental Practice Technology requirements Application must be built using Visual Studio 2019 or Visual Studio 2017, professional or enterprise. The community edition is not...
-
In Exercises confirm that the Integral Test can be applied to the series. Then use the Integral Test to determine the convergence or divergence of the series. n=1 2 3n + 5
-
The OS/390 mainframe operating system is structured around the concepts of address space and task. Roughly speaking, a single address space corresponds to a single application and corresponds more or...
-
Verify each limit using the limit definition. For example, in Exercise 9, show that |3x 12| can be made as small as desired by taking x close to 4. 9. 11. lim 3x= 12 x-A lim (5x 2) 17
-
True or False: Brand-new ball bearings are being fitted to an existing pump shaft. The shaft is measured and found to be 0.002 inch over specification. Because we are looking to shrink the bearing...
-
I know that its the thing to do, insisted Pamela Kincaid, vice president of finance for Colgate Manufacturing. If we are going to be competitive, we need to build this completely automated plant. Im...
-
Clark Company's current year income statement, comparative balance sheets, and additional information follow. For the year. (1) all sales are credit sales. (2) all credits to Accounts Receivable...
-
Consider the data in Table 3.30. and the following FDs: Decompose as necessary to achieve 3NF.
-
The 30-kg block A and the 50-kg block B connected by the weightless, frictionless pully system were released from rest. Determine their speeds when block A has displaced downwards by 0.4 m.
-
An atom in a solid vibrates at 1 1 . 6 THz with amplitude 1 0 pm . Find the a ) atom's maximum speed and b ) maximum acceleration. If it is a carbon atom, c ) what's its energy?
-
Number of passes There are two sorts of constructing agents in view of the number of goes through the source that are required (how frequently the constructing agent peruses the source) to create the...
-
Suppose the 30 day T-Bill rate is 4% and the expected return of the market is 9%. If the Beta of NIO company's stock is 0.3 what should be the required rate of return of the stock? (Round your answer...
-
Julie is a recently divorced single mother of two young children - both in childcare during her work hours. Her family live in Hong Kong, and due to financial constraints visits are rare. Julie is a...
-
An investor is considering purchasing corporate bonds from two different companies, one rated AAA and the other rated BBB. Explain the statements that is most accurate regarding the risks associated...
-
In the figure shown, write the equation of motion of particle (m, ) when it is given small displacement & towards right.
-
Inexhaustible collections of ONPOs are not required to be capitalized or depreciated, if certain criteria are met. Why is this so, and what accounting and reporting recognition, if any, is required...
-
Amy is a calendar-year taxpayer reporting on the cash basis. Please indicate how she should treat the following items for 2012: a. She makes a deductible contribution to an IRA on April 15,...
-
John Williams (age 42) is a single taxpayer, and he lives at 1324 Forest Dr., Reno, NV 89501. His Social Security number is 555-94-9358. John's earnings and withholdings as the manager of a local...
-
Ulysses and Penelope are married and file separate returns for 2012. Penelope itemizes her deductions on her return. Ulysses' adjusted gross income was $17,400, his itemized deductions were $2,250,...
-
What is the value of Brunei Petroleum Companys preferred stock when the dividend rate is 18 percent on a $100 par value? The appropriate discount rate for a stock of this risk level is 14 percent.
-
The preferred stock of the Luxemburg Mining Corporation pays a $3.25 dividend. What is the value of the stock if your required rate of return is 8 percent?
-
You are considering an investment in one of the preferred stocks of either Longines Watch Company or Titoni Watch Company. Longiness preferred stock pays an annual dividend of \($2.73,\) while that...
Study smarter with the SolutionInn App