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

  Implement a database based on the provided er diagram

Analyse and comprehend a provided ER diagram and Database Schema and implement a database based on the provided ER diagram and Database Schema

  Database and programming design

Database and Programming Design

  Find name and membership number of members

Find the name and membership number of members who have borrowed more than five different books of that publisher.

  Assignment on database managment

The problems use the customer, orderTbl, and Employee tables of the simplified Order Entry database. Chapters 4 and 10 extend the database to increase its usefulness.

  What makes up a database system

When would you use a relational database model?

  The basic mechanisms for accessing relational database

Describe the basic mechanisms for accessing relational databases from various types of application development environments.

  Write the application for university admissions office

Write the application for university admissions office. Prompt user for a student's High School Grade Point and an admission test score.

  Populate vehicles and customers table with at least ten rows

You can create your database on Nova or any other Oracle system you wish, but you must use the Oracle RDBMS. Populate the VEHICLES and CUSTOMERS tables with at least ten rows each. Populate your SALES table with at lease ten rows.

  Describe the process of normalization and why it is needed

Describe the process of normalization and why it is needed. Contrast and compare logical and physical database design. Critique SQL as a user-friendly query language.

  Ray henry is considering expanding the inventory at his

ray henry is considering expanding the inventory at his book stores to include movies. he has some special ideas for

  Describe the ongoing maintenance that will be required

Be typed, double-spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.

  Number of leaf-level blocks needed if blocks are full

What is the order P of the B+-tree if B+-tree access structure on the key is constructed? What is the number of leaf-level blocks needed if blocks are approximately 69% full (round up for convenience)?

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