Entity-Relationship
Modeling
Database Core Concepts
SQL
Keys
Potpourrie
100
Anything that we're interested in collecting data on
What is an entity.
100
Sits between a Database Application and your Data
What is a Database Management System (DBMS)
100
What does SQL stand for?
What is Structured Query Language
100
A value that uniquely identifies an individual row.
What is a primary key.
100
This team defeated the Cincinnati reds in the NL Wildcard Game by a score of 6-2
Who are the Pittsburgh Pirates!
200
1:1, 1:N, or N:M
What is cardinality.
200
The data that describes the data.
What is metadata.
200
Describe this SQL Statement INSERT INTO PROJECT (Department, ProjectName) VALUES ('Finance','KPMG');
What is Insert Finance and KPMG as values for Department and ProjectName in the Project Table.
200
A key comprised of two or more attributes.
What is a composite key.
200
This company was the first to develop and market database software that used relational designs
What is Oracle
300
Determines whether a relationship is required or merely optional.
What is existence (referential integrity)
300
Data put to use is called this.
What is information.
300
Describe the following SQL Statement; SELECT FirstName, LastName FROM EMPLOYEE WHERE EmployeeNumber > 2 AND < 5;
What is select the FirstName and LastName of Employees with EmployeeNumbers 3 and 4.
300
An attribute that is a key of one or more relations other than the one in which it appears.
What is a foreign key.
300
This piece of legislation governs the way that health information must be stored in a database.
What is HIPAA (Health Insurance Portability and Accountability Act).
400
These describe an entity's characteristics
What are attributes.
400
Modification actions that pose problems for lists.
What are insert, update and delete.
400
Describe this SQL Statement: SELECT * FROM CUSTOMER WHERE LastName LIKE 'Ch___h';
What is select everything from the customer table where the person's last name has a "Ch" followed by any three letters followed by an "h".
400
A unique, system-supplied identifier used as a primary key in a relation. It has no meaning to users.
What is a surrogate key.
400
This man developed the relational database model while working at IBM.
Who is E.F. Codd
500
An occurrence of a particular entity.
What is an entity instance.
500
The steps for breaking tables with more than one theme into a set of tables such that each has only one theme.
What is normalization.
500
Describe the following SQL Statement SELECT EmpName FROM EMPLOYEE AS E JOIN DEPARTMENT AS D ON E.DeptID = D.DeptID WHERE D.DeptName LIKE 'Account%';
What is Select the EmpName's from the Employee and Department Tables joining the tables based on DeptID as a foreign key in the Employee Table and Primary key in the Department Table, where the Department name starts with "Account".
500
A key that potentially identifies more than one row.
What is a non-unique key.
500
DAILY DOUBLE!!!!! Race the other team to model this ER diagram scenario on the board. A Country Bus Company owns a number of busses. Each bus is allocated to a particular route, although some routes may have several busses. Each route passes through a number of towns. One or more drivers are allocated to each route. Some of the towns have a garage where busses are kept. Each route is identified by a route number and information is available on the average number of passengers carried per day for each route. Drivers have an employee number, name, address, and sometimes a telephone number.
Answers may vary.
M
e
n
u