Database Management Systems and Entity-Relationship Modeling
Added on 2020-10-09
3 Pages834 Words260 Views
|
|
|
Assignment #4 Practice task 1. Database Concepts Imagine 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 that accesses 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 several advantages that a database system would offer Deluxe hotel over their current data management solution. Topic 2: Five Major Components of a DBMS. It describes database systems as having five major components: hardware, software, people, procedures, and data. If the hotel were to adopt a database management system, describe ways in which people would interact with and be responsible for the hardware, software, procedures, and data. You don’t need to try to provide an exhaustive list, because that would be voluminous, but only an indication that you have thought about how people would be responsible for and interact with each of the other four components. Practice task 2. Movies & Directors Review 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 year The business rules above specify all of the relevant entities; however, some business rules do not specify both sides of the relationship. To get started, please 1. 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, where possible. 4. Create a complete list of business rules. The new list should not add additional entities, but should 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 of business rules.
End of preview
Want to access all the pages? Upload your documents or become a member.
Related Documents