Ask a question from expert

Ask now

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

2 Pages225 Words261 Views
   

Added on  2019-09-16

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

   Added on 2019-09-16

BookmarkShareRelated Documents
you will implement Database of any type of company (café) and then apply some of the concepts that we will learn in the lab. It must be completed, and all required components turned.Project Description:Create database tables (at least 5 tables) as you learn in Database I course. Don't forget to make the following:oPrimary Key, Foreign Key, unique, not null and check constraint.o 1-1, 1-M, M-M relations.Populate each table with complete and accurate data (at least 10 records in every table).Create the following in PL/SQL on 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 or WHILE 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 check constraint.
you will implement Database of any type of company (café) and_1

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Submission 4: Database Creation and SQL Queries
|5
|1012
|289

Database Management Systems Analysis
|5
|697
|34

Build the database you designed in CA4 - Databases, 2016
|4
|955
|313

SQL Final Exam
|3
|777
|265

Database Fundamentals Assignment
|13
|801
|175

Accounting Information System: REA Diagram, Database Architecture, Structure and Design
|8
|502
|472