need help it need to use draw.io to draw the ER model. I provided an example of
No answer yet for this question.
Ask a Tutor
Question:
Transcribed Image Text:
Entity Relationship Modeling For each of these scenarios, draw an ER model using any standard notation, clearly denoting maximum and minimum cardinality constraints. Write the one liner and four sentences for each diagram (statements that specify degree and mandatoriness of each entity, if applicable). Number of tables needed and the columns in the tables especially Primary and Foreign Key postings must be complete. Your diagram must be complete in all respects with all notations to receive full credit. SQL statements to create the tables necessary should be provided. 1. Parts are described by partnum, color, and price. Parts can be subassemblies as well and this means that they contain other parts. One part cannot be a component of more than one subassembly but a subassembly can contain many other parts. A part need not be a component of any subassembly (please note that a subassembly is a part well), but a subassembly must contain more than one part. 2. A student in a high school may play many sports. Each sport has one varsity team that has a coach, and a school location where they play home games. Obviously a team can contain many players. A team must contain at least one student and a student need not play any sports. The number of wins and losses are also recorded against each team. 3. All employees have an id, name, department and datejoined. In addition, salespersons have commission and salary, consultants have hourly rates and a vendor firm, and regular employees have simply yearly salary. An employee must belong to only of the subgroups and all employees belong to one of these three categories. 4. A dissertation committee has exactly one chairperson and two other members, and the same committee can supervise the dissertation of many doctoral students, typically not more than five. A student must have exactly one committee supervising his/her dissertation and a committee must have at least one student. A dissertation committee has a start date and is dissolved when the last student has graduated and the committee has no more students. Entity Relationship Modeling For each of these scenarios, draw an ER model using any standard notation, clearly denoting maximum and minimum cardinality constraints. Write the one liner and four sentences for each diagram (statements that specify degree and mandatoriness of each entity, if applicable). Number of tables needed and the columns in the tables especially Primary and Foreign Key postings must be complete. Your diagram must be complete in all respects with all notations to receive full credit. SQL statements to create the tables necessary should be provided. 1. Parts are described by partnum, color, and price. Parts can be subassemblies as well and this means that they contain other parts. One part cannot be a component of more than one subassembly but a subassembly can contain many other parts. A part need not be a component of any subassembly (please note that a subassembly is a part well), but a subassembly must contain more than one part. 2. A student in a high school may play many sports. Each sport has one varsity team that has a coach, and a school location where they play home games. Obviously a team can contain many players. A team must contain at least one student and a student need not play any sports. The number of wins and losses are also recorded against each team. 3. All employees have an id, name, department and datejoined. In addition, salespersons have commission and salary, consultants have hourly rates and a vendor firm, and regular employees have simply yearly salary. An employee must belong to only of the subgroups and all employees belong to one of these three categories. 4. A dissertation committee has exactly one chairperson and two other members, and the same committee can supervise the dissertation of many doctoral students, typically not more than five. A student must have exactly one committee supervising his/her dissertation and a committee must have at least one student. A dissertation committee has a start date and is dissolved when the last student has graduated and the committee has no more students.
Expert Answer:
Related Book For
Posted Date:
Students also viewed these databases questions
-
123 Compare the purely graphical properties of these two notations, and the ways in which the graphical properties of each display correspond to the information structure being defined. Describe...
-
Evan participates in an HSA carrying family coverage for himself, his spouse, and two children. In 2018, Evan has $100 per month deducted from his paycheck and contributed to the HSA. In addition,...
-
In below Problems, a function and its graph are given. (a) Use the graph to determine (estimate) x-values where f'(x) > 0, where f'(x) (b) Use the graph to determine x-values where f''(x) > 0, where...
-
Compute the two-period and four-period moving average predictions for the data set. a. Prepare a line graph comparing the moving average predictions against the original data. b. Compute the MSE for...
-
Explain why departmental overhead rates might be used instead of a single plantwide overhead rate.
-
Gotham Company purchased a new machine on October 1, 2017, at a cost of $90,000. The company estimated that the machine has a salvage value of $8,000. The machine is expected to be used for 70,000...
-
Discuss the following topic(s) in the forum and submit proof of your participation in the online discussions: 1) Professional certification and the practising accountants 2) Cost data and managerial...
-
The production manager at a factory manufacturing four types of light fittings (A, B, C and D) on an automated machine is fixing the schedule for the next week on this machine. HEIJUNKA SCHEDULING OF...
-
Natalie is a senior accountant at PWD with several years audit experience. Presently, Mrs Anderson has been conducting substantive procedures over the revenue and receipts cycle and wants her...
-
8. Determine one possible value for x when 0x2 for each of the following. Give answers in simplest exact form. [A6] a. |sinh = sinx, x #23 3/4 b. cos _1131* =sinx c. tan =cotx I
-
Home work Differential amplifier with Darlington input transistors: A) If Rb-0 prove that: Rid=4(hfe+1)hie1=4(hfe+1)hib1 B) If Rb+ 0 prove that: CMRR Ro3 Rb (1+hfe) 2hib1+ VI Rb where Ro3 = r03...
-
2) A math tutor makes $15.00 per hour in the tutoring lab at her school. She earns an additional $7.50 more per hour overtime for any hours worked which exceed her normal 40-hr work week. b) Write a...
-
Eliminate Affordable Care Act subsidies for those earning between 300 and 400 percent of the federal poverty level. The Affordable Care Act (Obamacare) allows individuals and families to purchase...
-
Think about your experiences on the flip-side of writing: What do you read? Why do you read particular books, articles, manuals, online content, etc? In what settings and for what reasons do you...
-
If u(t) = delta(t),that is,the unit impulse at = 0.What is the output when t goes to infinity?
-
Draw two scatterplots, one for which r = 1 and a second for which r = 21.
-
Imagine that you work as a data analyst for a technology company and have prepared a presentation about data security. Youll deliver your presentation to employees in three countries in addition to...
-
With a classmate, describe a time each of you were misjudged because of your affiliation or identity. Next, describe a time when you misjudged someone else. What are the similarities and differences...
-
Given the previous exercise and your own thinking about your career, how would you describe the best job situation for you? Next, consider two more options in case your idea doesnt work out. What...
-
In the STAR experiment (Section 7.5.3), children were randomly assigned within schools into three types of classes: small classes with 13-17 students, regular-sized classes with 22-25 students, and...
-
Many cities in California have passed Inclusionary Zoning policies (also known as below-market housing mandates) as an attempt to make housing more affordable. These policies require developers to...
-
Professor Ray C. Fair's voting model was introduced in Exercise 2.23. He builds models that explain and predict the U.S. presidential elections. See his website at...
Study smarter with the SolutionInn App