I describe the application that you would like to design

Assignment Help Database Management System
Reference no: EM13346797

I. Describe the application that you would like to design. This should include the purpose of the application and an informal description of the application functionality. List and describe in detail the data elements that must be captured in this application and stored in the database. The application may meet all of the data needs of a business or may be specific to a single need within that business.

II. Add "use cases" for your database. In this case, all you need is several questions that you would use your database application to answer. These should be Select queries and not database updates or other database manipulation statements.

III. Draw one or more Entity-Relationship diagrams for database.

IV. Prepare the relational schema for your database based on your E-R diagram. Then revise this schema to be normalized or, if you choose not to, Describe why denormalized tables are preferable. Implement this in your Oracle or MS SQL Server database and populate the database with test data. Project contains:

a. the ERD

b. the relational schema (not CREATE TABLE statements)

c. a description of the normalization of these tables

d. the data definition statements that you used to create the tables;

e. a sample of the statements for inserting data into the tables (two or three for each table will do);

V. Write the SQL queries that support at least three of your use cases. Perform a screen capture showing the results when you run these queries against your database. Please edit the screen capture to delete all unnecessary text so that this will be legible to your readers. Finally, add a conclusion that briefly sums up the project and any ideas you have for implementing it.

Reference no: EM13346797

Questions Cloud

Question 1 a for the reciprocal lattice we know : question 1 a for the reciprocal lattice we know thatexpjg.r 1where g.r 2pit t an integernbsp r lambnc
Negative growth stockswinton mining has seen its business : negative growth stockswinton mining has seen its business slowly wind down. it recently paid a dividend of 1.80 per
Discussion htmlcssjavascript placementnbspplease respond to : discussion htmlcssjavascript placementnbspplease respond to the followingcompare and contrast the process of adding
Find a statistics study on unemployment and explain the : find a statistics study on unemployment and explain the five-step process of the study.identify the four
I describe the application that you would like to design : i. describe the application that you would like to design. this should include the purpose of the application and an
Case study 1 berts bonsai bbberts bonsai is a small company : case study 1 berts bonsai bbberts bonsai is a small company started by a retired plant scientist which sells bonsai
Define nosocomial infections explain the factors that might : define nosocomial infections. explain the factors that might influence whether a patient can acquire nosocomial
The so2 concentration in a stack is 400 ppm the stack : the so2 concentration in a stack is 400 ppm the stack diameter is 10 ft and the stack gas velocity is 50 ftsec. the gas
A company makes use of a computerised flat file information : a company makes use of a computerised flat file information retrieval and storage system. the company is experiencing

Reviews

Write a Review

Database Management System Questions & Answers

  Knowledge and data warehousing

Design a dimensional model for analysing Purchases for Adventure Works Cycles and implement it as cubes using SQL Server Analysis Services. The AdventureWorks OLTP sample database is the data source for you BI analysis.

  Design a database schema

Design a Database schema

  Entity-relationship diagram

Create an entity-relationship diagram and design accompanying table layout using sound relational modeling practices and concepts.

  Implement a database of courses and students for a school

Implement a database of courses and students for a school.

  Prepare the e-r diagram for the movie database

Energy in the home, personal energy use and home energy efficiency and Efficient use of ‘waste' heat and renewable heat sources

  Design relation schemas for the entire database

Design relation schemas for the entire database.

  Prepare the relational schema for database

Prepare the relational schema for database

  Data modeling and normalization

Data Modeling and Normalization

  Use cases perform a requirements analysis for the case study

Use Cases Perform a requirements analysis for the Case Study

  Knowledge and data warehousing

Knowledge and Data Warehousing

  Stack and queue data structure

Identify and explain the differences between a stack and a queue data structure

  Practice on topic of normalization

Practice on topic of Normalization

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