Ch05

Download Document
Showing pages : 1 - 2 of 12
This preview has blurred sections. Sign up to view the full version! View Full Document
Chapter 5 Organizing and Manipulating Data in Databases True-False Questions 1. Normalizing accounting data refers primarily to eliminating errors and outliers, thus creating “normal data.” 2. An important reason for normalizing data is to eliminate data redundancy. 3. A flat file is a database with no records. 4. There are exactly three normal forms. 5. Databases cannot store more than one value in the same data field of the same record. 6. A database is in first normal form if all of its record’s data fields are well defined and the information can thus be stored as a flat file. 7. A database is in first normal form if the data it contains is free of errors and outliers. 8. A database is in second normal form if all of its records are in first normal form, and a second, duplicate record exists for each of them. 9. A database is in third normal form if all of its records are in second normal form, and there are no transitive dependencies. 10. An example of a transitive relationship in a parking-tickets application is the one between “ticket code” and “fine amount.” 11. An example of a transitive relationship in a medical application is the one between “medical procedure code” and “cost of treatment.” 12. An example of a transitive relationship in a medical application is the one between “doctor number” and “doctor name.” 13. An example of a transitive relationship in a medical application is the one between “doctor number” and “patient name.” 14. The letter “M” in the acronym DBMS stands for “maintenance.” 15. The letter “M” in the acronym DBMS stands for “management.” 16. A DBMS is a type of hardware. 17. A DBMS is a type of software. 18. DDL is an acronym for “data definition language.” TB 5.1
Background image of page 1
19. Databases are the same thing as database management systems. 20. A DBMS is an efficient database table in third normal form. 21. When purchasing a new database management system, managers should focus on the system’s technological capabilities rather than its compatibility with current systems. 22. An example of a data type for a database record field is “text.” 23. An example of an input mask for an Access data field is “000\-00\-0000.” 24. Database designers typically store employee Social Security numbers as “Long Integer” data types. 25. DML stands for “data management logic.” 26. Database management systems allow their users to create “input masks” which help to prevent input errors. 27. A database schema is a plan of the entire database. 28. A database subschema is a plot that can often be discovered with forensic accounting. 29. SQL is an example of a database query language.
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.