DATA MODELLING AND DATABASE SYSTEM

You will be building a Personal database application(PDA) for a real world scenario of your choice. You will design a relational schema for the database, and you will create an actual database sing a relational database management system. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased. 1) DESCRIBE THE DATABASE APPLICATION YOU PROPSE TO WORK WITH 2) (TOP DOWN METHOD) SPEICIFY AN ENTITY-RELATIONHIP DIAGRAM WHICH INCLUDES OPTIONALITY, PLUS ENITITY, ATTRIBUTE. 3) (BOTTOM DOWN METHOD) KNOW AS NORMALISATIONSTARING WITH ONE UNIVERSAL RELATION FOR ALL THE REQUIRED DATA SHOW HOW THIS DATA CAN BE REPRESENTED IN FIRST , SECOND AND THIRD NORMAL FORM. 4) COMPARE EACH SOULTION AND RESLOVE ANY DIFFERENCED. ALSO IF YOUR SOULTION INVOLVES A LOT OF REDUNDANCY CONSIDER HOW YOU MIGHT REDUCCE THIS. 5) WRITE A SQL DATABASE SCHEMA FOR PDA. USING TEH CREATE TABLE [login to view URL] THE RESPONCE OF SQLPLUS WHEN YOU ISSUE A DESC *COMMAND. A PRINTOUT IF THE COMMMANDS YOU HAVE TYPED IN AND THIER RESPONCES 6)EXECUTE 25 INSERT COMMANDS TO INSERT TUPLESINTO FIVE OF YOUR PDA [login to view URL] TEH RESPONCE OF THE SQLPLUS WHEN U ISSUE A SELCT* [login to view URL] OF THE COMMAND AND THIER RESPONSE 7)WRITE 5 QUERIES ON YOUR FIV POPULATED PDA [login to view URL] HAVE THE FOLLWING ADVANCE FETURES RESPECTIVLY,AGGREGATION, SUBQUERY AND [login to view URL] OF COMMANDS TYPED IN AND THIER RESPONSE. 8)WRITE A DEFINITION OF A VIEW, TAHT WILL EXTRACT THE INFORMATION FROM AT LEAST 3 TABLES OF YOUR PDA [login to view URL] OF THE COMMANDS YOU HAVE TYPED IN AND THEIR RESPONCES. ## Platform ORACLE AND MICROSOFT ACCESS.