database project for school. oracles MySQL

If you're interested in doing this ill send you the file with the problem to be solved. but in general this is what needs to be done for the project. 1. Analysis. Develop a conceptual data model (one or more ER diagrams and a data dictionary) 2. Logical design. Develop a logical data model (a set of normalized relations and a data dictionary) 3. Physical design. Perform data volume analysis and data usage analysis. Consider any changes to your logical model with respect to implementation of the database in Oracle 4. Implementation. a. Create and populate your database in Oracle. Make a text file named [login to view URL] containing all commands necessary to create and populate your database. Make another text file [login to view URL] containing all commands necessary to destroy your database. b. Implement any queries required by your problem statement. Begin with DESCRIBE and SELECT ALL commands for each data table, so that you can submit the description and the content of your data tables in a well formatted readable form. Make a text file named [login to view URL] containing the implementation queries. 5. Testing. Test the suitability of your data and database design database for ad-hoc SQL queries: :Create simple, intermediate and advanced queries that will: i. Demonstrate that the database is populated according to the documented business rules ii. Produce results that clearly demonstrate the query techniques used keep your SQL commands in a text file named testQueries.sql. Include comments to improve readability and help matching your examples with the examples from the book or exercises. While testing your examples, you may find it necessary to adjust the database content so that the operations produce good illustrative results. Reflect all adjustments in the [login to view URL] file, so that your database can be recreated in its final form. Update your [login to view URL] file to also drop all objects created by [login to view URL] and/or testQueries.sql. When [login to view URL], [login to view URL], [login to view URL], and [login to view URL] are ready for submission, create a log of their execution. To do this, drop all database objects using the [login to view URL] file, and issue command spool <filename> This will create and open a “spool” text file containing all subsequent SQL commands and their results – the way you see them on the screen. To close the spool file use spool off Make the following spool files: o [login to view URL] documenting the creation of the database o [login to view URL] containing the commands and results of your implementation of the queries required in the problem statement, and o [login to view URL] documenting the execution of the commands from testQueries.sql. o [login to view URL] documenting the execution of [login to view URL] You will get better results faster, if you perform one command at a time, rather then performing a whole command file at once.