What is the purpose of database

Assignment Help Database Management System
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

Reference no: EM13946467

Questions Cloud

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?

Reviews

Write a Review

 

Database Management System Questions & Answers

  Convert an erd to a relational schemacovert the extended

convert an erd to a relational schemacovert the extended entity relationship diagram eerd for orthopedic alliance of

  Write sql queries to solve the given specifications

Write SQL queries to solve the following specifications. Include the query AND THE OUTPUT. A screen dump of the output is acceptable. Show as many rows as you can.

  List the sales for each customer

Each query is worth 2 marks. These tables exist in sphinx and are owned by the user dtoohey. You may, if you wish, create your own copies of the tables under your own account. If you do so, you should ensure that you copy the sample data in dtoohe..

  Develop preliminary database tables for huffman trucking log

Use Microsoft Access to develop preliminary (no keys and no relationships) database tables for Huffman Trucking Driver Log.

  Design of a data warehouse

Enterprises are accumulating substantial amounts of data that are necessary for their business operations.

  First - second or third normal form

How many entities are shown by this relation?

  Write a join query that for every order placed on september

Write a join query that for every order placed on September 5, 1998, (use '05-SEP-1998') will list the order number and order date along with the customer number, last name, and first name of the customer who placed the order

  Find that the data structure holds redundant data

Imagine that you have been hired to fulfill their need of enhancing the data repository for their current reservation processing system. Upon reviewing the system, you find that the data structure holds redundant data and that this structure lacks..

  Create the tables create the primary keys add dml statements

Create the tables Create the primary keys Create the foreign keys Add DML statements to: Add data of 1 customer who buys from the company Provide the DML to add 1 employee who interacts with customers Give DML to change data of the employee

  Define the term use case

Explain the difference between the > and > relationships in use case diagrams?

  Conceptual database scheme for the csrss

Develop an E/R diagram to represent the conceptual database scheme for the CSRSS and list the information of all doctors who are specialized is heart surgery.

  Provide a logical and physical design

Design and develop a database using professional principles and standards. Provide a logical and physical design of the database.

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