Give one example each to illustrate the following terms:

i$.$ Database, Database System, Database Management System

ii$.$ Relations, Attributes, Tuples, Constraints $($Entity$,$ Referential Integrity, Semantic

Integrity$)$

A database system uses an Apache web server, a WebLogic Application server, and an Oracle

database. Draw a $3-$tier architecture for this system. Use the Internet to identify the latest versions

of the above$-$mentioned software to use in your architecture diagram.

As the leader of the data design team, you have been asked to bring a work plan that identifies the

phases of data design and includes the following information for each phase:

description of the data design phase

the inputs of the phase

the outputs of the phase

Based on the above scenario, fill up the following table:

Suppose that each of the following Update operations is applied directly to the database

state shown in Figure $5\mathrm{.}6.$ Discuss all integrity constraints violated by each operation, if any, and

the different ways of enforcing these constraints.

a$.$ Insert $$ 'Robert', $\text{'}F\text{'},$ 'Scott', $\text{'}943775543\text{'},\text{'}1972-06-21\text{'},\text{'}2365$ Newcastle Rd$,$ Bellaire, TX$\text{'},$ M$,58000,$

$\text{'}888665555\text{'},1>$ into EMPLOYEE.

b$.$ Insert $$ 'ProductA', $4,$ 'Bellaire', $2>$ into PROJECT.

c$.$ Insert $$ 'Production', $4,\text{'}943775543\text{'},\text{'}2007-10-01\text{'}>$ into DEPARTMENT.

d$.$ Delete the WORKS$\_$ON tuples with Essn $=\text{'}333445555\text{'}.$

e$.$ Delete the EMPLOYEE tuple with $Ssn=\text{'}987654321\text{'}.$

f$.$ Modify the $Mgrssn$ and $Mgr$ start date of the DEPARTMENT tuple with Dnumber $=5$ to $\text{'}123456789\text{'}$

and $\text{'}2007-10-01\text{'},$ respectively.

g$.$ Modify the Super ssn attribute of the EMPLOYEE tuple with $Ss{n}_{sn}=\text{'}999887777\text{'}$ to $\text{'}943775543\text{'}.$