ITC556 Database Systems

Your task is to explore the topic of graph databases and write down a small report discussing what they are, why they were needed, and what are some recent developments happening in this area.Your research report must be well presented using proper content organization. Cite all information sources using APA style. The expected word count is approximately
Part B: Data Modelling
Read the following case study and then carry out the data modelling tasks as described later.
DiscPeezy is a movietainment company whose business is to rent out DVD/Blu-ray movie discs through 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 is the 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 consistent stock level across all branches and kiosks, staff will regularly visit the kiosks and pick up the discs to move them to their original location.

Create a complete Entity Relationship Diagram (ERD) that can be implemented in the relational model. For a complete diagram, you will need to carefully deduce all the business rules from the given scenario.

Use Crow's Foot notations and make sure to include all of the following:
All entities Attributes for each entity
Primary key and any foreign key attributes for each entity
The relationships between entities
The cardinality and optionality of each relationship