Reference no: EM13315354
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.
Start by researching the following: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.Complete an initial analysis of how you would like to structure the data.Decide what you would like to include in the database.You may use the following steps as a guide (Microsoft, 2010):
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 to establish relationships between the tables, create primary keys using autoshapes in Word.Refine your database design to eliminate errors and create sample tables.
Provide what reports may be produced as a result of your database design.Based on the information you have researched, create a 2-3 page design document that includes a description of the database you would like to create as well as sample tables that would be part of that database. Make sure to include references in your report of any sites on database design that you use.
|
What is the tension in the string at given point
: A 1-m long pendulum with a mass of 5 kg moves at a velocity of 3 m/s at the bottom of its swing. What is the tension in the string at this point
|
|
Find distance downstream to location of hydraulic jump
: Water enters a very wide rectangular channel (Manning's n = 0.0149) at a velocity of 12.2 ms-1 and a depth of 0.61 m. An H3 curve forms downstream and the water jumps to a depth of 2.4 m some distance downstream.
|
|
Find the mass of the ruler
: A light meter stick is balanced at the 60 cm mark with a 200-g mass is hung from the 90 cm mark and a 100-g mass is hung from the 10 cm mark, Find the mass (in g) of the ruler
|
|
Calculate critical depth and critical slope in an earth-line
: A flow of 28 m3s-1 occurs in an earth-lined canal having a base width of 3 m, side slopes of 1(vertical) to 2 (horizontal) and the Manning's n value of 0.022. Calculate the critical depth and critical slope.
|
|
What kind of information will be included in the database
: 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 datab
|
|
Find the change in your weight
: In 1956, Frank Lloyd Wright proposed the construction of a mile-high building in Chicago. find the change in your weight if you were to ride an elevator from the street level, where you weigh 810 N, to the top of the building
|
|
How many turns should the coil have
: A simple dc-motor is made up of a single coil rotor placed between two permanent magnets. How many turns should the coil have so that the motor can supply a torque of 0.100 N-m
|
|
What is computer security
: Computer security is integral part of any organization, if any organization hasstarted working in, immediately it should start Computer security for its systemif they want to protect their system for future.
|
|
How much time does it take the electron to reach wire mesh
: In a CRT tube, electrons are accelerated by a 20,000 V potential difference between the electron gun (the cathode) and the positive metal mesh 5.00 cm away. How much time does it take the electron to reach the wire mesh
|