design a database
Not what you're looking for?
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.
Purchase this Solution
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.
Education
- BCom, SGTB Khalsa College, University of Delhi
- MBA, Rochester Institute of Technology
Recent Feedback
- "Thank you. "
- "Thank you"
- "Thank you. I got 20/20 last week for my discussion you help me out with."
- "Thank you. Great Job. "
- "Thank you. Great Job. "
Purchase this Solution
Free BrainMass Quizzes
Word 2010: Table of Contents
Ever wondered where a Table of Contents in a Word document comes from? Maybe you need a refresher on the topic? This quiz will remind you of the keywords and options used when working with a T.O.C. in Word 2010.
Word 2010: Tables
Have you never worked with Tables in Word 2010? Maybe it has been a while since you have used a Table in Word and you need to brush up on your skills. Several keywords and popular options are discussed as you go through this quiz.
C++ Operators
This quiz tests a student's knowledge about C++ operators.
Inserting and deleting in a linked list
This quiz tests your understanding of how to insert and delete elements in a linked list. Understanding of the use of linked lists, and the related performance aspects, is an important fundamental skill of computer science data structures.
Basic Computer Terms
We use many basic terms like bit, pixel in our usual conversations about computers. Are we aware of what these mean? This little quiz is an attempt towards discovering that.