Describing the database design development life cycle

Assignment Help Database Management System
Reference no: EM13854037

Your first step is to select a database you will design and implement in this class. You will make weekly contributions to your overall Key Assignment. The database project idea should first be sent to your instructor for approval before this Phase 1 Individual Project is due. In this first week you will explore a structured design process when creating your database application. You will write a report describing the database design development life cycle and describe in details the steps needed to properly create the database you have selected for your Key Assignment. You will also provide an overall description of your database that you received approval from your instructor to do.

You also should take this opportunity to create the template for your entire Key Assignment project; create a Word document that you will add to for each remaining assignment. The document should follow this format:

Database design project document shell
Use Microsoft Word
Title page
Course number and name
Project name
Student name
Faculty name
Date
Table of contents
Use auto-generated TOC
Separate page
Maximum of three levels deep (one level deep is okay too)
Be sure to update the fields of the TOC so it is up-to-date before submitting your project.
Section headings (create each heading on a new page with TBD as content except for sections listed under new content below)

Project outline

Description of the database design life cycle
The entity relationship diagram
The logical model and normalization
The Microsoft Access database
The Microsoft Access database application

Each week, you will add to this document and submit for grading. As a preview, each section will contain the following:

Description of the database design life cycle (Week 1 IP)

A description of the selected database project
A description of the DBDSL - 7 steps
A discussion about the three steps in database design

Reference no: EM13854037

Questions Cloud

How many streetlights are socially optimal : Suppose Chen has demand Q = 40 – 2P for streetlights and Abby has the demand Q = 10 – (1/2)P for streetlights. The cost of building each streetlight is $19. How many streetlights are socially optimal? Compare this socially optimal quantity with the q..
What would be the future value of your investment : What would be the future value of your investment? Now assume that inflation is expected to be 3 percent per year over the same three-year period.
What types of data are retail stores currently collecting : Play Around Toys Inc. operates stores in different regions of the country. The senior management of Play Around Toys Inc. has decided to tailor the merchandise selection for each store based on its sales patterns. What types of data are other retail ..
What are audit and internal control issues? : What are audit and internal control issues?
Describing the database design development life cycle : You will write a report describing the database design development life cycle and describe in details the steps needed to properly create the database you have selected for your Key Assignment
Capitalism faces its challenge : Use “John Maynard Keynes – capitalism faces its challenge,” in Big Three in Economics by Skousen as your resource to answer the following questions: What was the economic context in which Keynes was writing? How did that affect his economic views?
What was the companys cash coverage ratio : The company's net income was $8,912 with a tax rate of 34%. The firm paid $3,987 in total expense with a depreciation of $4,873. What was the company's cash coverage ratio?
Take for sallie to repay the entire loan : A certain college graduate, Sallie Evans, has $24,000 in student - loan debt at the end of her college career. The interest rate on this debt is 0.75% per month. If monthly payments on this loan are $432.61, how many months will it take for Sallie to..
What is the source of the network effect : Since its founding in 331 B.C.E., the city of Alexandria has been a center of trade for the Mediterranean countries, as well as the Middle Eastern countries. Part of this is due to geography, but it is also due to the network effect. What is the sour..

Reviews

Write a Review

Database Management System Questions & Answers

  Design a case for other student to investigate

You need to design a CASE for other student to investigate. As an example; at the end of this week you should generate the following materials: A case description.

  Create relational schema of database in 3nf

A Relational schema of your database in 3NF, clearly indicating attributes, the data type of each attribute, primary and foreign keys, candidate keys, and which attributes are nullable, giving reasons. List any assumptions you need to make.

  1 create a function that returns the day of the week for a

1. create a function that returns the day of the week for a specified date.create or replace function

  Create an er diagram that meets the above requirements

In MySQL Workbench 5.2, create an ER diagram that meets the above requirements. Include both Entity Classes and attributes that are necessary, given the above requirements. Save your ER model as an .mwb file

  Design er schema to keep track of information of votes

Design an er schema for keeping track of information about votes taken in the U.S. House of Representatives during the current two year congressional session.

  How might the tables be related to one another

What tables would you create, and what would the table components be and How might the (independent) tables be related to one another?

  Explain what do business rules require to be effective

What are the advantages of having the DBMS between the end user's applications and the database. What are some reasons for studying file systems. IT 645 - Database Management Systems

  Speculate the data exchange and data management trends

Speculate the data exchange and data management trends that may take place in the next five to ten (5-10) years

  Explain the problems associated with data redundancy

Assignment 5: Logical Design, Part II, Explain the problems associated with data redundancy as it pertains to effectively using information for reporting and analysis.

  Write names-e-mail addresses for all customers from table

Show all the data in each of the four tables. Do not show foreign key columns. Write names and e-mail addresses for all customers who have had a stove repair that cost more than $50.

  Create a data flow diagram

Create a Data Flow Diagram (DFD) relating the tables of your database schema through the use of graphical tools in Microsoft Visio or an open source alternative such as Dia. Note: The graphically depicted solution is not included in the required page..

  What is file organization

What is file organization? what are file organization techniques.explain in detail? explain random file organization technique, multikey file organization technique?

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