Database Systems: Design, Implementation, & Management
13th Edition
ISBN: 9781337627900
Author: Carlos Coronel, Steven Morris
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Expert Solution & Answer
Chapter 4, Problem 10P
a.
Explanation of Solution
Crow’s Foot ER diagram for first LOST:
The following data model shows the solution for the given question.
Explanation:
- In the above data model, “Tour” table contains details of the tour and the “Tour” can have many “Qualification” which equally “Guide” can works in many “Qualification”. Here the M:N relationship is break into two 1:N relationship. The “Qualification” is a bridge between “Tour” and “Guide” table.
- The “Stop” table contains details of the stop and one “Tour” can have many stopping place so 1:N relationship...
b.
Explanation of Solution
Crow’s Foot ER diagram for second LOST:
The following data model shows the solution for the given question.
Explanation:
- In the above data model, “Tour” table contains details of the tour and the “Tour” can have many “Qualification” which equally “Guide” can works in many “Qualification”. Here the M:N relationship is break into two 1:N relationship. The “Qualification” is a bridge between “Tour” and “Guide” table...
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
QUESTION 1
The OMCA club operations
When members join OMCA health club, they pay a fee for a certain length of time. Most memberships are for 1 year, but memberships for short periods are available. Due to various promotions throughout the year, it is common for members to pay different amounts for the same length of membership. The club wants to e-mail reminders to members to ask them to renew their memberships one month before their memberships expire. Some members have been angry with staff when asked to renew at a much higher rate than their original membership contract. So, the club needs staff to keep track of the price paid so that the managers can override the regular prices with special prices when members are asked to renew. The system must keep track of these new prices so that renewals can be processed accurately. One of the problems in the health club industry is the high turnover rate of members. Although some members remain active for many years, about half of the…
Muscat Auto Workshop
Muscat, which provides vehicle maintenance/repair services.
The charges of vehicle maintenance/repair are based on the type of the
service.
a vehicle service centre located in the city of
Details of charges are as follow:
Basic Tuning:
Software Re-installation: 60 OMR
Parts Replacement:
Body Paint:
50 OMR
100 OMR
120 OMR
The workshop offers 10% discounts to the customers who have membership
of the service centre.
You are required to draw a flow chart diagram and write a C++ computer
program that takes customer's name, car plate number, membership
status(Y/N) and the required service (mentioned above). The program
outputs the input data and maintenance charges based on the service
provided by the service centre with discount, if applies.
Church Information System
XYZ Church is a fast-growing church in Grand Rapids area. Over the past three years, since the popular Reverend Timothy Becker has taken over leadership of the congregation, the church has more than doubled in size. It now has approximately 400 registered households. Reverend John Howard has also recently been added as a second minister. Since the Church was rather small in the past, most of its records have been kept on paper forms. However, the Church’s Business Manager, Margie Roberts, has suggested to Reverend Becker that a computerized system might help the Church better meet its information needs and manage its activities.
In addition to Ms. Roberts, the Church employs a part-time administrative assistant, Mabel McGregory. Mabel performs clerical duties such as filing, record keeping, answering phone calls, and typing the weekly church bulletin using WordPerfect for Windows on the Church’s only personal computer. A retiree, Leroy Stricty, is employed…
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 - What is a derived attribute? Give an example. What...Ch. 4 - Prob. 11RQ
Ch. 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. 9PCh. 4 - Prob. 10PCh. 4 - Prob. 11C
Knowledge Booster
Similar questions
- Case Study 5 - Homework Question:After the user, has selected items to purchase and then order the items. The user will provide payment and shipping information. The system will respond with confirmation of the order and a tracking number that the user can use to check on order status in the future. The system will also provide the user with an estimated delivery date for the order, which will include all selected items. The user may already have an account with the company with billing and shipping information. Question: Describe the use case into a formal use case format as follows. Use Case Name: Place Order Actors - ….. Triggers: - …… Preconditions - ……… Post-conditions: - ……… Basic Flow of Events 1. ……… Alternative Flows …….arrow_forwardCase Study 5 - Homework Question: After the user, has selected items to purchase and then order the items. The user will provide payment and shipping information. The system will respond with confirmation of the order and a tracking number that the user can use to check on order status in the future. The system will also provide the user with an estimated delivery date for the order, which will include all selected items. The user may already have an account with the company with billing and shipping information. Question: Describe the use case into a formal use case format as follows.arrow_forwardDRY infractions are those that fall outside of the guidelines. Why do you think that is?arrow_forward
- Fordley Car Park is open between 7am and 9pm every day. They charge £2.30 per hour with a minimum fee of one hour and a £2 overnight charge for stays between 9pm and 7.30am. Payments are made at the end of a visit. The car park is also used by resident and business permit holders on the basis of annually renewable membership. All new memberships are registered via the Fordley Car Park website or by completing a form which can be picked up from the car park attendant. Recently Fordley has invested in a paperless attended smart parking system that scans car registration numbers as cars drive through the entrance gate. To ensure that a reading has been captured, the gates only open when a valid registration is read. Exit gates also have a camera which scans the car registration number and will open automatically unless payments are outstanding in which case the payment can be made at the attendant kiosk without leaving the car. Members whose membership has expired can also pay for the…arrow_forwardFordley Car Park is open between 7am and 9pm every day. They charge £2.30 per hour with a minimum fee of one hour and a £2 overnight charge for stays between 9pm and 7.30am. Payments are made at the end of a visit. The car park is also used by resident and business permit holders on the basis of annually renewable membership. All new memberships are registered via the Fordley Car Park website or by completing a form which can be picked up from the car park attendant. Recently Fordley has invested in a paperless attended smart parking system that scans car registration numbers as cars drive through the entrance gate. To ensure that a reading has been captured, the gates only open when a valid registration is read. Exit gates also have a camera which scans the car registration number and will open automatically unless payments are outstanding in which case the payment can be made at the attendant kiosk without leaving the car. Members whose membership has expired can also pay for the…arrow_forwardPreliminary investigation: Describe the procedures used and the final result producedarrow_forward
- Welcome statement for presentationarrow_forwardProject Description A telephone book system, also known as a telephone directory, telephone address book, or Phone book, is a listing of telephone subscribers in a geographical area or subscribers to services provided by the organization that publishes the directory. Its purpose is to allow the telephone number of a subscriber identified by name and address to be found. Project Features The features of telephone book system are mainly related to adding, listing, searching, sorting, modifying and deleting telephone directory-related records. All these operations are done through Linked-List. The information contained in the telephone directory records are the first name, last name, phone number, city, address, sex and email of the person whose record is entered in the telephone directory system. Project Operations Write a JAVA program that will maintain a phone directory using a Linked-List. The program should be able to perform the following operations: Add persons details (first…arrow_forwardaccess model for writing Only Leena has access to her laptop. The site is only accessible during regular business hours. The file is read-only and cannot be changed in any way. Only the course instructors are allowed access to the students' information.arrow_forward
- System Description: Branches Dream Home has branch offices in cities throughout the United Kingdom. Each branch office is allocated members of staff, including a Manager, who manages the operations of the office. The data describing a branch office includes a unique branch number, address (street, city, and postcode), telephone numbers (up to a maximum of three), and the name of the member of staff who currently manages the office. Additional data is held on each Manager, which includes the date that the Manager assumed his or her position at the current branch office, and a monthly bonus payment based upon his or her performance in the property for rent market. Staff Members of staff with the role of Supervisor are responsible for the day-to-day activities of an allocated group of staff called Assistants (up to a maximum of 10, at any one time). Not all members of staff are assigned to a Supervisor. The data stored regarding each member of staff includes staff number, name, address,…arrow_forwardSystem Description: Branches Dream Home has branch offices in cities throughout the United Kingdom. Each branch office is allocated members of staff, including a Manager, who manages the operations of the office. The data describing a branch office includes a unique branch number, address (street, city, and postcode), telephone numbers (up to a maximum of three), and the name of the member of staff who currently manages the office. Additional data is held on each Manager, which includes the date that the Manager assumed his or her position at the current branch office, and a monthly bonus payment based upon his or her performance in the property for rent market. Staff Members of staff with the role of Supervisor are responsible for the day-to-day activities of an allocated group of staff called Assistants (up to a maximum of 10, at any one time). Not all members of staff are assigned to a Supervisor. The data stored regarding each member of staff includes staff number, name, address,…arrow_forwardSystem Description: Branches Dream Home has branch offices in cities throughout the United Kingdom. Each branch office is allocated members of staff, including a Manager, who manages the operations of the office. The data describing a branch office includes a unique branch number, address (street, city, and postcode), telephone numbers (up to a maximum of three), and the name of the member of staff who currently manages the office. Additional data is held on each Manager, which includes the date that the Manager assumed his or her position at the current branch office, and a monthly bonus payment based upon his or her performance in the property for rent market. Staff Members of staff with the role of Supervisor are responsible for the day-to-day activities of an allocated group of staff called Assistants (up to a maximum of 10, at any one time). Not all members of staff are assigned to a Supervisor. The data stored regarding each member of staff includes staff number, name, address,…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 LearningEnhanced Discovering Computers 2017 (Shelly Cashm...Computer ScienceISBN:9781305657458Author:Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. CampbellPublisher:Cengage LearningCOMPREHENSIVE MICROSOFT OFFICE 365 EXCEComputer ScienceISBN:9780357392676Author:FREUND, StevenPublisher:CENGAGE L
- Np Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:CengageManagement Of Information SecurityComputer ScienceISBN:9781337405713Author:WHITMAN, Michael.Publisher:Cengage Learning,
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Enhanced Discovering Computers 2017 (Shelly Cashm...
Computer Science
ISBN:9781305657458
Author:Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. Campbell
Publisher:Cengage Learning
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:9780357392676
Author:FREUND, Steven
Publisher:CENGAGE L
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
Management Of Information Security
Computer Science
ISBN:9781337405713
Author:WHITMAN, Michael.
Publisher:Cengage Learning,