CS-669 Assignment 1 Essay

991 WordsOct 23, 20134 Pages
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…show more content…
Data is a raw material and needs to be collected in proper way where later on the information can be boils down. The person who responsible is Data Base designer. Part 2: Converting a Spreadsheet to a Database You might encounter something akin to the table below in a spreadsheet or file-based application. First Last ID HoursWorked GrossPay Withholding NetPay PayDate Roger McHaney 1 38.5 $561.56 $112.31 $449.25 10/23/2012 Roger McHaney 1 38.5 $561.56 $112.31 $449.25 1/17/2012 Telly O'Grady 2 30 $489.06 $97.81 $391.25 3/1/2012 Telly O'Grady 2 30 $489.06 $97.81 $391.25 2/22/2012 Telly O'Grady 2 20 $326.04 $65.21 $260.83 3/6/2012 Telly O'Grady 2 44.5 $725.44 $145.09 $580.35 1/21/2012 Grant Brikestein 3 18 $408.60 $81.72 $326.88 10/23/2012 Alarry Abu 4 40 $728.80 $145.76 $583.04 1/17/2012 Betty Marygrade 5 35 $792.40 $158.48 $633.92 1/17/2012 Samuel Timod 6 40 $927.20 $185.44 $741.76 1/17/2012 Samuel Timod 6 40 $927.20 $185.44 $741.76 1/24/2012 Imagine that you want to convert this to a relational database. Answer the following questions, which are progressively more difficult: 1. How many records does this file contain? It contains 11 records. 2. How many fields are there per record? It contains 8 fields. 3. What are the field names? The names are: First, Last, ID, Hours Worked, GrossPay, Withholding, NetPay, PayDate. 4. What do the records in this table

More about CS-669 Assignment 1 Essay

Open Document