Use the above information to build an E-R diagram. Note that there is some missing information in
Fantastic news! We've Found the answer you've been seeking!
Question:
Use the above information to build an E-R diagram. Note that there is some missing information in the scenario. To complete the task, you can make reasonable assumptions about the missing information. All the assumptions made by you must clearly be mentioned in the report before making the ER diagram.
Transcribed Image Text:
Consider the following data requirements to develop a database system to keep information about research groups in a university. Research groups in university are special departmental groups working on different research areas. Each research group has a number of members headed by a group leader. Members could be senior students or academic staff, whereas the leader must be an academic staff. This database system should be able to show not only the group members, but also the experiments and research activities performed by each group. The database should be designed for only those students and staff participating in at least one research group. For each student joining a research group, the system should record the student ID, CPR, name (First, Middle, Last), the department majored at, and the date of joining a particular group that is recorded as the semester number and year. For academic staff, the system needs the staff ID, name, and the department working for. In addition, the university needs to know the number of groups leaded, and joined by each academic staff. When designing this system, it should be noted that a research group cannot be established unless it has at least three members and one of these members is assigned as the group leader. For each research group, the group name, and the main research area need to be recorded. The group research area could have a number of research sub-areas. A research group can also have a co- leader from external university. The system records the co-leader's ID, name and university name. According to university rules, each department is allowed to have up to fifteen research groups, and each group within the department should have distinct research area and distinct group name. In addition, the group leader should be one of the departmental staff and is allowed to lead only one group at a time, but members can join from any department in the university. The university assigns each department a distinct name, unique code, and separate building. A research group may run several research experiments. For each experiment, the experiment ID (unique within the group), experiment name, and a text of possible outcomes must be recorded. Any research experiment must be performed in one of the university research labs. For each of these labs, the system must store the lab unique ID, lab name, and the CPR and name of the technician responsible of this lab. According to university rules, each research lab should be under the responsibility of one of the research groups, so that the group can report back to the university each month about its lab(s) utilization and how to be improved. Consider the following data requirements to develop a database system to keep information about research groups in a university. Research groups in university are special departmental groups working on different research areas. Each research group has a number of members headed by a group leader. Members could be senior students or academic staff, whereas the leader must be an academic staff. This database system should be able to show not only the group members, but also the experiments and research activities performed by each group. The database should be designed for only those students and staff participating in at least one research group. For each student joining a research group, the system should record the student ID, CPR, name (First, Middle, Last), the department majored at, and the date of joining a particular group that is recorded as the semester number and year. For academic staff, the system needs the staff ID, name, and the department working for. In addition, the university needs to know the number of groups leaded, and joined by each academic staff. When designing this system, it should be noted that a research group cannot be established unless it has at least three members and one of these members is assigned as the group leader. For each research group, the group name, and the main research area need to be recorded. The group research area could have a number of research sub-areas. A research group can also have a co- leader from external university. The system records the co-leader's ID, name and university name. According to university rules, each department is allowed to have up to fifteen research groups, and each group within the department should have distinct research area and distinct group name. In addition, the group leader should be one of the departmental staff and is allowed to lead only one group at a time, but members can join from any department in the university. The university assigns each department a distinct name, unique code, and separate building. A research group may run several research experiments. For each experiment, the experiment ID (unique within the group), experiment name, and a text of possible outcomes must be recorded. Any research experiment must be performed in one of the university research labs. For each of these labs, the system must store the lab unique ID, lab name, and the CPR and name of the technician responsible of this lab. According to university rules, each research lab should be under the responsibility of one of the research groups, so that the group can report back to the university each month about its lab(s) utilization and how to be improved.
Expert Answer:
Answer rating: 100% (QA)
From the above Question Here is the ER Diagram of the above Case Study Name ... View the full 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 databases questions
-
You have just been hired by FAB Corporation, the manufacturer of a revolutionary new garage door opening device. The president asked you to review the company's costing system and "do what you can to...
-
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...
-
1. How strong are the competitive forces confronting J. Crew in the market for specialty retail? Do a [Michael Porter] five-forces analysis to support your answer. (see chapter 3 in the textfor...
-
The net present value and internal rate of return desirability measures for two mutually exclusive investments being considered by Stockton Corporation to follow. Year NPV IRR R 161 14.60% S 138...
-
Mel Snow is the manager of a firm, Taxation Matters, which specializes in the preparation of income tax returns. The firm offers two basic products: the preparation of income tax returns for wage and...
-
Crude oil ( = 40 cP, SG = 0.87) is to be pumped from a storage tank to a refinery through a series of pump stations via 10- in, schedule-20, commercial-steel pipeline at a flowrate of 2000 gpm. The...
-
With respect to NOL carryforwards, how does uncertainty affect the accounting treatment?
-
Compute FIFO, LIFO, and Average Cost Hull Company's record of transactions concerning part X for the month of April was as follows. (a) Compute the inventory at April 30 on each of the following...
-
On January 31, Sunland Company had the following payroll liability accounts in its ledger: Canada Pension Plan payable $7,852 Life insurance payable $830 Disability insurance payable 1,270 Union dues...
-
You have been hired by Gnomeo, Inc., a company that buys and resells miniature garden gnomes. The company started business on January 1, 2019. The chief accountant has asked you to compile a set of...
-
Select a company from the NYSE list at http://www.nyse.com. Use the "Search" box in the upper right corner or the "Listings" tab on the left side to find the company of your choice, and then review...
-
Describe geometrically or algebraically the domain for each functions below: (a) f(x,y)= - (b) f(x,y,z)=25-x-y2 - y z 2
-
1- Financial ratio analysis is conducted by three main groups of analysts: credit analysts, stock analysts, and managers. What is the primary emphasis of each group, and how would that emphasis...
-
We were lucky enough to find a bank with a 13% interest rate. We've decided to keep $45000 of our money in the account for 15 years. Find the periodic interest rate and number of periods if the...
-
6) Observations of direct incoming shortwave solar radiation were recorded over a completely opaque asphalt surface in a parking lot (IncomingShortwave.xls) for a 24-hr period. Determine the total...
-
Find the arc length of the graph of the function over the indicated interval. (Round your answer to three decimal places.) y -(e* + e*). [0,2]
-
Butterfly, LLC is a landscaping business and specializes in providing services to suburban homes. A large majority of their customers have set up accounts to where they will pay their bill for...
-
A company produces earbuds. The revenue from the sale of x units of these earbuds is R = 8x. The cost to produce x units of earbuds is C = 3x + 1500. In what interval will the company at least break...
-
Van makes an investment in a partnership in 2012. Van's capital contributions to the partnership consisted of $30,000 cash and a building with an adjusted basis of$70,000, subject to a nonrecourse...
-
Yolanda is a cash basis taxpayer with the following transactions during the year: Cash received from sales of products........................................................................$65,000...
-
Clarita is a single taxpayer with two dependent children, ages 10 and 12. Clarita pays $3,000 in qualified child care expenses during the year. If her adjusted gross income (all from wages) for the...
-
How much are firms willing to sacrifice in income taxes in order to smooth earnings?
-
Do smaller firms tend to manage earnings when compared to larger firms?
-
Find the Internet site "The Fraud Farm." Prepare your own "Gallery of Weasels."
Study smarter with the SolutionInn App