What kind of information will be included in the database

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

Reference no: EM13315354

Prepare a research topic on big data

Diagrams and tables must be numbered and labeled, and close to the first reference in the text - The paper should adhere to University writing standards pages in length, exclu

Assume the data warehousing system is centralized

Assume the data warehousing system is centralized, and implemented in the environment of Microsoft SQL Server 2012. As we discussed in the introduction, each store has its o

What are the key components of a data governance program

What are the key components of a data governance program? What are four reasons why data quality is important to an organization? Describe the key steps to improve data qualit

The focus is to write sql queries that combine data

This is the final installment of the project! The focus is to write SQL queries that combine data from both Mondial and GapMinder (GM). For most queries you will need both Mon

Design relational database using entity-relationship diagram

Design a Relational Database using Entity-Relationship Diagram (ER-D) and design a Relational Database by Mapping Entity-Relationship Diagram (ER-D) into Relational Models.

Describe technology options associated with an edms

Identify and describe the technology options and functionality associated with an EDMS. describe EHR functionality for ambulatory care facilities, considering the key clinic

Database triggers are utilized to record logins by users

Several times, database triggers are utilized to record logins by users. Here is the example of login trigger that inserts row into table every time a user connects.

What is a cross join and give an example of its syntax

What is a CROSS JOIN? Give an example of its syntax. What three join types are included in the OUTER JOIN classification? What is a correlated subquery? Give an example. What

Reviews

Write a Review

 
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