User Account

All Pages

Redraw the erd using the crow foot model

Assignment Help Database Management System
Reference no: EM13925447

1. Use the following Chen model ERD to answer questions 1 through 9.

792_ERD.png

1. List the entities shown.

2. What is the primary key for each entity?

3. Are there any multivalued attributes shown? If so, discuss how it/they should be handled in the implementation of the relational database.

4. Are there any derived attributes shown? If so, discuss how it/they should be handled in the implementation of the relational database.

5. Looking at the relationship cardinalities shown in the ERD, what is the minimum number of pets that a customer can own?

6. Looking at the ERD, is Pet an optional or mandatory participant in the "Owns" relationship?

7. Looking at the relationship cardinalities show in the ERD, what is the maximum number of pets that a customer can own?

8. What is the degree of the relationship?

9. Redraw the ERD using the Crow's Foot model.

2. Use the following case to complete questions 10 through 13.

Meridian News publishes a daily newspaper and would like a database developed to maintain information about subscribers and subscriptions. Each subscriber is uniquely identified by a subscriber number and is also characterized by first name, last name, address, and phone number. Each subscription is uniquely identified by a subscription number and is also characterized by subscription type (Daily or Sunday only), price, start date, and expiration date. The price paid for a subscription is input when the subscription is sold, since it may vary due to special offers or situations. Expired subscriptions and former subscribers that no longer have a current subscription remain in the database.

The example report below shows the subscriptions belonging to subscriber number 31893.

Jacob Smith 13 Milky Way, Phoenix,                                                          AZ 85001 Subscriber#: 31893                                                                        Printed: 07/15/2003
Subsription Type Price Start End
242034 S $96.00 1/1/2002 12/31/2002
245132 D $13.65 1/1/2003 6/30/2003
246328 D $81.90 7/1/2003 12/31/2003

10. Identify the entities discussed in the case.

11. What is the minimum number of current subscriptions for a subscriber?

12. What is the maximum number of subscriptions for a subscriber?

13. Using the Crow's Foot model, draw an ERD for the Meridian News database and state any assumptions you believe you have to make in order to develop a complete diagram.

3. Use the following information to answer question 14 through 16.

Nazca Cinemas is a small movie theater that would like you to design a movie scheduling database system for them. The theater has four rooms (screens). Each room has its own unique ID and the seating capacity and screen size for each are recorded. Each movie is assigned a unique movie ID and its title and runtime are recorded.

Assume the following:

• A movie can be shown more than once on a given date.
• A movie can be shown more than once in a given room.
• A movie can be shown in more than one room simultaneously.
• Several showings can be booked at different start times in a given room on a given date.

The following unnormalized relation has been developed based on this case. Do not add any additional attributes:

SHOWING (MovieID, Title, Runtime, RoomID, ScreenSize, Capacity, Date, StartTime)

14. Convert the unnormalized relation into 1NF and briefly discuss the changes that were necessary.

15. Convert the 1NF relation to 2NF and briefly discuss the changes that were necessary.

16. Convert the 2NF relation to 3NF and briefly discuss the changes that were necessary.

4. Use the following information to answer question 17 through 19.

The following unnormalized relation shows a modified version of the Nazca Cinemas case problem. A ShowingID attribute has been added to the relation. Each individual showing (a given movie in a given room on a given date at a given time) of a movie is given its own unique ShowingID. Using the modified version of the unnormalized relation, rework the normalization process. Do not add any additional attributes to those shown in this unnormalized relation:

SHOWING (ShowingID, MovieID, Title, Runtime, RoomID, ScreenSize, Capacity, Date, StartTime, EndTime)

17. Convert the modified unnormalized relation into 1NF and briefly discuss the changes that were necessary.

18. Convert the 1NF relation to 2NF and briefly discuss the changes that were necessary.

19. Convert the 2NF relation to 3NF and briefly discuss the changes that were necessary.

Reference no: EM13925447

Questions Cloud

What if it changed its payout ratio : how would the value of a firm change if it borrowed money to repurchase outstanding common stock, greatly increasing its leverage? What if it changed its payout ratio?
Design a contact page and add to the website : Create a CSS navigation bar with roll over effects for the website. Design a contact page and add to the website.
Record the accrued interest at december : Prepare an income statement, statement of changes in stockholders equity, balance sheet, and statement of cash flows for 2013.
How you implement your strategy using returns based analysis : Given monthly B/P, E/P, and beta values for 500 stocks, how could you implement your strategy (a) using comparative valuation? (b) using returns- based analysis?
Redraw the erd using the crow foot model : Looking at the ERD, is Pet an optional or mandatory participant in the "Owns" relationship? Looking at the relationship cardinalities show in the ERD, what is the maximum number of pets that a customer can own
The shape of a production possibility curve : Refer to the table shown. Diminishing marginal productivity begins when the? Refer to the graph shown. If this monopolistically competitive firm maximizes profit, it will
What is the annual operating cash flow of the project : Bottoms Up Diaper Service is considering the purchase of a new industrial washer. It can purchase the washer for $9,000 and sell its old washer for $2,200. The new washer will last for 6 years and save $2,700 a year in expenses. If the firm uses stra..
Potential physical vulnerabilities and threats : 1. Identify and analyze any potential physical vulnerabilities and threats that require consideration. 2. Identify and analyze any potential logical vulnerabilities and threats that require consideration.
Each bottle of mink caress : Two grams of musk oil are required for each bottle of Mink Caress, a very popular perfume made by a small company in western Siberia

Reviews

Write a Review

Database Management System Questions & Answers

  Define the benefits of use-case modeling

Describe the biggest challenge to the successful use of use-case modeling and recommend how to overcome the challenge.

  Prepare a use case diagram for the case study

Case Study based on an Interview contained in a separate document (Please see the details in page 221 of your text book). Carefully read this case study. You are required to answer the following questions based on the Case Study.

  Create an entity relationship diagram

For your final project you will create an Entity Relationship Diagram (ERD), create tables in your own database, and import data into these tables. For Part 1 of the Project, you will create the ERD. For Part 2 you will build the tables and load t..

  Database modeling

After reading this week's article, "Modeling for the Future," expand on the subject of Database Modeling. There are several tools listed and reviewed in the article. Research these tools further, or identify other modeling tools

  Identify all entities that have a direct bearing on database

Describe all the business rules that apply to this problem (relationship and constraint). Using the relationship business rules, establish the correct relationships (1:1, 1: M, M: N) between the entities.

  Compute numbers of married men-single men from table

Compute the numbers of married men, single men, married women and single women. Print these numbers on a student summary report.

  List and explain the defined business rules

The Relational Data Model (RDM) which corresponds to the ERD in the format shown below. The RDMMUSTidentify all primary keys, alternate keys and foreign key constraints. Raw SQL Create Table script dumps from a modeling tool, or SQL Server WILL NO..

  Each member in the club is assigned a number

Expand the database design you created in Question #1 so that it will also support the following situation: Ray wants to start a DVD rental program at his stores. He refers to each of his customers as "Members." Each member in the club is assigned a ..

  Variation of activity-based costing

Product cost of product U86Y under the company's traditional costing system is closest to - product cost of product M91F under the activity-based costing system

  Organize and implement rdbms for ercan airport management

design, organize and implement a RDBMS for Ercan Airport Management that will store, manipulate and retrieve all airport related information. The database you will design will organize the information about all the airplanes stationed and maintain..

  Q1 explain what a relational database is and explain why

you are the trainer for a major technology firm. one of the problems your firm has is hiring new technologists who have

  Study on managing the software enterprise

This course is for those in a management capacity, or those interested in management, involving the strategic consideration of software acquisition, development and project management.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd