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

Oracle, comparison of oracle RDBMS with MySQL

comparison of oracle RDBMS with MySQL

What are the storage types, What are the storage types? The storage typ...

What are the storage types? The storage types are: a) Volatile storage b) Nonvolatile storage

Query processor in database management system, Query Processor The qu...

Query Processor The query language processor is responsible for taking query language statements or shifting them from the English-like syntax of the query language to a form

Managing database, 10A.53 Code an Oracle Database trigger to enforce the ...

10A.53 Code an Oracle Database trigger to enforce the constraint that an employee can never change his or her department. 10A.54 Code an Oracle Database trigger to allow the

Log, what is the need of a log in dbms

what is the need of a log in dbms

Post vbulletin hack and new server problem, Project Description: My VBul...

Project Description: My VBulletin forum was hacked, and soon after my server machine died. So, I'm now on a new machine, and I think that I've taken care of 99% of the hacking..

What is the full form of odbc, What is the full form of ODBC ? ODBC stand...

What is the full form of ODBC ? ODBC stands for Open Database Connectivity.

What is relational calculus, What is Relational calculus? Relational c...

What is Relational calculus? Relational calculus is a Non- Procedural language.

Explain recursive relationship type, Explain Recursive relationship type? ...

Explain Recursive relationship type? Recursive relationship type: A recursive relationship is one in that the similar entity participates more than once in the relationship

Define partial, Partial Key : It is a group of attributes that can uniquel...

Partial Key : It is a group of attributes that can uniquely identify small entities and that are related to same base entity. It is sometime named as Discriminator.  Altern

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