Question: Harriss Pet Store has requested you to design a database to store information on sales on animals and merchandises. The sales form is shown in

Harriss Pet Store has requested you to design a database to store information on sales on animals and merchandises. The sales form is shown in Figure below

1.1 Identify all entities and attributes for each entity from Sales Form. Provide your answer in the format below. A table has been provided for you in the answer box below to complete

(15 marks)

1.2 Use your answer in Question 1.1 above, draw a complete Entity Relationship Diagram to model the data in the Sales Form. Multiplicities and primary keys must be shown on your model.

You may save your diagram as a picture and upload it in the upload file section below.

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!

Kerosene at 25?C is flowing in the system shown in Fig. 11.21. The total length of 50 mm OD ? 1.5 mm wall hydraulic copper tubing is 30 m. The two 90? bends havea radius of 300 mm. Calculate the...

Harriss Pet Store has requested you to design a database to store information on sales on animals and merchandises. The sales form is shown in Figure below 1.1 Identify all entities and attributes...

A hard drive whole sale store requested you to design a database to store information on sales. The sales form is shown in the following figure: Please draw an ER diagram that captures the business...

please answer Question 2.1 and 2.2 PROJECT 2: INFORMATICS 2A QUESTION 1 (20) 1.1 Lock granularity specifies the level of lock use. List and explain the four levels of lock granularity. 1.2 Deadlock...

SEE problem 4.25 which is attached in pdf format. I need detailed and correct answer 148 PART TWO / Databases Purchasing agent Order goods Merchandise inventory Vendor Receive goods Receiving clerk...

Edit your submission in this word document, attaching the screenshots of the codes used for each question. Include narrative descriptions, outputs screenshot, or short answers when requested. Task 1...

A hard drive whole sale store requested you to design a database ( create an ERD ) to store information on sales. The sales form is shown in the following figure. Note that the answer is not unique....

Task 1 A hard drive whole sale store requested you to design a database (create an ERD) to store information on sales. The sales form is shown in the following figure. Note that the answer is not...

Task 1 A hard drive whole sale store requested you to design a database ( create an ERD ) to store information on sales. The sales form is shown in the following figure. Note that the answer is not...

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...

Chapter 10 Business Process and Information Systems Development \"Jeff, we clean the clubhouse restrooms twice a day . . . in the morning before 7 and again just before lunch. We've been doing that...

What do you understand by organizational learning and knowledge management?

Suppose you fit the regression model y = 0 + 1x1 + 2x2 + 3x1x2 + 4x21 + 5 x22 + to n = 30 data points and you wish to test H0: 3 = 4 = 5 = 0 a. State the alternative hypothesis Ha. b. Give the...

All rental - allocated expenses that are deductible are classified as deductions for AGI None of these are true. Expenses must be allocated between rental and personal use. Both "Expenses must be...

Download a copy of the most recent CAFR for a local governmental/not-for-profit entity of your choice and familiarize yourself with the contents. The entitys website is often a great source for this...