Database

Jamel Travis 11/17/2012 Homework 9 Threat analysis is about identifying all the ways the database can be harmed. True Accidental threats are as great a danger to a database as intentional ones. True A policy is a set of step by step instructions for accomplishing a task. False A procedure is a set of rules for how to do things. False A disaster recovery plan is a plan for how to recover data and availability after any of various disasters. True A stored procedure is one or more SQL statements grouped to be executed together. True Stored procedures can be used to enforce business rules and make transactions such as updates safer. True The syntax for stored procedures is the same in any database management system. False

PT 2520 Unit 1 Homework Clarence Gross 12/22/12 At its simplest, a database can be seen as a collection of related data. True A delimited file is a file where the length of the file is limited. False A delimited file is one in which the data is separated by a character such as a comma. True All fixed length files are of the same length. True In relational database, logic design is kept separate from physical design. True A hierarchical database is designed with a tree-like structure that resembles a file system. True Codd defined the core principles of a relational database in 1970 True Data redundancy improves the integrity of a database. False In a diagram, crows feet notation conveys more information about the relationships. True