you will implement Database of any type of company (café) and

Added on - 16 Sep 2019

  • 2

    Pages

  • 225

    Words

  • 179

    Views

  • 0

    Downloads

Trusted by +2 million users,
1000+ happy students everyday
Showing pages 1 to 1 of 2 pages
you will implement Database of any type of company (café) and thenapply some of the concepts that we will learn in the lab. It must becompleted, and all required components turned.Project Description:Create database tables (at least 5 tables) as you learn in Database Icourse. Don't forget to make the following:oPrimary Key, Foreign Key, unique, not null and checkconstraint.o1-1, 1-M, M-M relations.Populate each table with complete and accurate data (at least 10records in every table).Create the following inPL/SQLon your database:oProcedures (4 at least)oFunctions(4 at least)oTriggers(4 at least)oExceptions(4 at least)oAny loop types:Basic loop, FOR loop orWHILE loop(4 at least)The final report shoud include:Short description of your database.Printout the description of each table.Printout the results of a SELECT * for every table.Printout the creation of Primary Key, Foreign Key and checkconstraint.
desklib-logo
You’re reading a preview
Preview Documents

To View Complete Document

Click the button to download
Subscribe to our plans

Download This Document