Reference no: EM13946467
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 https://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.
Attachment:- IP_1.doc
|
Formulate an lp to help bullco maximize profits
: Fertilizer 2 must be at least 70% silicon and sells for $40/lb. Bullco can purchase up to 80 lbs. of nitrogen at $15/lb and up to 100 lbs. of silicon at $10/lb. Assuming that all fertilizer produced can be sold, formulate an LP to help Bullco maxi..
|
|
Environmental law that is relevant to your past
: Identify one environmental law that is relevant to your past, current, or future employer. Apply that law to a business situation created by that employer. How does (or did) that employer maintain compliance with that statute? Do you believe that..
|
|
Determine how you can achieve at minimum cost
: You want each 10 oz unit to have at least20 mg vitamin C and at most 75 g of sugar - Determine if and how you can achieve this atminimum cost. (Work in cents, not dollars.)
|
|
Determine how many part timeversus full time workers to hire
: Determine how many part timeversus full time workers to hire at the Memphis facility. There are two shifts, morning andafternoon
|
|
What is the purpose of 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 success..
|
|
Determine the heat transfer rate
: Water is used as the coolant, entering the heat sink at Tm,i 30°C and um 1.75 m/s, providing an average heat transfer coefficient of h 7590 W/m2 · K. Determine the heat transfer rate from the hot surface to the water.
|
|
Explain the concept of portfolio management
: Explain the concept of portfolio management. Explain the differences between these types of IS investments: strategic, key operational, high potential and support.
|
|
How are struts related
: The moment of inertia I2 for strut-2 is twice the moment of inertia I1 for strut-1. If P1 and P2 are the critical buckling loads for strut-1 and strut-2, respectively, how are P1 and P2 related?
|
|
What should the involvement be for senior management
: What should the involvement be for senior management in determining and executing information systems strategy in a large organization?
|