Data modeling

Jamel Travis 10/27/2012 Homework Unit 5 Choosing a database management system requires a great deal of analysis. True When choosing a database management system, you should consider system compatibility and hardware requirements. True Only insert and update statements are part of a database transaction. False Physical design is a column specification that determines what kind of data can be stored in it. True A data type is a column specification that determines what kind of data can be stored in it. True Int, decimal and money are character numeric types. True Char and NChr are variable-length character types. True Varchar and NVarchar are based on the Unicode character types. False NChar and NVchar are based on the Unicode character set. True

PT2520 Clarence Gross 1/19/12 Unit 3 The logical design is independent of any database management system. True The physical design is the logical design adapted to the constraints and features of the database management system. True You should always try to create cross relationships between parent and tables. False Naming conventions help support clarity and consistency in database design. True One to one relationships between entities are valid but rare. True Crow?s feet notation conveys more information about cardinality than arrow notation. True In a one-to-many relationship, each row on in the primary key table can be related to any number of rows in the foreign key or child table. True

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