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
-
For a function f(x) and a particular input value x = a, then we may write the difference quotient as f(a+h)-f(a) h f we = 6. where h#0. Now, let f(x)=x3-13x and consider the input value a = 3. We...
-
Question 3 (1 point) A firm has 70% debt and 30% common equity. Its yield to maturity is 6% and tax rate is 20%. The current stock price is 10 and the last dividend just paid was $0.5. Dividend is...
-
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...
-
Policies are decision making shortcuts that always empower the employees who have to carry them out true or false
-
Golf Away Corp. is a retail sports store carrying golf apparel and equipment. The store is at the end of its second year of operation and is struggling. A major problem is that its cost of in ventory...
-
Explain how unethical business practices degrade the quality of the experience a customer has with a service or product. How is the International Organization for Standardization trying to encourage...
-
Rachel Hill recently started her own shoe repair business. Transactions for the first month of operations (August 2019) are as follows.
-
The business of "healthcare" is currently focused on: A. Establishing viable revenue through appropriate pricing strategies B. Mitigating financial risk C. Managing cost and increasing value D....
-
For each of the following situation, solve for a missing amount. In each case, there is only one debit entry and one credit entry in the account during the month. Requirement 1: a. Accounts...
-
3. Differentiate the following. Show your work. x-2 a) y = 2x+5 (3 marks)
-
A one-question survey is to be distributed to a random sample of 1000 adults in Ohio. The question asks if they support an increase in the state sales tax from 6% to 7%, with the additional revenue...
-
Assume that the cost formula for one of a company's mixed expenses is $10,000+ $4.00 per unit. The company's planned level of activity was 2,000 units and its actual level of activity was 2,200...
-
In regard's the stock Columbia Sportswear (COLM) discuss the valuation and the valuation compared to the industry.
-
1.For much of the 20th century, new car prices rose at an average annual rate of 5.89%. Given a beginning new car price of $900, how long did it take for the average new car price to rise to $27,865?...
-
As you read each passage, select the blank line after each sentence, and choose the option from the drop-down menu that correctly identifies the sentence. Select"RO" if it is a run-on , "CS" if it...
-
Havel says the grocer doesnt believe what is on the sign and indeed, he says the grocers customers will barely notice it. But Havel maintains that the sign serves a specific function. How would you...
-
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...
-
The Mendoza Company is installing an absorption standard-costing system and a flexible-overhead budget. Standard costs have recently been developed for its only product and are as follows: Expected...
-
The expected activity of the paper-making plant of Leventhal Paper Company was 45,000 machine hours per month. Practical capacity was 60,000 machine hours per month. The standard machine hours...
-
Precision AutoParts Company has a highly automated manufacturing process for producing a variety of auto parts. Through the use of computer-aided manufacturing and robotics, the company has reduced...
Study smarter with the SolutionInn App