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

  Explain the benefits and current trends of data warehousing

Create a diagram using Visio, Microsoft Paint, or other graphical creation utility of your choosing to illustrate the conceptual data feeds into and out of the data warehouse. Note: The graphically depicted solution is not included in the required..

  Describe database backup

This paper will be 5 pages total: (a) Describe Database Backup. (b) Describe Disaster Planning. (c) Highlight the importance of the integration of both backups and disaster planning and the impact if both are not effectively executed.

  Compute unit product costs for external reports

Compute unit product costs for external reports. Data relating to the company's three activity cost pools are given below for the current year

  Diagram and determine the possible iterative steps

Determine the steps in the development of an effective Entity Relationship Model (ERM) Diagram and determine the possible iterative steps / factors that one must consider in this process with consideration of the HR core functions and responsibili..

  Provide a dynamic view of your supply chain

In your role as the database administrator for X-Tex, a small but successful company that designs and manufactures high tech fabrics, you have been asked to help optimize a query that will provide a dynamic view of your supply chain

  Assume that the database system in your organization has

write a 200- to 300-word short-answer response for the followingsuppose that the database system within your

  Database and data warehousing design

Database and Data Warehousing Design

  After a lengthy description he further challenged you to

you are the new chief information officer for acme widgets. the president of the company recently asked you what you

  Write the sql command to insert a record into the table

Write the SQL command to create the table that you described above. Write the SQL command to insert a record into the table. Write the SQL command to delete a record from the table.

  Member information in the member register

To maintain member records, the library has hired an executive who maintains member information in the Member register. The details stored in this register consist of MemberID, MemberName, Gender, Address, and the amount paid by each member.

  Fundamentals of data transmission

Radio and Microwave transmission, Satellite Communication. Introduction to Data communication: Fundamentals of data transmission, Channel speed and bit rates, Bandwidth, digital and analog signals, Asynchronous and Synchronous Transmission, Modula..

  Convert table to first normal form

Convert this table to First Normal Form

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