Dear All,
I am bit confused on how to structure this scenerio as some of the entities have same attributes and some having two unique attributes in a table. Please, how can this be sorted out? Below is the case study. Thank you.
A DVD Rental Company has several branches, one in Manchester, one in London and one in Birmingham . The data held on each branch is the branch address made up of street, city, county, postcode 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 of 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 DVDs. The data held on a DVD is the catalogue number, DVD number, title, category, daily rental, cost, status and the names of the main actors and director. The catalogue number uniquely identifies the DVD. In some cases, however, there are several copies of each DVD at a branch, and the individual copies are identified using the DVD number. A DVD is given a category such as Action, Children, Drama, Sci-Fi or Horror. The status indicates whether a specific copy of a DVD is available for rent.
Before borrowing a DVD from the company, a customer must first register as a member of a local branch. Each member is given a member number, which is unique throughout all branches of the company. Once registered, a member is free to rent DVDs, up to a maximum of ten at any one time . The data held on each DVD rented is the rental number, the full name and number of the member, the DVD number, title and daily rental, and the dates the DVD is rented out and returned. The DVD number is unique throughout the company
I am bit confused on how to structure this scenerio as some of the entities have same attributes and some having two unique attributes in a table. Please, how can this be sorted out? Below is the case study. Thank you.
A DVD Rental Company has several branches, one in Manchester, one in London and one in Birmingham . The data held on each branch is the branch address made up of street, city, county, postcode 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 of 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 DVDs. The data held on a DVD is the catalogue number, DVD number, title, category, daily rental, cost, status and the names of the main actors and director. The catalogue number uniquely identifies the DVD. In some cases, however, there are several copies of each DVD at a branch, and the individual copies are identified using the DVD number. A DVD is given a category such as Action, Children, Drama, Sci-Fi or Horror. The status indicates whether a specific copy of a DVD is available for rent.
Before borrowing a DVD from the company, a customer must first register as a member of a local branch. Each member is given a member number, which is unique throughout all branches of the company. Once registered, a member is free to rent DVDs, up to a maximum of ten at any one time . The data held on each DVD rented is the rental number, the full name and number of the member, the DVD number, title and daily rental, and the dates the DVD is rented out and returned. The DVD number is unique throughout the company