Question 2:
Provide the tables for the following ERD
Homework Answers
Individual tables for each entity
student table:
| st-id (primary key) | s-name | s-age | s-email |
Department table:
| d-id (primary key) | d-name | d-loc | f-id(foreign key) from faculty table |
Faculty table:
| f-id(primary key) | f-name | f-major | f-office | c-crn (foreign key from course table) |
course table:
| c-crn (primary key) | c-name | c-des |
major table:
| major(primary key) |
tables for relationship takes:
| st-id(foreign key from student table) | c-crn (foreign key from course table) |
primary key for takes relationship is (st-id,c-crn)
table for Dependent:
| name | gender | age | f-id(foreign key from faculty table) |
primary key for dependent table is (name,f-id)
Add Answer to:
Question 2:
Provide the tables for the following ERD
St-Id D-Id D-name D-LOC S-name Department S-age...
Please solve on tables (Please) , for explanation keep it on text only please . the following que...
Please solve on tables (Please) , for
explanation keep it on text only please . the
following question :
Q3 : Convert the following ERD to SCHEMA
Many thanks in advance.
Presents Teacher name Faculty #Office # Section teaches #Office teching Courses determine CourseName appointment registers Time Level Status Students Student Name books ID Deanship Major
Presents Teacher name Faculty #Office # Section teaches #Office teching Courses determine CourseName appointment registers Time Level Status Students Student Name books ID Deanship...
Consider the following relations for course-enrollment database in a university: STUDENT(S-ID,S-Name, Department, Birth-date) COURSE(C-ID, C-Name, Department)...
Consider the following relations for course-enrollment database in a university: STUDENT(S-ID,S-Name, Department, Birth-date) COURSE(C-ID, C-Name, Department) ENROLL(S-ID, C-ID, Grade) TEXTBOOK(B-ISBN, B-Title, Publisher, Author) BOOK-ADOPTION(C-ID, B-ISBN) (a) Draw the database relational schema and show the primary keys and referential integrity constraints on the schema. (b) How many superkeys does the relation TEXTBOOK have? List ALL of them. (c) Now assume each COURSE has distinct C-Name. (i) If C-ID is a primary key, what are the candidate keys and the unique keys...
Please help me answer the following questions regarding data relationship tables. Employee ID First Name Last...
Please help me answer the following questions regarding data relationship tables. Employee ID First Name Last Name email Title Address Extension Department Department ID Hiring Date Department Phone # 0001 John Smith jsmith Accountant 1300 West st 5775 Accounting 2100 8/1998 407-366-5700 0002 Brian Miller badams Admin Assistant 1552 Palm dr 5367 Human resource 2300 4/1995 407-366-5300 0003 James Miller miller Inventory Manager 2713 Buck rd 5432 Production 2520 8/1998 407-366-5400 0004 John Jackson jackson_sam Sales Person 433 tree dr...
2. Consider the following database and answer the questions below SPORT ENROLLMENT STUDENT COURSE ST ST...
2. Consider the following database and answer the questions below SPORT ENROLLMENT STUDENT COURSE ST ST TITLE 313 1313 50s0 Basketbal 8989 Basketbal 007 COMP203A 7007 COMP20e 007 ames Bond 302 Database Systems COMP203 Computer Or n Brown 00 CoMP302 A o0 3un SmuCOMP42daedDatabase Systems 3 13 COMP 209 70 5050 Susan Smith COMP447 nced Database S 1313 COMP2O3A 1313 COMP302 5050 COMP20 C 1313 COMP42 7007 Write the SQL statement that displays the names of the students who have...
2- Write a program that has a Person class, a Student class, that is derived from...
2- Write a program that has a Person class, a Student class, that is derived from Person, and a Faculty class, derived from Person as well, with the following specifications: The Person class has the following members: a. An integer private member variable named SSN. b. Two string protected member variables named firstName and lastName. C. An integer protected member variable named age. d. A constructor that takes SSN, first name, last name, and age as parameters. e. A constructor...
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...
Question 2 5 pts STUDENT sid name login age ACS 28 53666 53655 53688 Kayne Tupac...
Question 2 5 pts STUDENT sid name login age ACS 28 53666 53655 53688 Kayne Tupac Bieber apa 4.0 3.5 B@cs Cors ENROLLED grade Sid 53666 53688 53688 53655 53666 15-415 15-721 15-826 15-415 15-721 Query: SELECT name, cid FROM student, enrolled WHERE student.sid = enrolled.sid AND enrolled.grade = 'C' A. Returns the name of all students and their corresponding course ids B. Returns the name of students and their corresponding course id where they have received grade C C....
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,...
Name: Question 6 (25 Points) For the shown beam below, determine the following: 1) The internal forces at F (mid-point between C & D) 2) Draw the Shear Force and Bending Moment diagrams ID: Sec:...
Name: Question 6 (25 Points) For the shown beam below, determine the following: 1) The internal forces at F (mid-point between C & D) 2) Draw the Shear Force and Bending Moment diagrams ID: Sec: (9 Points) (16 Points) 20 N 100 N N/m
Name: Question 6 (25 Points) For the shown beam below, determine the following: 1) The internal forces at F (mid-point between C & D) 2) Draw the Shear Force and Bending Moment diagrams ID: Sec: (9...
Please solve on tables (Please) , for
explanation keep it on text only please . the
following question :
Q3 : Convert the following ERD to SCHEMA
Many thanks in advance.
Presents Teacher name Faculty #Office # Section teaches #Office teching Courses determine CourseName appointment registers Time Level Status Students Student Name books ID Deanship Major
Presents Teacher name Faculty #Office # Section teaches #Office teching Courses determine CourseName appointment registers Time Level Status Students Student Name books ID Deanship...
2. Consider the following database and answer the questions below SPORT ENROLLMENT STUDENT COURSE ST ST TITLE 313 1313 50s0 Basketbal 8989 Basketbal 007 COMP203A 7007 COMP20e 007 ames Bond 302 Database Systems COMP203 Computer Or n Brown 00 CoMP302 A o0 3un SmuCOMP42daedDatabase Systems 3 13 COMP 209 70 5050 Susan Smith COMP447 nced Database S 1313 COMP2O3A 1313 COMP302 5050 COMP20 C 1313 COMP42 7007 Write the SQL statement that displays the names of the students who have...
2- Write a program that has a Person class, a Student class, that is derived from Person, and a Faculty class, derived from Person as well, with the following specifications: The Person class has the following members: a. An integer private member variable named SSN. b. Two string protected member variables named firstName and lastName. C. An integer protected member variable named age. d. A constructor that takes SSN, first name, last name, and age as parameters. e. A constructor...
Question 2 5 pts STUDENT sid name login age ACS 28 53666 53655 53688 Kayne Tupac Bieber apa 4.0 3.5 B@cs Cors ENROLLED grade Sid 53666 53688 53688 53655 53666 15-415 15-721 15-826 15-415 15-721 Query: SELECT name, cid FROM student, enrolled WHERE student.sid = enrolled.sid AND enrolled.grade = 'C' A. Returns the name of all students and their corresponding course ids B. Returns the name of students and their corresponding course id where they have received grade C C....
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,...
Name: Question 6 (25 Points) For the shown beam below, determine the following: 1) The internal forces at F (mid-point between C & D) 2) Draw the Shear Force and Bending Moment diagrams ID: Sec: (9 Points) (16 Points) 20 N 100 N N/m
Name: Question 6 (25 Points) For the shown beam below, determine the following: 1) The internal forces at F (mid-point between C & D) 2) Draw the Shear Force and Bending Moment diagrams ID: Sec: (9...
Most questions answered within 3 hours.
-
Assume Kw = 1.01 ✕ 10−14
For pure water, we can calculate [H3O+ ] = [OH...
asked 24 minutes ago -
Suppose that on a temperature scale X, water boils at 203.0°X
and freezes at -105.7°X. What...
asked 1 hour ago -
BaS crystallizes in a cubic unit cell with S2- ions on each
corner and each face....
asked 1 hour ago -
A. 0≤P(Oi)≤10≤P(Oi)≤1 for each i
B. P(Oi)≤0P(Oi)≤0
C. P(Oi)=1+P(OCi)P(Oi)=1+P(OiC)
D. P(Oi)≥1P(Oi)≥1
If an experiment consists of...
asked 3 hours ago -
A battery has an emf of 9.20V and an internal resistance of 1.20
ohm. a)What resistance...
asked 3 hours ago -
The area of an elastic circular loop decreases at a constant
rate, dA/dt = −6.60×10−3 m2/s...
asked 4 hours ago -
The denaturation of proteins can be described by the
equilibrium
F⇌U
where F and U represent...
asked 5 hours ago -
Please answer what the maximum and minimum force is, and the
angle on the ion is...
asked 5 hours ago -
implement a program that reads a number of rows and a symbol.
The program will draw...
asked 6 hours ago -
Assume that when adults with smartphones are randomly selected,
45% use them in meetings or classes....
asked 6 hours ago -
Determine the number of formula units of
Na2SO4 and moles of oxygen contained in 8.11
moles...
asked 6 hours ago -
Explain in steps on the following code
What would be the output when executed
using System;...
asked 6 hours ago