Algebra

Jamel Travis 11/10/2012 Homework 8 Authorization is the process of assigning permissions to users. True Authentication is the process of assigning permissions to users. False In SQL Server, a login provides database level permissions. False In SQL Server, the USER is mapped to a login and assigned database permissions. True Permission is an action granted to a database user. True A role is a collection of related permissions True A role consists of ownership of database objects. False A schema consists of ownership of a database objects. True Permission to SELECT allows a user to view data. True Permission to UPDATE allows a user to add records to the database. True

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

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