Systems Analysis and Design 9th Chapter 9

1084 Words5 Pages
------------------------------------------------- 1. Explain the main difference between a file-oriented system and a database system. A file-oriented system utilizes data in a regular OS file based format where a database system uses a database engine that organizes data in a database in a table format utilizing rows for each record. 2. What is a DBMS? Briefly describe the components of a DBMS. DBMS stands for Database Management System. A DBMS is a collection of tools, features, and interfaces that enables users to add, update, manage, access, and analyze the contents of a database. A DBMS is made up of a DML (data manipulation language), Schema and subschemas, Physical data repository, and an Interface to allow…show more content…
9. Explain the difference between a logical record and a physical record. The canned answer is a logical record is a set of field values that describes a single person, place, thing, or event. Logical records as seen by an application is a group of related fields regardless of how or where the data is stored physically. For example, across multiple hard drives or multiple tables, databases etc. A physical record is the smallest data unit that can be handled by the operating system and has to do with the physical bytes that exist on a hard drive or other storage location. A physical record can contain many logical records. 10. How would a specific date, such as May 1, 2004, be represented as an absolute date? According to the book, on page 288, Microsoft uses Jan 1, 1900 as it's base date. If you have excel you can use a spreadsheet to calculate the date or just use the example provided. If May 13, 2003 is 37754, to get May 1, 2004 add 353 days and it should be 38107, but because 2004 was a leap year, it would be 38108. If you use Excel, enter the date May 1, 2004 into a cell, then format as a number and it will also give you 38108 as the answer. If you are writing the program, you can use any date as a base date, such as Jan 1, 2005. This date would be 1, every additional day would add 1 to the count, at the end of the year, Dec 31, 2005, the number would be 365 since it’s not a leap year. Using base dates, you can calculate

More about Systems Analysis and Design 9th Chapter 9

Open Document