Create a database, Database Management System

Assignment Help:

The database will enable college administrators the ability to track students initial major. This will help college officials decide how best to prepare students for their goals and to follow students into their careers. If there are majors where graduation rates are low it can help administrators decide how to better serve students, make changes to the curriculum or change standards of acceptance into the program.

Diagram Tool:
ER Assistant
Database:
Oracle 10g, using Nova.
Hardware and Software:
UMUC server system (Nova). Operating system is UNIX.

DDL and DML:

SQL (Structured Query Language) will be used for the DDL and DML. For my DDL scripts, I will use SQL to translate the information captured in my ER diagram (created in ER Assistant) into database table creation scripts. For my DML scripts, I will use SQL to insert rows of data into my database tables.


Related Discussions:- Create a database

OLD HOME POLICIES, Write an sql statement to find what is the percentage of...

Write an sql statement to find what is the percentage of home policies which are from the state of Arizona out of all Home policies by Policy Value.

I need automated trading engine for crypto currencies, Project Description:...

Project Description: Looking to prepare automated trading engine for alternate cyprto currencies starting with Cryptsy, finally integrating into other exchanges. Need to work wi

Write a short note on participation role, write a short note on participati...

write a short note on participation role? Participation role: roles are indicating in E-R diagram by labelling the lines that connect diamonds to rectangles.

Many-to-many relationship, Many-to-many : Entities in A and B are related w...

Many-to-many : Entities in A and B are related with any number of entities from each other. Example: Taught_by Relationship among course and faculty. One faculty member ca

Er diagram, Draw an ER diagram for company''s database schema

Draw an ER diagram for company''s database schema

What are advantages of object-oriented programming paradigm, What is the ma...

What is the major advantage of object-oriented programming paradigm? The ability to modify the explanation of an object without affecting the rest of the system is the main adv

What type of view of total database content, What type of view of total dat...

What type of view of total database content? Data base content Conceptual view of total database contain.

Database errors, Database Errors: An error is said to have occurred if the ...

Database Errors: An error is said to have occurred if the implementation of a command to manipulate the database cannot be successfully finished either due to inconsistent data or

Write Your Message!

Captcha
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