ICT503 – Database Management Systems

Assignment Task

Task

1. Data modelling Using the ER Diagram 

Compay XYZ a movietainment company whose business isto rent out DVD/Blu-ray movie discsthrough their branches as well as self service kiosks. They have a small number of branches located in some Australian capital cities, but their kiosk network is quite extensive and distributed Australia wide. All the kiosks are located in shopping centres. The data held on each kiosk is the physical address made up of shopping centre name, street, city, state, and postcode. Data held about branches is similar, except there is no shopping centre name, but there is contact phone number. Each branch has a number of registered employees including a Manager who is responsible for the day-to-day running of a given branch. The data held on staff members their name, position, boss and monthly salary. Each branch maintains a stock of DVD and Bluray discs. The data held on a disc isthe catalogue number, disc number, disc type (DVD or Blu-ray), movie title, genre, daily rental cost, status, spoken language and the names of the director and the main actors. The catalogue number uniquely identifies each movie title. However, in most cases, there are several copies of each movie held at different branches and kiosks, thus the individual copies are identified using the disc number.The status indicates whether a specific copy of a movie disc is available or already rented out.

To rent a movie disc from the company, a customer must first register as a member. Member registration can take place in-person at a branch, or online through company website, or via touch screen displays present on their kiosks. To register, a customer needs to provide their full name, email address, credit card details and billing address. System also stores the date that the member registered. Once registered, a member is free to rent discs, up to maximum of 5 at any one time. Rentals can be sought at branches as well as kiosks. For each rental, database should store information about the customer, movie, rent date, daily cost and return date. For customer convenience, a disc can be returned at any DiscPeezy branch or kiosk regardless of where it was rented from. But in order to maintain consistentstock level across all branches and kiosks,staff will regularly visit the kiosks and pick up the discs to move them to their original location.

You are the given task to model a database for the information above. Draw a corresponding ER diagram for the database.

Please note:

• You can decide the names for entities, attributes and relations, but you should use UPPERCASE to name your entities and use capitalization to name attributes of entities

• Underline all primary key (PK) attributes and put (FK) next to all foreign key attributes

• Clearly indicate participation and cardinalities between entities

• Provide any assumptions made.

2. Normalisation

Draw a dependency diagram to show all dependencies in the given data including the partial and transitive dependencies. Normalize the table into a set of 3NF relations. Indicate the primary keys in all relations

This ICT503 - IT Computer Science Assignment Help has been solved by our IT Computer Science Experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.