Review Questions Q1) Design the entity relationship diagram for the following scenario? A company is setting...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Review Questions Q1) Design the entity relationship diagram for the following scenario? A company is setting up a database to record sellers and their products. This requires recording the following information: • For each seller, their name, contact email, and postal address. For each product, its ID, name, price, and number available. Which product is from which seller. Draw an entity-relationship (ER) diagram that represents this information. Make sure to capture the constraints on the relationships involved, and designate appropriate primary keys for the entities. Q2) Convert the following ER Diagram from the current notation to the min-max notation: Vehicle M Owns 1 Person Introduction to Database Systems ER Diagram Worksheet #2 Lecture of Thr 02-12-2021 Q1: Suppose you are given the following requirements for a simple database for national soccer teams: Each team has a name, ID, logo, city, coach, and a set of players. One of the players would serve as a captain of the team. The system should keep track of the start date of the team captain. A player has an ID, name, position, DoB, and nationality. A player belongs to only one team. A game (match) is played between two teams and we should keep track of the results, match date, stadium, and the city. • Draw the ER of the above requirements. • Extract at least one example of the following: 1. Simple attribute 2. 1:1 relationship 3. 1:M relationship 4. M:N relationship. 5. A relationship attribute. 6. An entity type. • Weak entity type. • Identifying entity type. • Partial key Composite key 7. Total participation constraint. 8. Partial participation constraint. Q2: Define and discuss one example of the following: Review Questions Q1) Design the entity relationship diagram for the following scenario? A company is setting up a database to record sellers and their products. This requires recording the following information: • For each seller, their name, contact email, and postal address. For each product, its ID, name, price, and number available. Which product is from which seller. Draw an entity-relationship (ER) diagram that represents this information. Make sure to capture the constraints on the relationships involved, and designate appropriate primary keys for the entities. Q2) Convert the following ER Diagram from the current notation to the min-max notation: Vehicle M Owns 1 Person Introduction to Database Systems ER Diagram Worksheet #2 Lecture of Thr 02-12-2021 Q1: Suppose you are given the following requirements for a simple database for national soccer teams: Each team has a name, ID, logo, city, coach, and a set of players. One of the players would serve as a captain of the team. The system should keep track of the start date of the team captain. A player has an ID, name, position, DoB, and nationality. A player belongs to only one team. A game (match) is played between two teams and we should keep track of the results, match date, stadium, and the city. • Draw the ER of the above requirements. • Extract at least one example of the following: 1. Simple attribute 2. 1:1 relationship 3. 1:M relationship 4. M:N relationship. 5. A relationship attribute. 6. An entity type. • Weak entity type. • Identifying entity type. • Partial key Composite key 7. Total participation constraint. 8. Partial participation constraint. Q2: Define and discuss one example of the following:
Expert Answer:
Answer rating: 100% (QA)
Answer QUESTION 2 WEAK ENTITY TYPE In a relational database a weak entity is an entity that cannot be uniquely identified by its attributes alone therefore it must use a foreign key in conjunction wit... View the full answer
Related Book For
Data Modeling and Database Design
ISBN: 978-1285085258
2nd edition
Authors: Narayan S. Umanath, Richard W. Scammel
Posted Date:
Students also viewed these accounting questions
-
This exercise is based on the three Presentation Layer ER diagrams that follow. a. Describe what is reflected by the entity types and relationship types in Presentation Layer ER diagram number 1. In...
-
Draw an entity-relationship diagram that shows the relationships among a database, database applications, and users.
-
For this Project you will be designing a wireless network for three accountants sharing an office. Each accountant will have a wireless router for their office space which will be connected through a...
-
Henries Drapery Service is investigating the purchase of a new machine for cleaning and blocking drapes. The machine would cost $137,320, including freight and installation. Henries estimated the new...
-
Summary operating data for Pens Plus Company during the year ended December 31, 2015, are as follows: cost of goods sold, $3,000,000; administrative expenses, $500,000; interest expense, $30,000;...
-
The mass spectrum of phosphoryl chloride, POF 3 , is illustrated here. (a). Identify the cation fragment at a m/Z ratio of 85. (b). Identify the cation fragment at a m/Z ratio of 69. (c). Which two...
-
Stonewall Corporation issued \(\$ 20,000\) of \(5 \%, 10\)-year convertible bonds. Each \(\$ 1,000\) bond is convertible to 10 shares of common stock (par \$50) of Stonewall Corporation. The bonds...
-
Almer Company operates two factories. The company applies factory overhead to jobs on the basis of machine hours in Factory 1 and on the basis of direct labor hours in Factory 2. Estimated factory...
-
Tyler Guitars makes acoustic and electric guitars. It is struggling to determine the profitability of each guitar and deciding on which guitar to focus its sales efforts. Tyler currently has a...
-
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...
-
1) Which ISDN channel carries signaling information? 2) What device must be installed on a DSL network to protect the sound quality of phone calls? 3) What type of network combines fiber with coax?...
-
Evander Inc. has decided to use the high-low method to estimate the total cost and the fixed and variable cost components of the total cost. The data for various levels of production are as follows:...
-
At its most base level, product packaging serves to protect the product inside. Packaging must keep the product safe during shipment between the manufacturing facility and the retailer and must...
-
Analyze each of the four transactions Ernie's Electronics had with Bert's Bargain House from the perspective of Ernie's Electronics. Required: Select the section of the statement of cash flows in...
-
: Normalization is a database design technique which organizes tables in a way that reduces redundancy and dependency of data. It divides larger tables to smaller tables and links them using...
-
Santana Rey sees that Business Solutions's line of computer desks and chairs is popular, and she is finding it hard to keep up with demand. Santana only has 1,473 direct labor hours available. She...
-
I'm stuck on this FRQ can someone provide help with an explanation on how to answer this?. B. Write the StringAnalyzer method void stringRemoverMachine () as started below. stringRemoverMachine ()...
-
Planning: Creating an Audience Profile; Collaboration: Team Projects. Compare the Facebook pages of three companies in the same industry. Analyze the content on all available tabs. What can you...
-
Describe the SQL clauses used in the definition of: a. A primary key constraint b. An alternate key constraint c. A foreign key constraint d. A check constraint
-
In categorization, what is meant by the property of selective type inheritance?
-
How many rows of output would be produced if the ROLLUP used in your query were to take the following form: GROUP BY ROLLUP (YEAR, MONTH, REG_NAME)? Write a query to verify your result?
-
Utta Inc. allows each employee to earn 15 paid vacation days each year with full pay. Unused vacation time can be carried over to the next year. If not taken during the next year, unused vacation...
-
Bloy Company pays all salaried employees on a biweekly basis. Overtime pay, however, is paid in the following biweekly period. Bloy accrues salaries expense only at its December 31 year-end. Data...
-
Anne Taylor Company borrowed cash on August 1, 2020, and signed a \(\$ 33,300\) (face amount), one-year note payable, due on July 31, 2021. The accounting period of Anne Taylor ends December 31....
Study smarter with the SolutionInn App