Sep 29, 2017 term paper 2

SUPPOSE YOU WANT TO DESIGN AND IMPLEMENT A DATABASE FOR A MEMBER-ONLY SUPERMARKETINVENTORY AND…

This paper concentrates on the primary theme of SUPPOSE YOU WANT TO DESIGN AND IMPLEMENT A DATABASE FOR A MEMBER-ONLY SUPERMARKETINVENTORY AND… in which you have to explain and evaluate its intricate aspects in detail. In addition to this, this paper has been reviewed and purchased by most of the students hence; it has been rated 4.8 points on the scale of 5 points. Besides, the price of this paper starts from £ 40. For more details and full access to the paper, please refer to the site.

Suppose you want to design and implement a database for a member-only supermarketinventory and check-out system (think Costco).The database should store basic information about the members: membership number(unique), customer name, gender, and phone number.The database should also have information on current store inventory. For each product,store the Universal Product Code (UPC), brand, product name, product description (e.g.12 16-oz bottles of Coke), category (e.g. Fruit, Vegetable, Meat, Beverage, etc.), priceper unit, and quantity in stock. For simplicity, assume that each product belongs to onlyone category.All transactions are recorded. A transaction (from one check-out) contains a (unique)transaction ID, the transaction date, products purchased in the transaction along with theirrespective quantities (quantities purchased, not quantities in stock), transaction total (in$), and the customer who made the transaction.Draw the ER diagram for the given database, identifying the following:(i) all the entity sets and their attributes;(ii) all the relationship sets;(iii) all the required key constraints and participation constraints;(iv) the primary key for each entity set (and weak entity set, if any).In some cases, you may have to make your own constraint assumptions. Clearly state,and justify your assumptions. Does your diagram capture all the given requirements? Ifnot, specify which requirement(s) is (are) not captured.


0% Plagiarism Guaranteed & Custom Written, Tailored to your instructions


International House, 12 Constance Street, London, United Kingdom,
E16 2DQ

UK Registered Company # 11483120


100% Pass Guarantee

Order Now

STILL NOT CONVINCED?

We've produced some samples of what you can expect from our Academic Writing Service - these are created by our writers to show you the kind of high-quality work you'll receive. Take a look for yourself!

View Our Samples

corona virus stop
FLAT 25% OFF ON EVERY ORDER.Use "FLAT25" as your promo code during checkout