Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

have problem with solving this assignment using ERDplus and the deadline is after 2days lm not sure about my answer i think its incomplete please

have problem with solving this assignment using ERDplus and the deadline is after 2days lm not sure about my answer i think its incomplete please solve this with ERDplus
image text in transcribed
image text in transcribed
image text in transcribed
0 4 16-410-51 9104111440 FAQ HAJER HADI DOCUMENTS LOGOUT MENU a SAVE UNDO REDO DELETE SELECT CONNECT ENTITY ATTRIBUTE RELATIONSHIP first name last name phone unit number unit no custmer ID (name) (address Customer You are hired to design a database for a startup company. The company wants to develop a gift store system. The information stored in the database will be used for future analytical and operational purposes. The database will store customer's information which include customer name (first and last name), address (city, street, unit_no), email, and it allows customers to store more than one phone number. A customer can buy one or more gifts. A gift has (id, name, description, price) each gift must belong to only one customer. The gift can be chocolate or flower or both (there is no other option). Data like production and expiration date will be stored for the chocolate, on the other hand, type and quantity for flowers. A gift may or may not have a card, which has three attributes from, to and a message. A card must belong to at most one gift. The card information is associated with the gift and it will only be stored if the customer purchased a gift. Once the customer purchased the gift, the system will issue a receipt that has an order_id and total price along with the information about the customer and the gift. This bit of information should be stored in the database to confirm the order. Given the above description: 1. Draw an ERD for the database, identifying the following: 2. All the entities, attributes and relationships b. Primary key and (discriminator in weak entity, if any). Don't forget each entity has to have PK. o. Participation and cardinality constraints. (Explain your choices for two constraints- i.e. identify the words the guided your decision) d. Specialization and completeness constraints (if there is an ISA relationship). 2. Write a database schema for any entity and a relationship of your choice. * A suggested tool to draw the ERD: https://erdplus.com/ C e rdplus.com/edit-diagram/16231480-4316-41dc-8e51-91043836440a A FAQ HAJER HADI DOCUMENTS LOGOUT = MENU Save UNDO REDO DELETE SELECT CONNECT ENTITY ATTRIBUTE RELATIONSHIP unt number umer ID (name (address) hy Card ID New Label card

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions