Database Systems: Design, Implementation, & Management
11th Edition
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
expand_more
expand_more
format_list_bulleted
Expert Solution & Answer
Chapter 4, Problem 4P
Explanation of Solution
Entity Relationship (ER) Diagram:
The following figure illustrates the ER Diagram for given business rules using Crow’s Foot notation:
Explanation:
The above ERD, contains several entities such as “Customer”, “Invoice”, “Vendor”, “Product”, “Salessrep” and “Inv_Line”. Each entity has its own attributes.
- A customer can generates invoice form several sales representatives...
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
The International Conference on Mathematical Sciences and Technology, MathTech, is a biennial
conference organised by the School of Mathematical Sciences, USM. This event is open to all
national and international experts, practitioners, researchers, and academics to gather and
share their knowledge.
The details of fees for participation in the conference are shown in the following table.
Category
Local (RM)
International (USD)
Presenter
990
260
Observer
150
Note: 1 USD = RM4.20
Assignment Requirement
Part 1: Create Invoice
Construct a C++ program to do the following tasks:
a. Enter the participant's name, category, nationality, accommodation (Yes/No).
b. If the answer for the question on accommodation is Yes, the program will ask for the
number of days. Then the program will call function calcAccommodation () to calculate
the accommodation charges.
calcAccommodation() receives accommodation (Yes/No), number of days and participation
type (local/international) as parameters and return…
The International Conference on Mathematical Sciences and Technology, Math Tech, is a biennial
conference organised by the School of Mathematical Sciences, USM. This event is open to all
national and international experts, practitioners, researchers, and academics to gather and
share their knowledge.
The details of fees for participation in the conference are shown in the following table.
Category
Local (RM)
International (USD)
Presenter
990
260
Observer
600
150
Note: 1 USD = RM4.20
Assignment Requirement
Part 1: Create Invoice
Construct a C++ program to do the following tasks:
a. Enter the participant's name, category, nationality, accommodation (Yes/No).
b. If the answer for the question on accommodation is Yes, the program will ask for the
number of days. Then the program will call function calcAccommodation() to calculate
the accommodation charges.
calcAccommodation() receives accommodation (Yes/No), number of days and participation
type (local/international) as parameters and…
An Art Museum needs to keep track of its artwork and exhibitions. The museum has a collection of
artwork. Each piece of art has a unique id [ArtID], an artist, year and title.
Artwork is categorized by type. There are two types, paintings and sculptures. Paintings have a
paintType and style. Sculptures have a material, height and weight.
Artwork is frequently shown in exhibitions. Each exhibition has a unique name, startDate, endDate.
A listing of the artwork displayed at an exhibition is also retained.
Below is an E-R diagram for a database to help the Art Museum. Provide appropriate names for
entities E1, E2, E3, E4 identifiers 11, 12, 13, 14 missing attributes and relationship cardinality RC1
and relationship type RT1.
Start_date
End_date
E1
E1
11
RC1
PaintType
Style
E3
13
A1
Title
Year
A/
A
A/
A/
A/
A/
A/
A/
A
A/
A/
E2
12
A/ E2
E3
E4
11
12
13
14
A1
A2
RC1
RT1
RT1
A2
Height
Weight
E4
14
Activate
Go to Settin
Chapter 4 Solutions
Database Systems: Design, Implementation, & Management
Ch. 4 - Prob. 1RQCh. 4 - What is a strong (or identifying) relationship,...Ch. 4 - Prob. 4RQCh. 4 - Suppose you are working within the framework of...Ch. 4 - Prob. 6RQCh. 4 - Prob. 7RQCh. 4 - Discuss the difference between a composite key and...Ch. 4 - What two courses of action are available to a...Ch. 4 - Prob. 11RQCh. 4 - Discuss two ways in which the 1:M relationship...
Ch. 4 - Prob. 13RQCh. 4 - Prob. 14RQCh. 4 - Briefly, but precisely, explain the difference...Ch. 4 - What are multivalued attributes, and how can they...Ch. 4 - Prob. 17RQCh. 4 - Prob. 18RQCh. 4 - What two attributes must be contained in the...Ch. 4 - Describe precisely the composition of the...Ch. 4 - Prob. 21RQCh. 4 - Prob. 1PCh. 4 - Create a complete ERD in Crows Foot notation that...Ch. 4 - Prob. 4PCh. 4 - Prob. 5PCh. 4 - Prob. 6PCh. 4 - Prob. 7PCh. 4 - Prob. 8PCh. 4 - Prob. 9C
Knowledge Booster
Similar questions
- Rick and Ryan Enterprises is an agency that specializes in representing clients in the fields of sports and entertainment. Given the nature of the business, some employees are given a company car to drive and each company car must be assigned to an employee. Each employee has a unique employee number, plus an address and set of certifications. Not all employees have earned one or more certifications. Company cars are identified by their vehicle ID and also contain a license plate number, make, model, and year. Employees represent clients. Not all employees represent clients while some employees represent many clients. Each client is represented by one and only one employee. Each client has a unique client number. Additional attributes required for each client are name, address, and date of birth. Draw an ER diagram that shows the entity types and the relationship types for Rick and Ryan Enterprises. While you must name each relationship type and define the structural…arrow_forwardRock Series: A site hosts many shows a year. Artists have a name and perform several times in a series (each is a show on a different date). Series have one or more artists and have a series name and a specified seating arrangement. A series is held in one (and only one) of several halls, each of which has a hall number. Represent this situation of shows and artists with an E-R diagram.arrow_forwardEach publisher has a unique name; a mailing address and telephone number are also kept on eachpublisher. A publisher publishes one or more books; a book is published by exactly one publisher. Abook is identified by its ISBN, and other attributes are title, price, and number of pages. Each book iswritten by one or more authors; an author writes one or more books, potentially for differentpublishers. Each author is uniquely described by an author ID, and we know each author's name andaddress. Each author is paid a certain royalty rate on each book he or she authors, which potentiallyvaries for each book and for each author. An author receives a separate royalty check for each book heor she writes. Each check is identified by its check number, and we also keep track of the date andamount of each check.TasksDesign a SQL database using the above US superstore sales data set.1.Use Visual Paradigm to draw conceptual diagram2.Use Visual Paradigm todraw ERDarrow_forward
- Create an ERD based on the Crow’s Foot notation with Microsoft Visio, using the following business rules or requirements: An INVOICE is written by aSALEREP. Each sales representative can write many invoices, but each invoice is written by a single sales representative. The INVOICE is written for a single Customer. However, each customer can have many invoices. An INVOiCE can include many detail lines (LINE), each of which describes one product bought by the customer. The product information is stored in a PRODUCT entity. The product's vendor information is found in a VENDOR entity.arrow_forwardQuestion 8 The ERD below is the initial design to track events and the dates on which they are scheduled. Using the ERD, what can you determine about the statement "There were 5 events on July 4, 2012." EVENT DATE Has Scheduled on O This statement could NOT be true based on the ERD. O This statement could be true based on the ERD.arrow_forwardCreate a use case sequence diagram using the information below. Buy Parts Customer/Store Employee Description: This use case describes car parts dealer purchasing. Successful Finish: client requests vehicle component 2. Store associate verifies availability 3. component is available and client pays cost 4. Customer receives part; stock adjusted. 1. Customer asks auto part 2. Store Associate checks part availability 3. Part is unavailable and customer chooses to order part or no part 4. Customer receives part and stock is updated (if alternate part ordered) or leaves without part. Alternative: Customer wants component. No post-condition No assumptionsarrow_forward
- 3- Write the business rules that are reflected in the ERD shown below (Note that the ERD reflects some simplifying assumptions. For example, each book is written by only one author. Also, remember that the ERD is always read from the "1" to the "M" side, regardless of the orientation of the ERD components.) PUBLISHER BOOK publishes submits wrtes CONTRACT AUTHOR signs %23arrow_forwardThe Data type involves which four objectives?arrow_forwardFor the term project, you should write a report on a chosen topic related to your field. Follow the steps below: Choose a topic : Technology Narrow it down : Algorithms and data structures Find at least 10 related articles to your topic Read the articles, synthesize them and report the parts you want. Use appropriate citations and quotations (APA 6th or 7th edition) You need a reference list at the end of your report. The report should be minimum 1000 and maximum 2000 words.arrow_forward
- In an annual charter day celebration of a university, one of the highlights of its celebration is having a concert for a cause in which national personalities were invited. The student body assigned for the conduct of the event, sold tickets for their fund raising for a cause. Tickets are sold according to the following prices. The green ticket is sold at $20, orange ticket at $30 and white ticket at $40. All students of the university are encouraged to support the said event, however the venue could only accommodate 1500 people. Write a Nassi-Shneiderman diagram that determines the total amount of money that will be generated if all tickets are all sold out and likewise print the total money collected.arrow_forwardIn an annual charter day celebration of a university, one of the highlights of its celebration is having a concert for a cause in which national personalities were invited. The student body assigned for the conduct of the event, sold tickets for their fund raising for a cause. Tickets are sold according to the following prices. The green ticket is sold at $20, orange ticket at $30 and white ticket at $40. All students of the university are encouraged to support the said event, however the venue could only accommodate 1500 people. Write an algorithm in pseudocode, a flowchart and NS diagrams that determines the total amount of money that will be generated if all tickets are all sold out and likewise print the total money collected.arrow_forwardWrite at least 10 requirements for a calculator. Make sure you use the word SHALL in each requirement and each requirement shall have an unique identifier such a number.arrow_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 LearningDatabase 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
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
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