Modern Database Management
13th Edition
ISBN: 9780134773650
Author: Hoffer
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Question
Chapter 2, Problem 2.45PAE
Program Plan Intro
To draw the ERD for Symphony Orchestra based on the given entities and other requirements.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Assignment Brief:
Some of the most difficult decisions that you face as a database developer are what tables to
create and what columns to place in each table, as well as how to relate the tables that you
create. Normalization is the process of applying a series of rules to ensure that your database
achieves optimal structure. Normal forms are a progression of these rules. Each successive
normal form achieves a better database design than the previous form did. Based on your
understanding for the various normal form respond to the following problems and provide the
optimal answer/solution.
Problem#1: 1st Normal Form (1NF)
Consider the Students table, with the primary key underlined, and the following data:
Students:
Alpha
100111
Email
doe@usna.edu
Name
Courses
GradePoints
NN204, SI204,
IT221
SM223, EE301
SI204
John Doe
2,3,3
Matt Smith
092244
113221
smith@usna.edu
black@usna.edu
4,4
Melinda
3
Black
NN204, SI204,
IT221
090112
Tom Johnson
Johnson@usna.ed
4,2,3
u
a) Is the Students table…
P2
Problem statement:
Assume that you are an employee of a consultancy company that specializes in the analysis, design, and implementation of database systems. Southern Arkansas University (SAU) IT Group has recently approached your company with a view to implementing a database system for SAU, but they are not familiar with the development process. You are required to present an overview of the fact-finding techniques that your company intends to use to support the development of SAU’s database system. With this task in mind, create a 6-page report (Times New Roman, 12 font-size, double space) that describes each fact-finding technique and how the fact-finding techniques will be used throughout (each step of) the development of the database system.
Chapter 2 Solutions
Modern Database Management
Ch. 2 - Define each of the following terms: entity type...Ch. 2 - Match the following terms and definitions....Ch. 2 - Contrast the following terms: stored attribute;...Ch. 2 - Prob. 2.4RQCh. 2 - Prob. 2.5RQCh. 2 - Prob. 2.6RQCh. 2 - State six general guidelines for naming data...Ch. 2 - Prob. 2.8RQCh. 2 - Prob. 2.9RQCh. 2 - State three conditions that suggest the designer...
Ch. 2 - List the four types of cardinality constraints,...Ch. 2 - Give an example, Other than those described in...Ch. 2 - What is the degree of a relationship? List the...Ch. 2 - Give an example (Other than those described in...Ch. 2 - Give an example of each of the following, other...Ch. 2 - Give an example of the use of effective (or...Ch. 2 - State a rule that says when to extract an...Ch. 2 - Prob. 2.18RQCh. 2 - In addition to explaining what action is being...Ch. 2 - For the Manages relationship in Figure 2-12a,...Ch. 2 - Explain the distinction between entity type and...Ch. 2 - Why is it recommended that every ternary...Ch. 2 - A cellular operator needs a database to keep track...Ch. 2 - Prob. 2.24PAECh. 2 - Answer the following questions concerning Figure...Ch. 2 - Prob. 2.26PAECh. 2 - You may have been assigned a CASE or a drawing...Ch. 2 - Consider the two E-R diagrams in Figure 2-25 Q,...Ch. 2 - Prob. 2.29PAECh. 2 - Are associative entities also weak entities? Why...Ch. 2 - Because Visio does not explicitly show associative...Ch. 2 - Figure 2-26 shows a grade report that is mailed to...Ch. 2 - Prob. 2.33PAECh. 2 - The Is Married To relationship in Figure 2-12a...Ch. 2 - Figure 2-27 represents a situation of students who...Ch. 2 - Figure 2-28 shows two diagrams (A and B), both of...Ch. 2 - Prob. 2.37PAECh. 2 - Review Figure 2-8LQ and Figure 2-22. Identify any...Ch. 2 - Prob. 2.39PAECh. 2 - Prob. 2.40PAECh. 2 - Prob. 2.41PAECh. 2 - Prob. 2.42PAECh. 2 - Prob. 2.43PAECh. 2 - Prob. 2.44PAECh. 2 - Prob. 2.45PAECh. 2 - Prob. 2.46PAECh. 2 - Prob. 2.47PAECh. 2 - Prob. 2.48PAECh. 2 - Draw an ERD for the following situation. (State...Ch. 2 - Prob. 2.50PAECh. 2 - Prob. 2.51PAECh. 2 - Review your answer to Problem and Exercise 2-49 if...
Knowledge Booster
Similar questions
- DATABASE SYSTEM DRAWING E/R DIAGRAM AND RELATIONAL SCHEMAarrow_forwardTask 1: ER diagram for give scenario Consider building a database for a shopping mall with requirements as follows: Each product of the shopping mall has a unique project No, and also has a name, a supplier name, a category, a purchase price and a selling price. Products need to be supplied from suppliers. Each product has one supplier, but a supplier may supply many products for the shopping mall. Each supplier has a supplier name and address. A purchase order for product from a supplier has a unique order No, and a date. The order specifies one or more products and their quantities required for a product. A sales order for product to customers has a unique order No, and a date. The order specifies one or more products and their quantities required for a product The shopping mall has warehouses. Each warehouse has a warehouse number, an address and a contact phone number. Each warehouse has shelves to store products. Each shelf has a shelf-number and a capacity. The shelf…arrow_forwardThe entity relationship diagram below models the components of a database belonging to the South African Film Writers' Association. The database allows SAFWA to keep track of movies filmed in South Africa, developed by domestic and international studios. The MS Access database diagram below shows the tables created for a travel agent company called TravelSpace. They implemented their database to keep track of their customer's bookings for the different trips they have available. The company offers multiple tours which can be booked by many different customers. Given the diagram below, answer the following questions by providing SQL statements. CUSTOMER BOOKING CUST NO CUST FNAME BOOKNG NO TOUR BOOKING EMP ID CUST NO BOOK STATUS CODE 7 TOUR ID 7 80OENG NO TOUR DATE TOUR CUST LNAme CUST ADORESS CUST DOB CUST EMAIL OUT SEAT NO IN SEAT NO CUST, PHONE 1 TOURO TOUR NAME TOUR DESCRIPTON EVENTJD HOTEL_D TOUR PRICE ADULT FUGHT NO BOOK, TOTAL, COST BOOKNG DATE TOUR PRICE CHILD TOUR, PRICE CON…arrow_forward
- Entity relationship diagram.arrow_forwardNormalization works through a series of stages called normal forms. For most purposes in business database design, the normalization process. stages are as high as you need to go in five two four threearrow_forwardDatabase Design Before an Essential Oil product is marketed, testing is carried out based on the production batch from any essential oil. This is done to maintain the quality and content of the existing constituents in essential oils. Where the Test Percentage Content must reach the Minimum standard Percentage Content for each constituent. If there is one type of constituent that does not fulfill minimum standard, the batch will not be marketed because it does not meet the standard quality. Question 1. Create 1-NF, 2-NF, 3-NF Normalization for the available forms. 2. Make an ERD (Entitiy Relationship Diagram) based on the results of Normalization 3-NF. 3. Develop the ERD that you create to implement Generalization / Specialization.arrow_forward
- Database Design Before an Essential Oil product is marketed, testing is carried out based on the production batch from any essential oil. This is done to maintain the quality and content of the existing constituents in essential oils. Where the Test Percentage Content must reach the Minimum standard Percentage Content for each constituent. If there is one type of constituent that does not fulfill minimum standard, the batch will not be marketed because it does not meet the standard quality. Question 1. Create 1-NF, 2-NF, 3-NF Normalization for the available forms. 2. Make an ERD (Entitiy Relationship Diagram) based on the results of Normalization 3-NF. 3. Develop the ERD that you create to implement Generalization / Specialization.arrow_forwardSubject: Database Design UCSICafe is a coffee shop which set up in many countries such as Malaysia, Australia and New Zealand. UCSICafe has many employees, and these employees work for a department (headquarter or branches) which located in a country. For example, Michael Lee works as a finance manager in finance department which is located in Melbourne, Australia and Melbourne is the headquarter Important NoteYou are required to:1. use crow-foot notation in drawing entity relationship diagram; 2. include constraints and descriptions/assumption in your answer.arrow_forwardPlease written by computer source Part I - Modeling You are building a database for a comic book store customer management system. Given the database specification below, your job is to turn the specification into an ER diagram. Your notation must be consistent with the notation used in our lecture notes. You can use all constructs and notations discussed in our lecture notes and nothing else (i.e.. oven notations used in the textbooks but not in our lectures cannot be used). Your ER diagram should capture all the information and constraints in the specification but, at the same time, be minimal. It means that redundant entities, relationships, attributes and constraints should be avoided. You may use any drawing tool of your choice (for example, Dia, diagrams.net, Lucidchart, etc.) to draw your ER diagram. Hand drawings will not be accepted. Database Specification The database keeps information about comic books, customers, orders, inventory and reviews. First, the database should…arrow_forward
- Data Modeling is the first phase in the process of database design and is the most important. Comparing and contrasting the Conceptual data model with the Physical data model is important. With the assistance of an example, demonstrates how to list down data (entities), relationships between data, and limitations on data.arrow_forwardRelational Model (Logical and Physical Schema Development) The conceptual model developed in phase 2 will be transformed into a logical and physical schema using the relational data model. The outcome of this transformation will be a relational schema. The schema should have the following components: Set of required relations All the integrity constraints Submission and Evaluation: A report consisting of the problem statement, ER diagram, relational schema And implement the database using SQL should include: All the tables properly defined /created All constraints properly defined For each table, few instances of data should be entered. Producer Pharmacy medicines The pharmacy contains employees, certain medicines customers and patients Date Name Customers age pharmacy sex employees Commercial Record Address Location Salary Namearrow_forwardSubject: DatabaseQuestion: Draw an ERD based on the given infoarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781305627482Author:Carlos Coronel, Steven MorrisPublisher:Cengage Learning
A Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology Ptr
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781285196145Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos CoronelPublisher:Cengage Learning
Principles of Information Systems (MindTap Course...Computer ScienceISBN:9781305971776Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
Principles of Information Systems (MindTap Course...Computer ScienceISBN:9781285867168Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781305971776
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781285867168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning