CS-669 Assignment 1
The two parts in this assignment will contribute equally to your grade and will be evaluated separately.
Part 1: Database Concepts
Imagine that a countryside inn maintains its data in flat files on a file system. To assist in reserving rooms and booking guests, the innkeepers use a custom application that accesses these flat files. The innkeepers sometimes access 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 the inn over their current data management solution.
The purpose of the DBMS is to service between users’ applications and database. This way of accessing to data through the DBMS brings several advantages. First of all, it supports multiple user access at the same time, which helps to update data just in time.
DBMS provide better security and integrity to the stored data, because the DBMS stands at the gates of access where it helps to enforce security policy.
It reduces data inconsistency where the same data may display in different locations.
It also supports quick requests in query such that ad hoc query and responses almost immediately.
As a result, it positively effects to make decisions.
Increases end user productivity as well.
Topic 2: Structural Independence
Database systems exhibit structural independence, which occurs when the way that applications and users operate with the database is independent of how the data is actually stored in the file system or other storage device. Explain why structural independence is important to the innkeepers. Structural independence when we can change structure of stored data without affecting to access of user’s applications. It is essential, otherwise in case of dependency there would be need to make all necessary adjustments to keep the same type access that the users have.
Topic 3: Problems with Data Redundancy
Data
Part 1: Database Concepts
Imagine that a countryside inn maintains its data in flat files on a file system. To assist in reserving rooms and booking guests, the innkeepers use a custom application that accesses these flat files. The innkeepers sometimes access 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 the inn over their current data management solution.
The purpose of the DBMS is to service between users’ applications and database. This way of accessing to data through the DBMS brings several advantages. First of all, it supports multiple user access at the same time, which helps to update data just in time.
DBMS provide better security and integrity to the stored data, because the DBMS stands at the gates of access where it helps to enforce security policy.
It reduces data inconsistency where the same data may display in different locations.
It also supports quick requests in query such that ad hoc query and responses almost immediately.
As a result, it positively effects to make decisions.
Increases end user productivity as well.
Topic 2: Structural Independence
Database systems exhibit structural independence, which occurs when the way that applications and users operate with the database is independent of how the data is actually stored in the file system or other storage device. Explain why structural independence is important to the innkeepers. Structural independence when we can change structure of stored data without affecting to access of user’s applications. It is essential, otherwise in case of dependency there would be need to make all necessary adjustments to keep the same type access that the users have.
Topic 3: Problems with Data Redundancy
Data