CSCI 1320 - Database Fundamentals

What is a DBMS?

A Database Management System (DBMS) is a collection of programs enabling users to access databases, manipulate data, and present data

What is a legacy database?

A database that predates the relational model or any system that predates current technology

What is true of foreign keys?

A foreign key is a column or columns that is the same as the primary key of some table in the database.

What is an "ERD"?

An ERD is an Entity-Relationship diagram.

What is an "attribute"?

An attribute represents one of the columns in an individual table.

What is an "entity"?

An entity, for our purposes, is the same as a table in the database.

What is a relational database?

An organized collection of structured data, and information about relationships

The keywords within a T-SQL statement must always be in upper case.

False

When joining tables in a Select statement there must exist a common column in both tables and it is a technical requirement that this column have the same name in each table. This statement is . . .

False

Which of the following are open source relational databases.

MySQL. PostgreSQL.

What is the most common relationship within a relational database?

One-To-Many relationship.

Relational Databases are designed for what specific kind of processing?

Online Transaction Processing (OLTP)

Which of the following is true when using an inner join?

Only rows that have related rows on both sides of the join are returned.

Who determines what data needs to be secured to maintain privacy?

Only the owner of the data, which typically is a company.

What is "Referential Integrity"?

Referential integrity is a constraint enforced by the DBMS that ensures consistency of the cross-references between and among tables.

In a web database architecture what is the primary concern?

Security

How should the components within Service Oriented Architecture be viewed?

Services

The work of systems analysis includes all of the following except which one answer?

Systems analysis helps to ensure everyone in the organization understands the technical design of the database.

What is true with respect to a row's primary key?

The primary key should contain a value that should never change; the value should be immutable. The primary key must not contain the value null.

There are several downsides to using the Safari Online database of which we must all be aware.

There exists the possibility that a title that currently is available in Safari Online might not be so in the future. The materials available through Safari cannot be downloaded, and therefore can only be accessed via an Internet connection. Some of the video content is not Americans with Disabilities Act (ADA) compliant.

You know that you have a lot of old data in the Departments table, and many of the department names are no longer used—meaning that no employee rows are matched to these old department rows. Which is the best join to use if I want a list of Departments where there are no Employees related (matched) to those departments?

You can use either the left or right join to produce the result set needed.

Which of the following are tools used in conducting needs assessments?

observation, interviews, questionnaires, focus groups, and brainstorming sessions.

Insert the correct commands for a basic select command that returns all rows and all columns specifying the proper selection, location, filter and sort keywords:

select * from table name where condition value(s) order by column(s)

The right join provides no additional functionality over the left join. Anything that can be accomplished with a right-join can also be accomplished with a left-join. This statement is . . .

True

Which of the following answers is the correct response to the issue/question of single-valued versus multivalued attributes?

In the design of a relational database there should never be multivalued attributes.

What is a "meaningful" identifier?

This generally is a key where the value of the key carries implicit meaning.

You have a table called Employees. For each employee there is a MangerID column. This column provides the employee number (also from the same Employees table) of the person who is the manager for the employee selected. If you wish to create a query that will show each employee and then their manager (remember the manager is simply an employee in the same table) which is the best join to use?

This is an example of a self-join.

The 'T' in T-SQL stands for, what?

Transact