The relational schema shown below is part of a student database. The primary and foreign keys are highlighted in bold.
The relational schema shown below is part of a student database. The primary and foreign keys are highlighted in bold.
Student (studNo, studName, address, mobileNo)
Course (courseNo, courseName, creditHour, level)
Registration (studNo, courseNo, regDate, semester, session)
Project (projNo, projName, courseNo)
Assignment (projNo, studNo, startDate, dueDate, hoursSpent)
Write SQL queries based on the student database given above:
1. Create tables & constraints for the student database.
2. Insert some data into the tables to check that the tables created are correct.
No limit on how many rows you want to add.
Insert Syntax:
insert into table_name
values (col1_value, col2_value, etc.);
3. List all the students’ details, alphabetically by name.
Homework Answers
Request Answer!
We need at least 10 more requests to produce the answer.
0 / 10 have requested this problem solution
The more requests, the faster the answer.
Add Answer to:
The relational schema shown below is part of a student database. The primary and foreign keys are highlighted in bold.
Given the following relational database schema (primary keys are bold and underlined). Answer questions 2.1 to 2.4 Orde...
Given the following relational database schema (primary keys are bold and underlined). Answer questions 2.1 to 2.4 Orders(orderld, customerld, dateOrdered, dateRequired, status) Customer(customerld, customerLastName, customerStreet, customerCity, customerState, customer Lip OrderDetails(orderld.productld, quantity, lineNumber, amount) Products(productld, name, description, quantity, unitPrice) Account(accountNumber, customerld, dateOpened, creditCard, mailingStreet, mailingCity, mailingState, mailingZip) 2.1 (2 Points) List all possible foreign keys. For each foreign key list both the referencing and referenced relations. 2.2 (2 Points) Devise a reasonable database instance by filling the tables with data of...
Consider the below schema of the university database (keys are in bold and underline): Students(stuID: Integer,...
Consider the below schema of the university database (keys are in bold and underline): Students(stuID: Integer, stuName: String, gender: String, age: Integer, gpa: Float) Departments(deptName: String, numPhDs: Integer) ProfessorWorks(profID: Integer, profName: String, deptName: String) CoursesOffer(cNo: String, cTitle: String, deptName: String) Majors(deptName: String, stuID: Integer, degreeProgram: String; attendYear: String, attendSemester: String) Sections(cNo: String, academicYear: String, semester: String, sectNo: Integer, profID: Integer) Enrolls(stuID: Integer, cNo: String, academicYear: String, semester: String, sectNo: Integer, grade: String) Write the following queries in Relational algebra. Print...
**************PLEASE COMPLETE PART F) ONLY************** Consider the following relational database schema (primary keys are underlined) and...
**************PLEASE COMPLETE PART F) ONLY************** Consider the following relational database schema (primary keys are underlined) and SQL query: Hotel (hotelNo, hotelName, city) Room (roomNo, hotelNo, type, price) Booking (hotelNo, guestNo, dateFrom, dateTo, roomNo) Guest (guestNo, guestName, guestAddress) SELECT g.guestNo, g.guestName FROM Room r, Booking b, Hotel h, Guest g WHERE h.hotelNo = b.hotelNo AND g.guestNo = b.guestNo AND h.hotelNo = r.hotelNo AND h.hotelName = "Ritz" AND dateFrom >= "Jan 01, 2001" AND dateTo <= "Dec 31, 2001"; (A) state what...
**************PLEASE COMPLETE PART E) ONLY************** Consider the following relational database schema (primary keys are underlined) and...
**************PLEASE COMPLETE PART E) ONLY************** Consider the following relational database schema (primary keys are underlined) and SQL query: Hotel (hotelNo, hotelName, city) Room (roomNo, hotelNo, type, price) Booking (hotelNo, guestNo, dateFrom, dateTo, roomNo) Guest (guestNo, guestName, guestAddress) SELECT g.guestNo, g.guestName FROM Room r, Booking b, Hotel h, Guest g WHERE h.hotelNo = b.hotelNo AND g.guestNo = b.guestNo AND h.hotelNo = r.hotelNo AND h.hotelName = "Ritz" AND dateFrom >= "Jan 01, 2001" AND dateTo <= "Dec 31, 2001"; (A) state what...
Database: Convert E-R diagrams to relational schema and show • Primary Keys (using underline) • Foreign Keys (using dotted underline) • Referential Integrity Convert the E-R diagrams to relational s...
Database: Convert E-R diagrams to relational schema and show
• Primary Keys (using underline)
• Foreign Keys (using dotted underline)
• Referential Integrity
Convert the E-R diagrams to relational schema and show: Primary Keys (using underline) Foreign Keys (using dotted underline) . Referential Integrity Your schema should look similar to the example below. CUSTOMER CustName ORDER PROJECT Foect Title EMPLOYEE PROJECT assigecl to Tite BBli EMPLOYEE PROJECT 0 ProectTitle 4 student admitdate D,C gradstudent advisor major mimor class person name...
Learning Objectives: Learn to define constraints on tables Lean to define primary keys and foreign keys...
Learning Objectives: Learn to define constraints on tables Lean to define primary keys and foreign keys Exercise In Lab 09, we will continue the practice of creating tables. You will need to write SQL statements for the tasks specified below. After you complete them, submit your SQL script (in one *.sql file) to Blackboard by 11:59pm Nov. 16 (Friday). Include your name as a comment in the SQL script submitted. The creation statement for each table is worth one point,...
Hospital Patient Reglstration System Hospltal Patient Registration System Part 2: Relational Sche...
Hospital Patient Reglstration System Hospltal Patient Registration System Part 2: Relational Schema: Description of Tables 1) 2) Patient Table: Contains detail information about patients. Patient Address: Contains list of patients addresses. Each Patient can have more than one Address. However, an address can belong to only one patient. DOD DATETM 3) Provider Table: Contains detail information about Service Provider's, 4) Provider Address: Contains list of provider's addresses. 5) Provider Department: Contains information about which provider are in which department. Provider...
Develop SQL code that would create the database files corresponding to your relational schema for the...
Develop SQL code that would create the database files
corresponding to your relational schema for the Mountain View
Community Hospital case study created in Phase 2 of the class
project.
Write the SQL statements for creating the tables, specifying
data types and field lengths, establishing primary keys and foreign
keys, and implementing other constraints you identified.
Write the SQL statements that create the indexes. This is
optional.
You should execute your SQL code on a DBMS (Oracle 11g or Oracle...
(MMU) has decided to consolidate the functionality of three small overlapping database systems, which support applications...
(MMU) has decided to consolidate the functionality of three small overlapping database systems, which support applications for 1) teaching (e.g. instructor assignment and evaluation), for 2) registration (e.g. online course status, waiting lists), and for 3) student records (e.g. transcript generation) The resulting new system will support the following enterprise description: Professors and GTAs are assigned to teach the sections of each class being offered in a semester. At the end of the semester, they get a "team rating" (professors...
Given the following relational database schema (primary keys are bold and underlined). Answer questions 2.1 to 2.4 Orders(orderld, customerld, dateOrdered, dateRequired, status) Customer(customerld, customerLastName, customerStreet, customerCity, customerState, customer Lip OrderDetails(orderld.productld, quantity, lineNumber, amount) Products(productld, name, description, quantity, unitPrice) Account(accountNumber, customerld, dateOpened, creditCard, mailingStreet, mailingCity, mailingState, mailingZip) 2.1 (2 Points) List all possible foreign keys. For each foreign key list both the referencing and referenced relations. 2.2 (2 Points) Devise a reasonable database instance by filling the tables with data of...
Database: Convert E-R diagrams to relational schema and show
• Primary Keys (using underline)
• Foreign Keys (using dotted underline)
• Referential Integrity
Convert the E-R diagrams to relational schema and show: Primary Keys (using underline) Foreign Keys (using dotted underline) . Referential Integrity Your schema should look similar to the example below. CUSTOMER CustName ORDER PROJECT Foect Title EMPLOYEE PROJECT assigecl to Tite BBli EMPLOYEE PROJECT 0 ProectTitle 4 student admitdate D,C gradstudent advisor major mimor class person name...
Hospital Patient Reglstration System Hospltal Patient Registration System Part 2: Relational Schema: Description of Tables 1) 2) Patient Table: Contains detail information about patients. Patient Address: Contains list of patients addresses. Each Patient can have more than one Address. However, an address can belong to only one patient. DOD DATETM 3) Provider Table: Contains detail information about Service Provider's, 4) Provider Address: Contains list of provider's addresses. 5) Provider Department: Contains information about which provider are in which department. Provider...
Develop SQL code that would create the database files
corresponding to your relational schema for the Mountain View
Community Hospital case study created in Phase 2 of the class
project.
Write the SQL statements for creating the tables, specifying
data types and field lengths, establishing primary keys and foreign
keys, and implementing other constraints you identified.
Write the SQL statements that create the indexes. This is
optional.
You should execute your SQL code on a DBMS (Oracle 11g or Oracle...
(MMU) has decided to consolidate the functionality of three small overlapping database systems, which support applications for 1) teaching (e.g. instructor assignment and evaluation), for 2) registration (e.g. online course status, waiting lists), and for 3) student records (e.g. transcript generation) The resulting new system will support the following enterprise description: Professors and GTAs are assigned to teach the sections of each class being offered in a semester. At the end of the semester, they get a "team rating" (professors...
Most questions answered within 3 hours.
-
Hey im just confused about how to put the ' A angle n' and ' S...
asked 1 minute from now -
A short essay about the WSJ article on Oreo versus Hydrox.
asked 22 seconds ago -
##8. A program contains the following function definition:
##def cube(num):
##return num * num * num...
asked 7 minutes ago -
find the value z of a standard Normal variable that satisfies
each of the given conditions....
asked 30 minutes ago -
"banana".find('z')
Out[22]: -1
why is this -1
python 3.7
asked 11 minutes ago -
Ilegal Consideration Marna Balin was involved in two automobile
accidents in which she suffered severe injures.She...
asked 20 minutes ago -
Walk through the operation of QuickSort when n = 7 and the input
array is A...
asked 15 minutes ago -
Answer with True or False. Argue the answers
7) The circulation of field B on any...
asked 23 minutes ago -
Chase Co. uses the perpetual inventory method. The inventory
records for Chase reflected the following
Jan...
asked 21 minutes ago -
what are is the correct compression for these two ipv6 ips.. i
keep getting them wrong...
asked 26 minutes ago -
How does the amount of silica gel used change separation?
asked 27 minutes ago -
A barium hydroxide solution is prepared by dissolving 1.91 g1.91
g of Ba(OH)2Ba(OH)2 in water to...
asked 46 minutes ago
> Please answer this question as soon as possible
Thank you
Nisu Tue, Oct 19, 2021 4:14 AM