Questions from Database Systems


Q: What actions are taken during the database initial study, and why

What actions are taken during the database initial study, and why are those actions important to the database designer?

See Answer

Q: What are the client/server's infrastructure requirements and how do they

What are the client/server's infrastructure requirements and how do they function?

See Answer

Q: Define and discuss the concept of transitive dependency.

Define and discuss the concept of transitive dependency.

See Answer

Q: What is a surrogate key, and when should you use one

What is a surrogate key, and when should you use one?

See Answer

Q: Why is a table whose primary key consists of a single attribute

Why is a table whose primary key consists of a single attribute automatically in 2NF when it is in 1NF?

See Answer

Q: How would you describe a condition in which one attribute is dependent

How would you describe a condition in which one attribute is dependent on another attribute when neither attribute is part of the primary key?

See Answer

Q: Suppose that someone tells you that an attribute that is part of

Suppose that someone tells you that an attribute that is part of a composite primary key is also a candidate key. How would you respond to that statement?

See Answer

Q: When is a table in 1NF?

When is a table in 1NF?

See Answer

Q: When is a table in 2NF?

When is a table in 2NF?

See Answer

Q: When is a table in 3NF?

When is a table in 3NF?

See Answer