Database Design and SQL Quiz

What does an Entity-Relationship Diagram (ER Diagram) describe?

• The SQL queries for a database

• The user permissions in a database

• The data types in a database

• The structure of a database

Which of the following is a characteristic of a Strong Entity?

• It has a primary key

• It depends on another entity

• It has no attributes

• It is represented by a diamond

What is a Multivalued Attribute in an ER Diagram?

• An attribute with a single value

• An attribute with multiple values

• An attribute that is derived from another

• An attribute that cannot be null

Which SQL statement is used to create a view?

• CREATE TABLE

• CREATE TRIGGER

• CREATE INDEX

• CREATE VIEW

What does the COUNT function in SQL do?

• Sums the values of a column

• Counts the number of rows

• Calculates the average value

• Finds the maximum value

What is a Referential Integrity Constraint?

• A rule that restricts null values in a column

• A rule that checks the uniqueness of a column

• A rule that ensures valid relationships between tables

• A rule that defines the data type of a column

What is the purpose of normalization in databases?

• To simplify SQL queries

• To create more tables

• To increase data redundancy

• To eliminate redundant data

Which of the following is NOT a type of functional dependency?

• Trivial functional dependency

• Non-Trivial functional dependency

• Multivalued functional dependency

• Composite functional dependency

What is an Insertion Anomaly?

• Redundant data in the database

• Inconsistency when updating data

• Loss of information when deleting data

• Inability to add data due to absence of other data

What does the term 'Aggregation' refer to in an Extended ER Model?

• Combining multiple entities into one

• Creating a higher-level entity from relationships

• Separating entities into sub-entities

• Defining attributes for an entity