Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please anwer the following: Week 3 (Jan 22-Jan 26 / 9 Assign3.pdf heiligensee-general ISE Secure https://myasucourses asu.edu/bbcswebdav/pid-1 7662876-dt-content-rid-1 19357301 1/courses/2018SpringAX-SER322-20993/ ssign3.pdf : Apps FSAID ASURITESign

Please anwer the following:

image text in transcribed

Week 3 (Jan 22-Jan 26 / 9 Assign3.pdf heiligensee-general ISE Secure https://myasucourses asu.edu/bbcswebdav/pid-1 7662876-dt-content-rid-1 19357301 1/courses/2018SpringAX-SER322-20993/ ssign3.pdf : Apps FSAID ASURITESign in Java Platform Standa - Exercise 3 of Lesson Rent BuyTextbooks G Google , How to determine a -Java Game Program Account Summary 1. les areas, and A company needs to maintain information about sales rep products. Each representative is responsible for sales in only one area. Each area has one or more responsible representatives. Each representative is responsible for sales of one or more products and each product has one or more responsible representatives. Every product is sold in every area. After a new product is added to the inventory, the sales reps are trained to sell the product. Specify an entity-relationship diagram for this database. Don't forget to underline key attributes and include cardinality ratio and participation constraints for the relationships. Specify any assumptions you make. You can limit yourself to7 attributes per entity resentatives, sa (20 Points) 2. Suppose you have been asked to design a database for a smal, independent store that rents Videogames. Your database should deal with data associated with Videogames, customers, rentals, etc. Think about the essential data needs of the store, and then construct an E-R diagram (containing at least 5 entity sets) based on your thoughts. Do NOT include attributes in your diagram. Instead, list them in the format shown for the (library) case study discussed in class (and shown on the slides). For each entity mark the attributes that make up its primary key and alternate keys using the notation used in ER Modeling Include a few comments to explain your design decisions. Note that there is no single right answer to this question, although some answers may be better than others. (30 Points) @il 3-Ul-logic.pdf Z-Formalization N .pdf ^ ser315 usercenter pdf ^ ^ z-notation spec.pdf Show all | ^ Formalspecificatio. .pdf ^

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

Recommended Textbook for

More Books

Students also viewed these Databases questions