OUESTION $3$

a$)$ What are the different types of database end users.

b$)$ Describe the difference between a database and a table?

c$)$ Discuss the roles of the following personnel in the database environment:

i$.$ Database Administrator

ii$.$ Logical database designer

iii. Application Developer

iv$.$ End$-$user

d$)$ Discuss the differences between the candidate keys and the primary key of a relation.

e$)$ Describe the differences in meaning between the terms relation and relation schema.

f$)$ Explain what is meant by a foreign key.

g$)$ Define the term referential integrity constraint and give an example of one.

h$)$ How does the referential integrity constraint contribute to database integrity?

i$)$ Name three $(3)$ relationships within a relational database.

QUESTION $4$

a$)$

i$.$ Identify and discuss each of the indicated dependencies.

ii$.$ Create a database whose tables are at least in $2NF,$ showing the dependency diagrams for each table.

iii. Create a database whose tables are at least in $3$NF$,$ showing the dependency diagrams for each table.

b$)$ Differentiate between the different types of SQL joins: $($INNER$)$ JOIN, LEFT $($OUTER$)$ JOIN, RIGHT $($OUTER$)$ JOIN, and FULL $($OUTER$)$ JOIN.

c$)$ Write an SQL statement to create a database called CompanyDB.

$3$

d$)$ Write an SQL statement to create a table called Employees that contains columns: EMPNO, ENAME, JOB, and SALARY.

e$)$ Write an SQL statement that will display all information stored on the above$-$created table Employees.

f$)$ Write an SQL statement to display the names of all employees that contains $\text{'}a\text{'}$ in their name.

g$)$ Write an SQL statement to add a column called HireDate in the table Employees.