Homework Answers
If you have any doubts, please give me comment...
student(s_id, FirstName, LastName);
student_phone(s_id, phone);
foreign key(s_id) references student(s_id)
course(c_id);
take(s_id, c_id, Grade);
foreign key(s_id) references student(s_id)
foreign key(c_id) references course(c_id)
section(cid, s_id);
foreign key(c_id) references course(c_id)
semester(Year, semester);
professor(SSN, Name);
teach(Year, semster, section_id, c_id, SSN);
foreign key(c_id, section_id) references course(c_id, s_id)
foreign key(Year, semester) references semester(Year, semester)
foreign key(SSN) references professor(SSN)
Add Answer to:
Question 3 Please convert following ERDs to the schema. (10 points) sid First student Grade Last...
Create sql queries to find the following miscrosoft access compatible commands please 9. Courses for which...
Create sql queries to find the following
miscrosoft access compatible commands please
9. Courses for which at least three students earned a grade of A, showing the grade and the course code 10. Semesters when the highest number of courses have been scheduled, showing the semester name and the number of sections 11. (Extra) Professors that are not students, and students that are not professors, showing their ID and SSN 12. (Extra) Semesters for which all courses are taught by...
10- Specify the following queries in SQL on the database schema of Figure 2. a. Retrieve...
10- Specify the following
queries in SQL on the database schema of Figure 2. a. Retrieve the
names of all senior students majoring in ‘CS’ (Computer Science).
b. Retrieve the names of all courses taught by Professor King in
2004 and 2005. c. For each section taught by Professor King,
retrieve the course number, semester, year, and number of students
who took the section. d. Retrieve the name and transcript of each
senior student (Class =4) majoring in CS. A...
Conceptual data diagram The ABC university keeps track of each student's name, student number, social security...
Conceptual data diagram The ABC university keeps track of each student's name, student number, social security number (I C number), current address and phone, permanent address and phone, birthdate, sex, class (alpha, Beta, Gamma ..., graduate), major department, minor department (if any), and degree program (B.A., B.S., ..., Ph.D.). Some user applications need to refer to the city, state, and zip of the student's permanent address, and to the student's last name. Both social security number and student number have...
Problem 1 Consider the following set of requirements for a university database that is used to...
Problem 1 Consider the following set of requirements for a university database that is used to keep track of students' transcripts. (a) The university keeps track of each student's name, student number, social security number, current address and phone, permanent address and phone, birthdate, sex, class (freshman, sophomore, -, graduate), major department, minor department (if any), and degree program (B.A., B.S., ...., Ph.D.). Some user applications need to refer to the city, state, and zip of the student's permanent address,...
2. The following figure shows an ER schema for a university database. a) Map this schema...
2. The following figure shows an ER schema for a university database. a) Map this schema into a relational schema b)Show the SQL statements needed to create the relations, using proper constraints. If your translation cannot capture any constraints in the ER diagram, explain why. COffice CName CPhone COLLEGE 0. 1 D Rank Office IName IPhone INSTRUCTOR D EAN (0.NO CStartDate (0.1) <ADMINS . CHIAR (1,1) EMPLOYS (MName FName LName (SName DOB DName Sid IO.NO Name Poate DEPT on H...
Question 1: University Database Consider the following set of requirements for a UNIVERSITY database that is...
Question 1: University Database Consider the following set of requirements for a UNIVERSITY database that is used to keep track of students' transcripts. The university keeps track of each student's name, student number, social security number current address and phone, permanent address and phone, birth date, sex, class (freshman, sophomore,., graduate), major department, minor department (if any), and degree program (B.A., B.S.,..., Ph.D.). Some user applications need to refer to the city, state, and zip of the student's permanent address,...
(7) Student grade point statistics [Problem description] There is a need to make statistics of the grade points o...
(7) Student grade point statistics [Problem description] There is a need to make statistics of the grade points of the students in the first semester of 2018. It is assumed that there are n (can be set as 6) classes in this grade, and there are 20 students in each class, the total number of courses with exam is m (can be set as 10), and the percentage system is adopted for each course. The gpa is 4, 3, 2,1,...
Program 5 Due 10/25 C-String and Two-dimensional Array Use An input data file starts with a...
Program 5 Due 10/25 C-String and Two-dimensional Array Use An input data file starts with a student's name (on one line). Then, for each course the student took last semester, the file has 2 data lines. The course name is on the first line. The second line has the student's grade average (0 to 100) and the number of credits for the course Sample data: Jon P. Washington, Jr. Computer Science I 81 4 PreCalculus 75 3 Biology I 88...
(TCO 7) Write a JOIN to display the instructor first and last names and the course...
(TCO 7) Write a JOIN to display the instructor first and last names and the course description for the course the instructor is teaching Student Instructor Zipcode PK Student ID PK Instructor ID PK Zip Salutation First Name Last Name Street Address Phone Employer Registration Date Salutation First_Name Last_Name Street Address City State FK1 Zip FK1 Zip Section PK Section ID Course Course Section_Num Enrollment Start Date_Time Location PK Course ID PK,FK1 Section ID PK,FK2 Student ID Capacity FKI |...
Create sql queries to find the following
miscrosoft access compatible commands please
9. Courses for which at least three students earned a grade of A, showing the grade and the course code 10. Semesters when the highest number of courses have been scheduled, showing the semester name and the number of sections 11. (Extra) Professors that are not students, and students that are not professors, showing their ID and SSN 12. (Extra) Semesters for which all courses are taught by...
10- Specify the following
queries in SQL on the database schema of Figure 2. a. Retrieve the
names of all senior students majoring in ‘CS’ (Computer Science).
b. Retrieve the names of all courses taught by Professor King in
2004 and 2005. c. For each section taught by Professor King,
retrieve the course number, semester, year, and number of students
who took the section. d. Retrieve the name and transcript of each
senior student (Class =4) majoring in CS. A...
Problem 1 Consider the following set of requirements for a university database that is used to keep track of students' transcripts. (a) The university keeps track of each student's name, student number, social security number, current address and phone, permanent address and phone, birthdate, sex, class (freshman, sophomore, -, graduate), major department, minor department (if any), and degree program (B.A., B.S., ...., Ph.D.). Some user applications need to refer to the city, state, and zip of the student's permanent address,...
2. The following figure shows an ER schema for a university database. a) Map this schema into a relational schema b)Show the SQL statements needed to create the relations, using proper constraints. If your translation cannot capture any constraints in the ER diagram, explain why. COffice CName CPhone COLLEGE 0. 1 D Rank Office IName IPhone INSTRUCTOR D EAN (0.NO CStartDate (0.1) <ADMINS . CHIAR (1,1) EMPLOYS (MName FName LName (SName DOB DName Sid IO.NO Name Poate DEPT on H...
Question 1: University Database Consider the following set of requirements for a UNIVERSITY database that is used to keep track of students' transcripts. The university keeps track of each student's name, student number, social security number current address and phone, permanent address and phone, birth date, sex, class (freshman, sophomore,., graduate), major department, minor department (if any), and degree program (B.A., B.S.,..., Ph.D.). Some user applications need to refer to the city, state, and zip of the student's permanent address,...
(7) Student grade point statistics [Problem description] There is a need to make statistics of the grade points of the students in the first semester of 2018. It is assumed that there are n (can be set as 6) classes in this grade, and there are 20 students in each class, the total number of courses with exam is m (can be set as 10), and the percentage system is adopted for each course. The gpa is 4, 3, 2,1,...
Program 5 Due 10/25 C-String and Two-dimensional Array Use An input data file starts with a student's name (on one line). Then, for each course the student took last semester, the file has 2 data lines. The course name is on the first line. The second line has the student's grade average (0 to 100) and the number of credits for the course Sample data: Jon P. Washington, Jr. Computer Science I 81 4 PreCalculus 75 3 Biology I 88...
(TCO 7) Write a JOIN to display the instructor first and last names and the course description for the course the instructor is teaching Student Instructor Zipcode PK Student ID PK Instructor ID PK Zip Salutation First Name Last Name Street Address Phone Employer Registration Date Salutation First_Name Last_Name Street Address City State FK1 Zip FK1 Zip Section PK Section ID Course Course Section_Num Enrollment Start Date_Time Location PK Course ID PK,FK1 Section ID PK,FK2 Student ID Capacity FKI |...
Most questions answered within 3 hours.
-
MATLAB
write a MATLAB function (1) output a third-order polynomial
function with the coefficients as the...
asked 5 minutes ago -
A z-score
communicates a raw score’s "relative standing"
under the normal curve in relation to:
asked 13 minutes ago -
An object is vibrating on a spring with the following equation
of motion:
?=(30 ??)cos((2?)/(160)?)
a)...
asked 12 minutes ago -
Vulcan Flyovers offers scenic overflights of Mount St. Helens,
the volcano in Washington State that explosively...
asked 15 minutes ago -
If organizations do not adapt fast enough and move incrementally
from the twentieth-century model to the...
asked 16 minutes ago -
A helium balloon with 2.5L of gas has a gauge pressure of 10,000
Pa. The balloon...
asked 20 minutes ago -
What is responsible for Jupiter's enormous magnetic field?
asked 35 minutes ago -
At the end of the year, a company offered to buy 5,000 units of
a product...
asked 37 minutes ago -
Implement C++ program for each of the following.
Let D = [-48, -14, -8, 0, 1,...
asked 57 minutes ago -
Consider a labor market in which LD = 400 – 4W and LS = 250 +...
asked 1 hour ago -
Let’s say you are teaching a typically-developing young child
how to eat with a spoon. Describe...
asked 54 minutes ago -
Ask Your Teacher A toy gun uses a spring to project a 5.6-g soft
rubber sphere...
asked 1 hour ago