Share
Explore BrainMass

design a database

Details: Using the same organization you selected in the unit one individual project complete the following.

One of the needs of your client is a database.

In order to design a database, a database planner should spend a considerable amount of time thinking about what kind of information will be included in the database, and how it will be organized. There are several approaches to creating a successful database.

Search the internet to find information about designing a simple database for your client. Using the information you find, choose a simple example that would be relevant to your client's needs, and complete an initial analysis of how you would like to structure the data and what you would like to include in the database.

In completing your database design, you may use the following steps as a guide. These steps are outlined in the "Understanding Relational Database Design" document which can be found on http://support.microsoft.com. (Note: You will have to perform a search on this site using the search tools provided to locate the information regarding Understanding Relational Database Design.)

What is the purpose of your database?
How many tables will your database need? (Keeping it simple works here-2-3 tables is fine). Once you have a clear purpose for your database, you can divide your information into separate subjects. Each subject will be a table in your database.
Decide what information you want to keep in each table. Each category of information in a table is called a field and is displayed as a column in the table.
Look at each table and decide how the data in one table is related to the data in other tables. Add fields to tables, and in order to establish relationships between the tables create primary keys using autoshapes in Word.
Refine your database design to eliminate errors, and creating sample tables.
Provide what reports may be produced as a result of your database design.
Your assignment is to create a design document. This should include a Word document, with a description of the database you would like to create, as well as sample tables that would be part of that database.

Attachments

Solution Summary

One of the needs of your client is a database.

In order to design a database, a database planner should spend a considerable amount of time thinking about what kind of information will be included in the database, and how it will be organized. There are several approaches to creating a successful database.

$2.19