Computer Science Homework Solutions
Problem
#13889

Entity types, main relationship types, multiplicity constraints... etc...

The video rental company has several branches throughout the USA. The data held on each branch is the branch address made up of street, city, state, and zip code, and the telephone number.  Each branch is given a branch number, which is unique throughout the company. Each branch is allocated staff, which includes a manager. The manager is responsible for the day-to-day running of a given branch. The data held on a member staff is his or her name, position, and salary. Each member of staff is given a staff number, which is unique throughout the company. Each branch has a stock of videos. The data held on a video is the catalog number, video number, title, category, daily rental, cost, status, and the names of the main actors and the directors. The catalog number uniquely identifies each video. However, in most cases, there are several copies of each video at a branch, and the individual copies are identified using the video number. A video is given a category such as Action, Adult, Children, Drama, Horror, or Sci-Fi. The status indicates whether a specific copy of a video is available for rent. Before renting a video from the company, a customer must first register as a member of a local branch. The data held on a member is the first and last name, address, and the date that the member registered at the branch. Each member is given a number, which is unique throughout the branches of the company. Once registered, a member is free to rent videos, up to a maximum of ten at any one time. The data held on each video rented is the rental number, the full name and number of the member, the video number, title, and daily rental, and the dates the video is rented out and returned. The rental number is unique throughout the company.
Need each to be separate.. Thanks

a. Identify the main entity types of the video rental company.

b. Identify the main relationship types between the entity types described in (a) and represent each relationship in an E-R diagram.

c. Determine the cardinality constraints for each relationships described in (b). represent the cardinalities for each relationship (in max & min form) in the E-R diagram created in (b).

d. Identify attributes and associate them with entity or relationship types. Represent each attribute in the E-R diagrams created in (c).

e. Determine candidate and primary key attributes for each (strong) entity type.

f. Using your answers (a) to (e) attempt to represent the data requirements of the video rental company as a single E-R diagram. State any assumptions necessary to support your design.

Solution
What is this?
By OTA - Overall OTA Rating
Suraj Joshi, PhD (IP) - 4.7/5
Purchase Cost Now
$2.19 CAD (was ~$7.98)
Included in Download
  • Plain text response
  • Attached file(s):
    • Q1.doc
    • Untitled-1.pdf
$2.19 Instant Download
Add to Cart
Why you can trust BrainMass.com
  • Your Information is Secure
  • Best Online Academic Help Service
  • Students find real academic Success
Related Solutions
  • Systems Analysis-explanation on multiplicity on an association - What information is shown by multiplicity on an association end. I need to provide an example demonstrating my explanation that does not come from the ATM example.
  • Entity-Relationship Diagrams - - Why are Entity-Relationship Diagrams (ERDs) an important initial stage in developing databases? Who would be the initial parties interacting to develop the ERDs? Have you a personal experience you w ...
  • Entity Relationship Diagram - 2. ERD (Entity Relationship Diagram) You will develop the entity relationship diagram (ERD) for your project database based on the initial data requirements. The company that we are working on ...
  • E-R Diagram - Assume that at XYZ company each product (described by Product No., Description, and Cost) is comprised of at least three components (described by Component No., Description, and Unit of Measure) and c ...
  • Database - Describe how you would design a database to keep track of all the students at a university. describe tables, relationships, attributes, Primary Keys, Foreign Keys, Candidate Keys. Describe minimum and ...
Browse