Question: 6. Assume that you are working as a DB developer for a new apparel company that will run an online business (your company does not

6. Assume that you are working as a DB developer

6. Assume that you are working as a DB developer for a new apparel company that will run an online business (your company does not have an offline store). Staff members in the sales department ask you to develop two databases first - Transactions and Customers. Customer information (e.g., customer number, name, email, gender, registration date, etc.) will be added to the Customers DB and transaction information (e.g., transaction number, product SKU, quantity, price, order date, shipping fee, returned or not, etc.) will be inserted to the Transactions DB. Design the two DBs using ER data modeling. (5 points) Tips You do not have to draw a diagram (if you want, you can draw it). Rather, explain each entity and attributes such that: Customers (CustomerNo, Name, Email, Gender, RegistrationDate) Transactions (TransactionNo, ProductSKU, Quantity, Price, OrderDate, ShipFee, Returned) You can create more tables. Please, describe candidate key(s), primary key, foreign key (if any), and structural constraints (in terms of multiplicity) as well. An example of answer format: Q1. (just note the question number) Al. your answer Q2. A2. your answer Q3. A3. your

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!