Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Instructions Colleges have multiple departments where every department offers many courses. These departments have a head (HOD) and various instructors. Even though there are many
Instructions Colleges have multiple departments where every department offers many courses. These departments have a head (HOD) and various instructors. Even though there are many instructors, one instructor can only work in one department. As you can see the organization structure of a college is quite complicated and requires a lot of effort to manage. In this database project, you can build a solution to tackle this problem. It would store all this information about the college and its departments. However, the information we've discussed above isn't sufficient for a college. We need to mention the courses as well. A course can have only one instructor, but an instructor can have multiple classes. You'd need to add this information to the database system as well. You can make this project more advanced by adding the course enrollment information. You can add the enrollment information of the students as to how many students have taken a particular course. YOu need to specify the entitites , attributes and relations. You need to make the ER diagram. Specify the the tables in this project. Specify the data for each field in the project (Name, data type, constraints ) Write the SQL statement to create the tables Write SQI statement to find the data from the tables. Write sql statemt to find how many each instructor have a course. Write sql statemt to find each department, course given by this dept
Step 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