This preview has intentionally blurred parts. Sign up to view the full document

View Full Document

Unformatted Document Excerpt

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 records 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 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 systems 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.... View Full Document

End of Preview

Sign up now to access the rest of the document