design a database from scratch using oracle 8. -the database must consist of 4 of more tables with proper relationships in 3NF. - represent the database diagramatically. - create tables using DDL queries. add appropriate data to each table. - create DML queries using substitution variables,views, and nested queries - design data retrieval queries using various joins, functions, set operators and nested queries - utilize various database objects like synonym,view,sequence and index - implement user access control for different objects. - use PL/SQL block(at least one ) for data manipulation. -save each query in individual files with an .sql extension , which can be loaded and used by users -create a simple documentation to support the project -justify creation of each object and its use. -submit the table structures, records , constraint info,queries, and programs.
Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. Complete copyrights to all work purchased.