Database Concepts Assignment
Added on - 09 Oct 2020
Assignment #4Practice task 1. Database ConceptsImagine that a 3 stars «Deluxe hotel» in Nur-Sultan maintains its data in flat files on a file system.To assist in reserving rooms and booking guests, the Deluxe hotel use a custom application thataccesses these flat files. The hotel sometimes accesses the files directly. With this scenario in mind,address each of the topics below:Topic 1: The Advantages of Database Management Systems. Identify and describe severaladvantages that a database system would offer Deluxe hotel over their current data managementsolution.Topic 2: Five Major Components of a DBMS. It describes database systems as having five majorcomponents: hardware, software, people, procedures, and data. If the hotel were to adopt adatabase management system, describe ways in which people would interact with and beresponsible for the hardware, software, procedures, and data. You don’t need to try to provide anexhaustive list, because that would be voluminous, but only an indication that you have thoughtabout how people would be responsible for and interact with each of the other four components.Practice task 2. Movies & DirectorsReview the following business rules regarding movies and directors to complete this part.- A director films one or more movies- A movie is filmed by one director- A genre applies to at least 10 movies- A movie is released in a yearThe business rules above specify all of the relevant entities; however, some business rules do notspecify both sides of the relationship. To get started, please1. List the names of all entities provided in the business rules above.2. Identify the entities that are related to each other.3. Identify the optionality and plurality constraints on both sides of each relationship, wherepossible.4. Create a complete list of business rules. The new list should not add additional entities, butshould specify the optionality and plurality constraints for both sides of all relationships.5. Create an entity-relationship diagram using Crow’s Foot notation that reflects your list ofbusiness rules.