CREAT A DATABASE THAT HAS AT LEAST 10 TABLES. BUT DON'T USE SHOES, USE SOMETHING LIKE CARS
Fantastic news! We've Found the answer you've been seeking!
Question:
THE BELOW REQUIREMENT IS JUST AN EXAMPLE, PLEASE DON'T CREATE A TABLE FOR SHOES. CREATE SOMETHING LIKE DEALERSHIP. SAME FORMAT BUT DIFFERENT TABLE NAMES
1. Managers can buy shoes from manufacturers; thus you need tables to store when, where, what and how many shoes were purchased at what price, using tables such as:
MANAGER, SHOE, MANUFACTURER, PURCHASE_RECORD
2. Managers can post shoes on the website; thus you need a table or tables to indicate when, what and how many shoes were listed for what price.
3. Users can register an account and purchase shoes; thus you need the following tables:USER, LOGIN_DETAIL, ORDER(summary of a transaction such as user, payment method, shipment method, shipping address, ...), ORDER_DETAILS (details of each transaction, as one transaction may contain different items at different quantity and prices).
4. Users can return shoes; thus you need tables to store return information.
5. Promotions are available from time to time; thus you need tables to store promotional information such as what type of promotions are available, when and for how long an item is available for what promotion.
6. Owner(s) and Administrator(s) can retrieve reports; thus you need at least the OWNER and ADMIN table. Data in reports are retrieved from existing tables, thus you don't need tables to
store reports.
In summary, for the above database, you will need at least 10 tables to start with, and gradually add supporting tables, e.g. if you store addresses, you will add a STATE or even a COUNTRY table. You should not only think about static data (data being entered once and is not updated often, such as users, managers, shoes, manufacturers), but also think about transactions that occur constantly, such as orders and returns.
Related Book For
Core Concepts Of Accounting Information Systems
ISBN: 9780470507025
11th Edition
Authors: Nancy A. Bagranoff, Mark G. Simkin, Carolyn Strand Norman
Posted Date: