Draw an ER diagram representing the following categories Persons: A Person has a name and a...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Draw an ER diagram representing the following categories Persons: A Person has a name and a social security number (SSN). A Person can not have the same SSN as any other Person. A Person attends one or more Meetings. Rooms: A Room has a room number and a capacity. A Room can not have the same room number as any other Room. A Room is managed by one Department. Meetings: . 0 A Meeting has a starting time. A Meeting has an agenda. A Meeting takes place in a certain Room. Multiple Meetings can not start at the same time in the same Room. For simplicity, do not worry about the duration of a Meeting, only the starting time. A Meeting has one or more Persons in attendance. O Departments: A Department has a name and a department ID (DID). A Department can manage zero or more Rooms. Hints: Do not try to prevent more people attending a meeting than the room capacity allows; this would be done in software logic. Do not try to prevent a person from attending multiple meetings at the same starting time. The problem description does not state this restriction. Draw an ER diagram representing the following categories Persons: A Person has a name and a social security number (SSN). A Person can not have the same SSN as any other Person. A Person attends one or more Meetings. Rooms: A Room has a room number and a capacity. A Room can not have the same room number as any other Room. A Room is managed by one Department. Meetings: . 0 A Meeting has a starting time. A Meeting has an agenda. A Meeting takes place in a certain Room. Multiple Meetings can not start at the same time in the same Room. For simplicity, do not worry about the duration of a Meeting, only the starting time. A Meeting has one or more Persons in attendance. O Departments: A Department has a name and a department ID (DID). A Department can manage zero or more Rooms. Hints: Do not try to prevent more people attending a meeting than the room capacity allows; this would be done in software logic. Do not try to prevent a person from attending multiple meetings at the same starting time. The problem description does not state this restriction.
Expert Answer:
Answer rating: 100% (QA)
Here is the ER diagram representing the given categories Persons Rooms Meetings Departments SSN P... 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 programming questions
-
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...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1 and 2. On September 1, Irene opened a retail store that specializes in sports car...
-
A module can be considered a(n) object or unit that can be combined or bound together to form a application. a. Dependent, big and complex b. Dependent, small and easier c. Independent, big and...
-
A newspaper article in the fall of 2007 stated, the luxury-home builder Hovnanian Enterprises reported its fourth consecutive quarterly loss on Thursday, citing continuing problems of credit...
-
PW of Alternative For the following alternatives, answer the questions below. Incremental B/C when B/C Ratio compared with alternative Costs. $ Benefits, $ Disbenefits, $ J K L M J 20 22 4 0.90 C...
-
What is the purpose of practice aids in forensic and valuation services?
-
TipTop Flight School offers flying lessons at a small municipal airport. The schools owner and manager has been attempting to evaluate performance and control costs using a variance report that...
-
Oxygen gas having a volume of 1250 cm 3 at 43.1 C and 1.04 x 10 5 Pa expands until its volume is 1900 cm 3 and its press is 1.08 x 10 5 Pa. Find: (a) the number of moles of oxygen present and (b) the...
-
James Sprater of Grand Junction, Colorado, has been shopping for a loan to buy a used car. He wants to borrow $18,000 for four or five years. James's credit union offers a declining-balance loan at...
-
In the case of Breiner v. Nevada Department of Corrections 610 F.3d 1202 (Walsh, Ch. 7, p. 227-230) why did the court reject the NDOCs de minimis argument? What were the legal issues in this case?...
-
12. What amount does Tim need on his for the dependency period part of the "Income Needs" section, if they want to cover only until Jason is out of the home
-
A student in history class asks the instructor, " Which year did the Civil War begin?" This question falls into which category on the scale toward higher-order thinking?
-
5. What did the company mean by the "full retrospective method"? Was there any financial statement related impact? If so, where and in what amount? (Hint: Consolidated Statements of Stockholders'...
-
your salary is $25,000 and you will be receiving a 2.5 pay increase this year. what will your new salary be?
-
Which concept or theory from persuasion and negotiation process chapter that you think can well explain the attempt to persuade people to buy products and services that are not highly essential for...
-
10. The following lists all assets and liabilities of Literally Financial Limited at the dates indicated. Assuming there were no shares issued, no dividends paid and no assets revalued during the...
-
Time Travel Publishing was recently organized. The company issued common stock to an attorney who provided legal services worth $25,000 to help organize the corporation. Time Travel also issued...
-
Carl Conch and Mary Duval are married and file a joint return. They live at 1234 Mallory Sq. Apt. 64, Key West, FL 33040. Carl works for the Key Lime Pie Company and Mary is a homemaker after losing...
-
Steve Drake sells a rental house on January 1, 2012, and receives $130,000 cash and a note for $55,000 at 10 percent interest. The purchaser also assumes the mortgage on the property of $45,000....
-
Matthew borrows $250,000 to invest in bonds. During 2012, his interest on the loan is $30,000. Matthew's interest income from the bonds is $10,000. This is Matthew's only investment income. a....
-
Eugene Fama and Robert Shiller recently won the Nobel Prize in economics. Go to http://nobelprize.org/nobel_prizes/economics/ and locate the press release on Eugene Fama and Robert Shiller. What was...
-
Visit the Bloomberg Markets website at www.bloomberg.com/markets/stocks. Their interactive graph allows you to see cumulative returns for individual stocks as well as market indices. Over the last...
-
Compute the price of a share of stock that pays a \($5\) per year dividend and that you expect to be able to sell in one year for \($40\), assuming you require a 5% return.
Study smarter with the SolutionInn App