Question: As a database designer, you are asked you to design a database for an online shop. They give you the receipts of their daily transaction.

As a database designer, you are asked you to design a database for an online shop. They give you the receipts of their daily transaction. Please create normalization ( UNF, 1st NF, 2nd NF, 3rd NF) based on following invoice document:

As a database designer, you are asked you to design a database

Code Date : INV/20201029/XX/X/663151135 : 29 October 2020 Shipping To: James XYZ No. 16 No 1 100 gr Product Name 1 Produk A 2 Produk B 3 Produk C 4 Produk D 5 Produk E Qty Weight Price Subtotal 1235 gr Rp 44.000 Rp 44.000 Rp 67.000 Rp 67.000 1 375 gr Rp 59.000 Rp 59.000 Rp 26.000 Rp 26.000 Rp 65.000 Rp 65.000 Subtotal Price Rp 261.000 Shipment Fee Rp 10.000 Promotion Voucher Code- ARGHHSH Rp - 50.000 Total Rp 221.000 1 100 gr 150 gr

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 Databases Questions!

A company believes that its demand for the next six months is as follows: The output per worker per month is 40 units. The per worker hiring and lay off costs are $2000 and $3000, respectively. There...

I have problems understanding this case study for database. can someone help me solve this. Deliverables: 1. Create a list with the main business rules 2. Identify the main Entity types and their...

A creative engineer suggests structuring the TLB so that not all the bits of the presented address need match to result in a hit. Suggest how this might be achieved, and what might be the costs and...

There are two problems due this week (each worth 35 points) as follows. Problem 1.6 (page 20) In comprehensive paragraphs, answerrequirements a to e. You will have 5 paragraphs total of four to five...

PLEASE READ CAREFULLY THE CASE STUDY PROVIDED AND FEEL FREE TO ADD HERE YOUR COMMENTS FOR EXAMPLE LIKES DISLIKES WORDS OR PHRASES YOU DO NOT UNDERSTAND ANY COMMENTS THAT WILL IMPROVE THE DIALOGUE...

The Secret of Zara's Success: A Culture of Customer Co-creation Zara is one of the world's most successful fashion retail brands - if not the most successful one. With its dramatic introduction of...

GIVE me Initial ERD diagram for the database and then give the normalized form of UNF, 1 NF , 2 NF and 3 NF minimum of 6 tables must be developed after the normalization referring to the below Case...

CIS 620/B Project Plan For the Global Collaboration Enterprise Information System 1200 12th Avenue, Suite 1200 Seattle, Washington 98114 U.S.A. November 11, 2015 Draft Version 19.0 November 11, 2015...

Please create ERD Relational Schema (table structures) with well structured relations based on the database tables(chart) above. Sue ERD for Revenue Cycle & Expenditure Cycle Approves PURCHASING...

I've attached the assignment as a word file, thanks! JWCL165_c07_304-355.qxd 7/31/09 2:05 PM Page 304 7 Fraud, Internal Control, and Cash Chapter STUDY OBJECTIVES After studying this chapter, you...

Please answer Discuss the possible challenges Amazon could face in China going forward. What should it do in such a scenario? What are the future challenges? Use the BCG Matrix to evaluate Amazons...

Again with the Bertrand oligopoly of Question 6, consider a VER in which Foreign limits the F firm's exports to be no greater than they were under free trade. Use the Stackelberg leader...

Discuss rationales for why the workplace environments of today are changing. What are some new workplace trends? Discuss how you feel about these trends. Do you know someone who lost a job or went...

The doubling time of a bank account balance is 1 3 years. By what factor does it grow in 5 2 years ? In 7 8 years ?

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

4. If the situation merits the conflict, what would need to change to avoid the conflict?

3. What strategies might you use?

3. Is there opportunity to improve current circumstances? How so?