Instructions:

$-$ Use any programs $($e$.$g$.$ either MS Powerpoint or MS Words is fine$)$ to build your diagram

$($a hand$-$written version will not be allowed$).$

$-$ You can use MS Powerpoint or MS Words for the Question #$2$

$-$ Use either UML or Crow$$ Feet notation $($do not use both methods at the same time$).(*$use Crow's feet notation$)$

$-$ for question $1$ Must identify entities, attributes, relationships $($both maximum and minimum cardinalities$)$

for all the entities in your diagram $($If a specific requirement is not given, make your own

assumptions for identifying primary keys. State your assumptions using one or two sentences,

if needed$).$

Question #$1$:

A fast$-$growing retail company EMart recently realized that they can no longer rely on a

traditional file system that has been used since the establishment of the company. They

approached and asked you to build a database consistent to the company$$s day$-$to$-$day

operations. You have talked to multiple employees from different departments and come up

with the following business rules.

First of all, EMart wants to keep good track of their employees. When an employee gets hired

from the company, s$/$he is given with an employee number which will be used for an

identification purpose. In addition, email, phone number, address, emergency contact, gender,

and date of birth will be recorded for each employee. Note that company requires their

employees to provide at least one or more emergency contacts as possible. The main job for

the employees in EMart is to manage their important customers such as business customers.

While the employees can manage multiple customers at the same time, each customer is

assigned to a particular employee and that customer needs to interact with the assigned

employee.

Second, EMart has a scholarship program, as a part of company welfare, for the children of

their employees. To do so$,$ they store information on each employee$$s children. Since the

scholarship is provided only to those between age from $9$ to $17,$ the company wants to keep

good track of the children$$s age. Therefore, if an employee needs to get a scholarship for his$/$her

a child $($or children$),$ s$/$he has to provide the birth certificate number to the company. Based on

the number, the company will calculate one$$s age and store it in the database. In addition, the

company requires employees to enter bank account numbers so that the scholarship can be

automatically transferred to those who qualify. Lastly, the company requires employees to

submit one bank account, which needs to be stored together with the information about their

children.

Third, customer information is essential to the company. The information that EMart needs to

keep track of includes customer name, address, phone number, email, gender, and date of birth.

A customer can purchase multiple products by placing an order, but an order can be placed by

only one customer. For each order, the company stores information such as order number, date,

and total price. Similarly, products can be purchased by different customers through the order

that the customers have placed. Each product has its own product number and category. Other information for products, such as the country of origin and description, is also stored. To make things simple, binary relationships are considered only.

Question #$2$:

After you have solved question #$1,$ you will come up with your ER model.

Convert your ER model into a logical model using the relational schema. $($not as a code$)$