Question

Instructions: ​You must draw the ER Model for SpaceX Bank, save the ER Model as a png or jpeg, put your name on it and submit it on Blackboard before the due date. ​You can use ​any software​ you like to create this model. No emailed homework will be accepted no exception, and No late homework will be accepted no exceptions.

Create the ER Model for ​SpaceX​ ​Bank

• ● Showalltheentities(regularentity,associativeentityorweakentity)with their attributes(key attribute, regular attribute or multi value attribute etc..)

• ● Showtherelationship(s)betweentheentities(remember​diamond shows the relationship and give the diamond a name​)

• ● Whataretherelationshipsbetweentheentities(Table,Object)havewith each other 1:1, 1:M or M:N

• ● Istheregenerationorspecializationwiththeseentitiesifsoitmustbe shown in the ER Model and label it.

• ● Istherearecursiverelationship?Ifsodrawtherecursiverelationship, label it and point to it.

  Senario:​ ​SpaceX Bank​ ​has hired you to design their database. Your first task is to draw the ER diagram with all the relevant information. The relevant information is as follows:

  ● A​branch​isuniquelyidentifiedbythebranchidentificationnumber.​A Branch also has an Name, Address, Office Number and Fax Number.

  ● Customers​canbeuniquelyidentifiedbyacustomerid.​Acustomerhasa name, address, email and phone number.

● Abranchhiresemployees.An​employee​canbeamanagerorstaff member of that branch.​ An ​employee​ can be uniquely identified by an employee id . A​ n employee has a name, salary, job title, email and phone number. An employee assists many customers and can open many accounts.

• ● Customerscanopentwotypesof​accounts​i.e.Checking,andMoney Market Savings.​ A customer can also open a credit card.

• ● Accounts​canbecategorized​basedontheirtype​Checking,Moneymarket savings, credit card account.​ Accounts can be uniquely identified by account number, ​it also has a balance, expiration date, card type, and a category.

• ● A​MoneyMarketSavings​​a​ ccounthasaninterestrate.

• ● A​Checking​accounthasanoverdraftfee.

• ● A​CreditCard​isuniquelyidentifiedbytheircardnumber,italsohasan interest rate, credit limit, current balance, annual fee, late fee, security code, expiration date and card type, and card status.

• ● Aemployeeisinchargeofopeningalltheaccounts,buttheyarenotin charge of opening credit cards.

• ● Acustomercanpaytheircreditcardwitheithercheckingaccountorcash payment. ​Credit card payment​ can be uniquely identified by a payment number. I​ t also has a card number, payment date, payment amount and payment type.

EER Diagram and MySQL Commands CIS 344 Homework #2
Due Wednesday 10/14/2020 by 11:59pm

Note: ​No emailed homework will be accepted no exception, and No late homework will be accepted no exceptions. You must submit it via blackboard only by the due date.

Part ​1 : ​You must create the EER Diagram for SpaceX Bank, save the EER Diagram as a png or jpeg, put your name on it and submit it on Blackboard before the due date. ​You can use ​any software​ you like to create this Diagram.

• ● Showtheentitieswithalltheirassociated​attributeswiththeirdatatypes and constraints. Symbolise primary keys, foriegn keys, unique keys to all attributes.

• ● Showtherelationship(s)betweentheentities.Usethecorrectcardinality rules

  Part​ 2: ​Create the ​SpaceX Bank​ MySQL database based on your EER Diagram. You must also:

  ➔ Comment all the statements you created ​and ​put your full name on every comment​.

  ➔ Screenshot all your code ​starting from where you created the database ​and ​(Including the errors you have created during the process if any) ​put it on a word document, upload it and submit it via Blackboard.

  Part 3: Insert the Excel spreadsheet data I provided you. You must also:

  ➔ Comment all the statements you created ​and ​put your full name on every comment​.

  ➔ ScreenShot all your code (Including the errors you have created) put it on a word document, upload it and submit it via Blackboard.

  Note: If you do not screenshot all your code and put comments on all statements you will not get credit for the assignment.

Answer 1