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...
-
What are the types of differences that exist between IFRS and U.S. GAAP?
-
The futures price for the June 2011 CBOT bond futures contract is 118-23. (a) Calculate the conversion factor for a bond maturing on January 1, 2027, paying a coupon of \(10 \%\). (b) Calculate the...
-
Master Suites Hotels includes the following selected accounts in its general ledger at December 31,2008 : Prepare the liabilities section of Master Suites' balance sheet at December 31, 2008, to show...
-
A six-column table for JJW Company follows. The first two columns contain the unadjusted trial balance for the company as of July 31, 2011. The last two columns contain the adjusted trial balance as...
-
Discussion Question 1-16 (LO 1-2) The Atlas company makes weight lifting... The Atlas company makes weight lifting equipment. They are in the process of automating and have added $5 million in...
-
FeVer Beverages is a typical coffee shop that operates at Batangas. Recently, the general manager is facing a challenge about not meeting their target lead time of serving the hot coffee of 15...
-
In circular flow of expenditure an income why must the value of total production in an economy equal the value of total income?
-
Atuheire presented the following data for the two activity levels as under; CAPACITY 60% 100% Budgeted production(units) 300500 Insurance(shillings) 3000 3000 Wages (shillings) 3600 6000 Consumables...
-
A balloon holding 3.00 moles of neon (Ne) gas absorbs 955 J of thermal energy while doing 152 J of work expanding to a larger volume (a) Find the change in the balloon's internal energy (in J). (b)...
-
In recent years, the iconic American motorcycle company has seen costs rising and demand falling. In mid-2020, the company announced that it would be cutting production and "revamping" inventory...
-
Multichained Stores Ltd., Delhi has its branches at Lucknow and Madras. It charges goods to its branches at cost plus 25%. Following information is available of the transactions of the Lucknow branch...
-
8. Given the following code sequence: for (i=0; i <10; i++) { if (A[i] != 5) A[B[i]] += 1 else A[i] = B[i+1]} If the base address of arrays A and B are in $s1 and $s2 respectively and i, 5 and 1 are...
-
QUESTION 5 USE THE FOLLOWING INFORMATION TO ANSWER THE NEXT (4) QUESTIONS: The Income Statement of Dolan Corporation for 2016 included Interest Revenue for $131,000. The Cash ledger for the company...
-
A Alkynes can be made by dehydrohalogenation of vinylic halides in a reaction that is essentially an E2 process. In studying the stereochemistry of this elimination, it was found that...
-
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?
-
The amplitudes of displacement and acceleration of an unbalanced turbine rotor are found to be \(0.5 \mathrm{~mm}\) and \(0.5 \mathrm{~g}\), respectively. Find the rotational speed of the rotor using...
-
The root mean square (rms) value of a function, \(x(t)\), is defined as the square root of the average of the squared value of \(x(t)\) over a time period \(\tau\) :...
-
Prove that the sine Fourier components \(\left(b_{n} ight)\) are zero for even functions-that is, when \(x(-t)=x(t)\). Also prove that the cosine Fourier components \(\left(a_{0} ight.\) and...
Study smarter with the SolutionInn App