Answered step by step
Verified Expert Solution
Question
1 Approved Answer
hi there ,I want only the sql code which is work on oracle software Project objective: The main goal of this project is to give
hi there ,I want only the sql code which is work on oracle software
Project objective: The main goal of this project is to give students an apportunity to put the theory of database modelling. implementation, and application design into practice. The result will be a fully functioning database application. It includes three main phases: - The first phase. Analysis (ERO). - The second phase: Design of the relational DB. - The third phase: Implementation of the relaticoal DB. - Instructions of the project: - You can work on this project as a group (maximum 3 students). - Develap a propasal for the database management system project. - Groups should subrit for approwal their project ideas. This proposal should include: t A separate cover page indicating the title af your praject, the full names of the group members (with student ID), the course number and course section. A narrative description of the prablem or apportunity being addressed. b. Identification of the information needs 7o what information would help solve the problem or allow one to take advantage of the opportunity. hitial list af entities (tables) that have been identified. This shauld come naturally fram the above discussions. Distribution of duties for the project. List the names of each group member and what their primary role. Groups should not continue working an the project uriess it has been appraved by the instructer. - Project worth = 15 marks, wil be distributed as following Design the database following an ER model. (3 marks) 3. The ER should contain all necessary information such as entities, attributes, relationships, cardinalities etc. - Convert your ER diagram to a relational schema. (2 marks) to Underline all key attributes in your refations. 3- Specify all functional dependencies for each relation. (Mapping) - Use Oracle to create the normalized tables (2 marks) " Populate your tables with 5 rows at least. [2 marks) - Design and implement at least 4 queries. (2 marks) As specified belaw Data Retrieval Queries with Select (total of 4 Queries] Where Order By Group Ay Aggregate functians Subquery Join query Note: You are free to mix between all those clauses in ane or more query, but you have to use them all so the total number of queries for Data Retrieval Queries with Select in the end will be 4 . Using select all ( ) is NOT accepted. - Designtwa stored procedures as the fallowing (4 marks) Create a PARAMEIER based SELECI QUERY stored procedure which return recards based on parameters? Create an UPDAIE query based stored procedure Each team should submit one report for each group about his/her project via the Blackbaard contains the following: - Praject title. - Group members information (name, id, email) - ER Diagram. - All schemas before and after normaliation. - Ail SQL statements of: Creating tables Inserting data in tables w Queries. Stored Procedures - Screenshots from oracle of all the tables after population and queries results. Project Milestones - December 15th: Group Project Proposal submitted. - December 29th: Systems Analysis (E.R Madel) completed. - January 1st: Logical modelling. - February 16th: Physical Database implementation - February 23 th: Complete final report. Nate: Youmaynog work on a proiect that hasalneady been done. This includes projects that you find on the web and projects completed in prior semesters. Enample of enisting projoct: restaurant database management, hotel database management etc is NoT acceptable). (Instructors will use a plaglarismehecking tool in Blackbard) System PK : Manger ID Feedback evaluationStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started