Flashcards
Info Retrieval P2
Cards in this deck (10)
- 1A(n) ____ is a system-generated primary key that is usually hidden from users.Surrogate key.
- 2When a DBMS creates a(n) ____ key, it is usually an automatic numbering data type, such as the Access AutoNumber data type.Surrogate
- 3A natural key is also called a(n) ____ key.Intelligent
- 4Which of the following shows sample DBDL documentation for the Employee table?Employee (EmployeeNum, LastName, FirstName, Street, City, State, PostalCode, WageRate, SocSecNum, DepartmentNum)
AK SocSecNum
SK LastName
FK DepartmentNum→Department - 5An alternative to the primary key of a table is listed with the ____ abbreviation in DBDL.AK
- 6Combining the following two tables would result in ____. Employee (EmployeeNum, LastName, FirstName, WageRate, SocSecNum, DepartmentNum) Employee (EmployeeNum, LastName, FirstName, Street, City, State, PostalCode)Employee (EmployeeNum, LastName, FirstName, WageRate, SocSecNum, DepartmentNum, Street, City, State, PostalCode)
- 7Independent entities have ____ in an E-R diagram.Square Corners.
- 8An entity that does not require a relationship to another entity for identification is called a(n)Independent Entity.
- 9A relationship that is necessary for identification is called a(n) ____.Identifying Relationship
- 10Convert the following table to first normal form: Branch (BranchNum, BranchName, (BookCode, Title, OnHand) )Branch (BranchNum, BranchName, BookCode, Title, OnHand)???
Information
- Description
- Flashcards on Info Retrieval P2, created by Joshua Arteaga on 09/10/2018.
- Created by
- Joshua Arteaga
- Views
- 31
- Rating