Database planner should spend a considerable amount of time

Assignment Help Database Management System
Reference no: EM13186066

One of the needs that your client has is a 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 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.

Reference no: EM13186066

Questions Cloud

What is lens income tax : Len Mast earned $2,200 for the last two weeks. He is married, is paid biweekly, and claims 3 exemption. What is Len's income tax? Use the percentage method.
Compute the percent abundance and atomic mass : isotope has a natural abundance of 57.21% and an atomic mass of 120.90382 amu. Calculate the percent abundance and atomic mass of the 123^Sb isoyope
Can an efficient level of shale gas production be achieved : If instead local ordinances granted the households the right to be free from the pollution, could an efficient outcome be achieved by voluntary exchanges between the households and the O&Gs Would the households be better off or worse off than if t..
Derive the normal equation for fitting trigonometric curuve : derive the normal equation for fitting the trigonometric curve, p(x) = ao + a1 cos(x) +b1 sin(x)
Database planner should spend a considerable amount of time : 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 ..
State a reaction mixture containing o-acetyl serine : A reaction mixture containing 20 mM O-acetyl serine, 50 mM NaCl, 50 mM HEPES buffer (pH 7.6), and O-acetyl serine acetylase is incubated in 37C until O-acetyl serine is completely hydrolyzed. What is the pH of the mixture at the end of the reactio..
In which class are the grades most dispersed : the mean is 70 and the standard deviation is 5.in the third class, the mean is 72 and the standard deviation is 4. in which class are the grades most dispersed.
Explain what is the ph of the resulting phosphate buffer : How much 1.0 M NaOH must be added to a 100 ml of 10 mM H3PO4 to raise the pH of the solution to 7.0? B) If 2 volumes of 2.0 M Na2HPO4 are added to 1 volume of 0.1 M H3PO4, what is the pH of the resulting phosphate buffer?
A persuasive outline for an upcoming speech : Make a proposal to your local Chamber of Commerce to change the business zoning laws in your community. Make a proposal to your company’s social responsibility committee in your organization that it begin a company recycling program or become an acti..

Reviews

Write a Review

 

Database Management System Questions & Answers

  Design updateable database for storing customer and sales

Design an updateable database for storing customer and sales data. Explain how to deal with the problems of missing data.

  Design a set of 3nf tables for database scenario

Draw an ER diagram for your database scenario. Design a set of 3NF tables for your database scenario.

  Baxter aviation database

ER diagram for the Baxter Aviation database

  Advantages and disadvantages of working with multiple tables

Write down the advantages and disadvantages of working with multiple tables? Write an example of situation where multiple tables would be suitable in the application.

  Transform the tables into one or more tables in bcnf

Transform the tables into one or more tables in BCNF. State the primary keys, candidate keys, and referential integrity constraints.

  Describe implement relationship between employees-projects

Describe how you would implement relationship between employees and projects in each of the given scenarios: Many employees can work on given project, but each employee can work on only single project.

  Create entity-relationship diagram for bookstore database

Create Entity-Relationship diagram for a bookstore database, that maintains information about books, professional journals, their authors, and publishers.

  How protocol ensures serializability and deadlock freedom

To lock any other vertex, the transaction must have visited all the parents of that vertex and must be having a lock on one of the parents of the vertex. Show that the protocol ensures serializability and deadlock freedom.

  Explain the concept of physical data independence

Explain the concept of physical data independence and its importance in database systems,  List four significant differences between a file-processing system and a DBMS.

  Determine the names of all tracks from table

All primary keys are underlined. All foreign keys have same name as primary key that they are referencing. Determine the names of all Tracks which are more than 10 minutes (600,000 ms) long.

  Write an essay on marketing management

The customer is always right -The customer doesn't know what's best. It's the baker's (marketer's) job to educate him. The above statements succinctly point out a subtle battle which rages within the marketing discipline.

  Gathering information using cross indexed

Using data mining, it is possible to gather information which has been buried that can be manipulated and cross indexed which could be a valuable information gathering technique for entities.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd