DataBases

-Pick a company or business from the following list-

Retail Business - Possible ideas: clothing, computer, plumbing, auto supply, furniture, shoes

Service Company - electrical, heating, air conditioning, lawn care, house remodeling

Restaurant

Theme park

General construction contractor

Modeling agency

EXAMPLE. Inventory-Music

Danny has a huge music collection and would like to keep track of the types of media, artists, genre, and storage location. He wants to be able to easily find music he wants to listen to without having to physically search through his dedicated music room.

Possible business rules might include:

--An artists music can be stored on many types of mediums.

--An artists music can be associated with many genres.

--A storage location can hold different artists music.

Possible tables might include: Artist, MusicMedium, Genre, Location

Possible primary keys might be: ArtistID, GenreID, LocationNum

Possible attributes might include: ArtistName, GenreType, MediumType, etc.

END OF EXAMPLE-

---------------------------------------------------------------------------------------------------------

Give an overview of the database, Select a function (sales, production, inventory, machine downtime, etc.) within that business or organization. Include appropriate business rules. Decide the appropriate number of tables to support that function. Name the tables. You can always add tables later. Select fields that you would include in each table to store characteristics of that entity (table). Be sure to select one primary key field (unique attribute) for each table.

Include:

a thorough description of the database including its function

business rules

tables

attributes (fields)

primary keys

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

What I have so far.

In computer business basically we are trying to sell computer products. So for that we have several tables to make our system more dynamic. The basic tables needed are, login table which contains the login details of the customer, user tables which contain the details of the customer who is registering into the system. According to the functions that we are providing, the number of tables and relationships between the tables are going to be defined.

The tables are named based on the data which is going to be stored into the table. For each table there will be a unique key called primary key to fetch the appropriate data from the tables. According to the forms and the flow of the system, we will provide the suitable field name and data type for each columns of tables.

This is a basic database structure given for the corresponding system. Here are the only basic activities to give an overview of our database.

Function: Computer Sales

In this function, the user is going to purchase a product through our system. So initially, the user wanted to view the item, which is there on the website, for that all the data is retrieved from the product table. If the user tries to buy a particular product, then that details will be stored in the sales table. We must fetch the user details form the user table to get the user information and stored along with other informations in the product tables. Finally, if the user is buying the item via online payment, the details must be stored in the payment tables.

Required tables:

Sales Table(To store the sales details like sales id, amount, purchaser and id)

Product Table (From this table we are fetching product details like specifications, quantity etc.)

User Table (From user table we are fetching the details of purchaser like name, phone etc.)

Payment Table (It store the payment details like amount, payment type etc.)

NEED THESE 3 THINGS

Business Rules?

Primary Keys?

Attributes?