WorksheetsDatabase Design and SQL Quiz
Total questions: 10
Worksheet time: 5mins
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
