Design and implement relational databases for a set of data

Assignment Help Database Management System
Reference no: EM131161850

Create database applications that interface the internet.

Design, develop, and implement relational databases for a set of data.

Apply the fundamentals of the underlying programming language to create database scripts.

Create database applications that utilize an event-driven environment.

Structure a database using object-oriented concepts of classes, properties, and methods.

Implement techniques for debugging and error handling in the creation of database scripts.

Create database applications that interface the internet.

Final Project outline and requirements

The final project should be worked on and completed each week throughout the course.

Overview: Plan and create a relational database and Web GUI used to input data in to the database from the Web.

The database will contain at least 4 tables each consisting of at least 4 columns and 16 rows of data. All data should be filled in and can be real or fictitious.

The web page should allow users to enter information manually (free-form text fields) and contain pre-defined fields such as drop down or calendar (date/time) boxes and buttons.

Here is just one idea for this project:

IT Help-desk System

* Support Calls
* Support Categories
* Resolutions
* Machines
* Software
* Help-desk Staff

Submit all documents, queries and database file to the appropriate drop box. Please place the queries in to the proposal documentation and submit. Submit the database as a second upload. You will have 2 submissions uploaded for this project in Week 7. Compress submissions and submit.

Submission 1 to include:

Proposal document
Copy of queries, stored procedures and views
Draft of web page and functionality
Submission 2 to include:
Copy of database to be reviewed in Oracle Express.

The Final Project is worth 200 Points.

Submit Final Draft of Planning and Implementation document (Submission 1)

Then submit compressed database file (Submission 2)

Reference no: EM131161850

Questions Cloud

Describe a recovery that would not be feasible to test : Describe a recovery that would not be feasible to test with a real-world test. Include the reason(s) that the real-world test could not be done. Elaborate on the steps and processes you would have to do to try to insure that your recovery plan wou..
Paper in which you discuss the causes of psychopathology : Prepare a 1,050- to 1,400-word paper in which you discuss the causes of psychopathology. Provide a brief overview of how culture is a factor in determining the expression of psychopathology. Discuss at least one culture-bound psychological syndrome
Find the nearest total time of flight of the rock : A rock is thrown vertically upwards with a velocity of 30 m.s-1 from the top of a 25 m high building. When it falls back down it just misses the building and falls to the ground. The acceleration due to gravity is 9.8 m.s-2. Find the nearest total..
We got the opposite peak of graf : We got the opposite peak of graf. Can you explain why the second peak is higher than first peak?
Design and implement relational databases for a set of data : Design, develop, and implement relational databases for a set of data. Apply the fundamentals of the underlying programming language to create database scripts. Create database applications that utilize an event-driven environment.
Bonds for financing or investment purposes : Do you support their choice to use bonds for financing or investment purposes? Why or why not - What benefits and risks do bonds present versus other forms of financing?
How many drivers cross the bridge : If the city wishes to raise as much revenue as possible from the tolls, where will the city decide to charge a toll: in the inelastic portion of the demand curve, the elastic portion of the demand curve, or the unit elastic portion? Explain.
Uniform external magnetic field : A wire of length 0.53m, carrying a current of 6.2A is placed in a uniform external magnetic field. When the wire is horizontal it experiences no magnetic force. When the wire is tilted upward at an angle of 15 degrees it experiences a magnetic for..
How do social rules regulate behavior : How do social rules regulate behavior? What is likely to happen when a person violates the social rules of their culture

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