ITSE 2309 Database Programming: Oracle Lab 11 Final Project

All I need is help with 4-6. This is what I did so far:

School Management Database System Design a database system to support any number of school in an area (e-g. School District. Town, or City). The entities should include, Attendance. Classes, Parents Schools, Students, and Teachers. 1. Write the business rule(s) that govern the relationship between the entities 2. Given the business rule(s) you wrote in Step 1, create a Crows Foot ERD. Do not 2. Given the business rule(s) you wrote in Step 1, create a Crow's Foot ERD. Do not use your free hand to create the ERD 3. Determine the characteristics of each entity (Attributes) 4. Identify the Primary and Foreign keys and any other constraints for each entity 5. Make sure they are in 1NF, 2NF, and 3NF 6. Write DDLs, in a file, to create tables for your database and populate them. See the JustLee scripts. 7. Create a folder and copy all your work there. Zip the folder, rename it to your Fullname-Final-Project.zip, and then upload it to Blackboard