School Management System DB Project Design a database to maintain information about school staff and students satisfying following properties: 1. Staff will have their id, name, and classes they are teaching 2. Student will be having name, roll no, section, class 3. Another table containing section, subject, and teacher information 4. Next will contain fee information for students 5. One contains salary information for teachers 6. Rooms are assigned to classes keeping in mind that there is no time clash of same room or lab, students cannot be entered in more than one section, no student should be there who have not paid fees up to a particular date.
Added by Tyler B.
Close
Step 1
Step 1:** Create the table for staff: ```sql CREATE TABLE staff ( staff_id INT PRIMARY KEY, name VARCHAR(255), classes_taught VARCHAR(255) ); ``` ** Show more…
Show all steps
Your feedback will help us improve your experience
Akash M and 64 other AP CS educators are ready to help you.
Ask a new question
Labs
Want to see this concept in action?
Explore this concept interactively to see how it behaves as you change inputs.
Key Concepts
Recommended Videos
10.13 LAB - Create Movie table Create a Movie table with the following columns: ID - positive integer with a maximum value of 50,000. Title - variable-length string with up to 50 characters. Rating - fixed-length string with 4 characters. ReleaseDate - date. Budget - decimal value representing a cost of up to 999,999 dollars, with 2 digits for cents. Note: Your SQL code does not display any results in Develop mode. Use Submit mode to test your code.
Akash M.
Write the following queries in relational algebra, using the university schema. a. Find the titles of courses in the Comp. Sci. department that have 3 credits. b. Find the IDs of all students who were taught by an instructor named Einstein; make sure there are no duplicates in the result. c. Find the highest salary of any instructor. d. Find all instructors earning the highest salary (there may be more than one with the same salary). e. Find the enrollment of each section that was offered in Autumn 2009. f. Find the maximum enrollment, across all sections, in Autumn 2009. g. Find the sections that had the maximum enrollment in Autumn 2009.
Sri K.
Write the following queries in relational algebra, using the university schema. a. Find the ID and name of each instructor in the Physics department. b. Find the ID and name of each instructor in a department located in the building "Watson". c. Find the ID and name of each student who has taken at least one course in the "Comp. Sci." department. d. Find the ID and name of each student who has taken at least one course section in the year 2018. e. Find the ID and name of each student who has not taken any course section in the year 2018.
Recommended Textbooks
Computer Science and Information Technology
Introduction to Programming Using Python
Computer Science - An Overview
Transcript
Watch the video solution with this free unlock.
EMAIL
PASSWORD