WorksheetsDatabase Design Quiz
Total questions: 30
Worksheet time: 2hrs 0mins
Identify the roles of database in the present business world.
i. Handling multifiles data access
ii. Controlling data security
iii. Equitable use
iv. Validating data
i and ii
ii and iii
i, ii and iii
i, ii and iv
Define the property of database that ensures the evolvement in order to satisfy the changes in user requirements.
flexibility
efficiency
usability
completeness
Identify the software that is used to define a database, stores data, produces reports and creates data entry screens.
Relational Database
Database Management System
Data Dictionary
Data Integrity
Identify the relation key that uniquely defines each row in a table.
Foreign Key
Candidate Key
Primary Key
Composite Key
Choose the correct symbol of PROJECT in the Relational Algebra.
˄
×
π
σ
In relational data model, the total number of values can be identified as ______________________ .
Cardinality
Tuple
Attribute
Entity
Choose the symbol of entity in the Entity Relationship Diagram.
Indicate the term for number of entities to which another entity can be associated via a relationship set.
Schema
Attributes
Cardinality
Entity
Identify the relational algebra operator that is applied to tables of Employees and Department to produce the following result as in the table.
An outer join operator
The cross product operator
The project operator
The natural join operator
A relation is in _______, if and only if, every determinant is a candidate key.
First normal form (1NF)
Second normal form (2NF)
Third normal form (3NF)
Boyce-Codd Normal Form (BCNF)
From a structural point of view, 2NF is better than _________________.
UNF
1NF
3NF
BCNF
Normalization works through a series called normal forms. Identify stages that are as high as needed to go in the normalization process for most purpose in business database design.
One
Two
Three
Unnormalised
Identify the type of SQL that were used to manipulate database structures, including tables.
Data Definition Language (DDL)
Data Manipulation Language (DML)
Database Management System (DBMS)
Structured Query Language (SQL)
Choose the SQL command that is used to change a table's storage characteristics.
CHANGE TABLE
EDIT TABLE
MODIFY TABLE
ALTER TABLE
Identify the following that hold a single valued attribute.
Address
Register_number
Reference
Subject_Taken
Identify which of the following relation would be produced by the relational algebra statement below.
Compute the inner join between the DEPARTMENT and EMPLOYEE relations.
Compute the natural join between the DEPARTMENT and EMPLOYEE relations.
Compute the set difference between the DEPARTMENT and EMPLOYEE relations.
Compute the cross product between the DEPARTMENT and EMPLOYEE relations.
Select the relational algebra statement to find employee tuples who work in Accounting Department called Sandra.
σ dept = ‘IT’ ˄ name = ‘Sandra’(EMPLOYEE)
σ dept = ‘IT’ ˅ name = ‘Sandra’(EMPLOYEE)
π dept = ‘IT’ ˄ name = ‘Sandra’(EMPLOYEE)
π dept = ‘IT’ ˅ name = ‘Sandra’(EMPLOYEE)
Choose the syntax for output in Table
σ staffID, name, department (π staffID=2211)(STAFF)
π staffID, name, department (σ staffID=2211)(STAFF)
π name, staffID, department (σ staffID=2211)(STAFF)
σ name, staffID, department (π staffID=2211)(STAFF)
Write the relational algebra to list employee’s number and employee’s name whose salary is greater than RM3000 in the table.
σ WorkerId, WorkerName (π Salary > 3000)(WORKER)
π WorkerId, WorkerName (σ Salary = 3000)(WORKER)
π WorkerId, WorkerName(σ Salary > 3000)(WORKER)
σ WorkerId, WorkerName (π Salary > 3000)(WORKER)
Entities can be associated with one another in Entity Relationship Diagram (ERD) using _____________.
relationship
cardinality
attributes
primary key
An entity in A is associated with at most one entity in B, and an entity in B is associated with at most one entity in A. Based on the statement, choose the relationship that has been applied.
one-to-many
one-to-one
many-to-many
many-to-one
Choose the denotation in a relational database which has the functional dependency between attributes of StudentID, StudentName and Course.
StudentID --> StudentName, Course
StudentName -->Course
StudentName, Course -->StudentID
Course <--StudentID, StudentName
Based on the relational schema in Figure, select one of the following that would violate the 2NF property.
Register_No, Name
Course_No, Course_Name
Register_No, Phone
Phone, Branch
Determine the SQL statement that were used to create table in a database.
CREATE DATABASE TABLE
CREATE RELATION
CREATE TABLE
CREATE DATABASE RELATION
Determine the SQL statement that were used to drop table in a database.
DROP DATABASE TABLE
DROP RELATION
DROP TABLE
DROP DATABASE RELATION
Determine the result based on the SQL statement in Figure.
A listing of all customers in the customer table
A listing of the owner of the customer table
A listing of all owner and customer of customer table
A listing of the owner of the customer table as well as customers
Analyze the result based on SQL statement in Figure.
Changes the length of the Unit_Price field to 775
Changes the price of a unit called Product_T to 7
Changes the unit price of Product 7 to 775
Updates the Product_T table to have a unit price of 7
Identify the INCORRECT statement while using LIKE comparison operator.
WHERE CustomerName LIKE ‘ad%’;
WHERE CustomerName LIKE ‘%ad’;
WHERE CustomerName LIKE ‘_ad%’;
WHERE CustomerName LIKE = ‘ad%’;
Choose the SQL statement to display the entire record from the Table with the names of students sorted out in descending order.
SELECT * FROM Student ORDER BY NAME;
SELECT * ORDER BY NAME FROM Student;
SELECT * FROM Student ORDER BY NAME DESC;
SELECT * ORDER BY NAME DESC FROM Student;
Identify the output when SQL command in Figure is executed.
The highest salary for all employees
The highest salary in each department
The employees with the highest salaries
The employees with the highest salary for each department
