Peer Generated Review Questions

Person, place, thing, event about which information is maintained

• Database
• Entity
• Attribute
• Key field

Is a shared collection of interrelated data, designed to meet the needs of multiple types of end users.

• Entity
• Data Structure
• Spreadsheet
• Database

What are the examples of the DBMS?

• MS Access
• Oracle MySQL
• Oracle Database
• IBM DB2
• All of the Answers

What best describes a Field

• Group of bits that represents a single character

• Group of words or a complete number

• Group of records of same type

• Smallest unit of data

Which of the following is not a type of datatype in database

• Date/Time

• Integer

• Hyperlink

• Attachment

Which of the following key is a DBMS assigned unique identifier

• Primary key
• Foreign Key
• Composite key
• Surrogate key

Entity Relationship modelling is based on which of the following concepts

• A) Entities and Relationships

• B) Data and relationships

• C)Data dictionary and Data type

• D) student and customers

Which one of the following is a type of relationship in an ERD?

• One to Many
• many to zero
• None to One
• two to many

What normalization form must not have any transitive dependency on any column of a primary key?

• 1NF
• 2NF
• 3nf
• 4NF

What is the relationship for these statements? A student must attend a university. The university may or may not offer a scholarship

• 1 and only 1, 1 or more

• 1 and only one, zero or 1

• 1 or more, zero or more

• 1 or more, 1 and only 1