Consider the provided data, Student in Table 1 and Student Course in Table 2. STUD_NO STUD_NAME 1 2 3 4 Key Super key STUD_NO 1 2 1 Candidate Key Primary Key Alternate Key Foreign key RAM RAM SUJIT SURESH Student Course: Key Super key Candidate Key Primary Key Alternate Key Foreign key STUDENT STUD_PHONE STUD_STATE STUD_COUNT STUD_AG E 9716271721 Haryana 20 9898291281 Punjab 19 7898291981 Rajsthan 18 Punjab 21 Table 1 Identify the keys and fill it in the following tables: Student: STUDENT COURSE COURSE NO C1 C2 C2 Table 2 RY India India India India COURSE_NAME DBMS Computer Networks Computer Networks

Consider the provided data, Student in Table 1 and Student Course in Table 2. STUD_NO STUD_NAME 1 2 3 4 Key Super key STUD_NO 1 2 1 Candidate Key Primary Key Alternate Key Foreign key RAM RAM SUJIT SURESH Student Course: Key Super key Candidate Key Primary Key Alternate Key Foreign key STUDENT STUD_PHONE STUD_STATE STUD_COUNT STUD_AG E 9716271721 Haryana 20 9898291281 Punjab 19 7898291981 Rajsthan 18 Punjab 21 Table 1 Identify the keys and fill it in the following tables: Student: STUDENT COURSE COURSE NO C1 C2 C2 Table 2 RY India India India India COURSE_NAME DBMS Computer Networks Computer Networks

Np Ms Office 365/Excel 2016 I Ntermed

1st Edition

ISBN:9781337508841

Author:Carey

Publisher:Carey

Chapter5: Working With Excel Tables, Pivottables, And Pivotcharts

Section: Chapter Questions

Problem 1.6CP

See similar textbooks

Similar questions

Given the following relation that stores details about students' activities: StudentID StudentName Activity ActivityFee AmountPaid 100 Jones Golf 65.00 65.00 100 Jones Skiing 200.00 0.00 200 Davis Skiing 200.00 0.00 200 Davis Swimming 50.00 50.00 300 Garrett Skiing 200.00 100.00 300 Garrett Swimming 50.00 50.00 400 Jones Golf 65.00 65.00 400 Jones Swimming 50.00 50.00
Customer_ID Customer_Name Order_ID Order_Date Product_Name Quantity 101 Alice 1 2023-09-01 Laptop 2 101 Alice 1 2023-09-01 Mouse 1 102 Bob 2 2023-09-02 Monitor 1 102 Bob 2 2023-09-02 Keyboard 1 103 Carol 3 2023-09-03 Laptop 1 103 Carol 3 2023-09-03 Speaker 2 For the following tables, identify the following functional dependencies where ( ? → Customer_Name). (Customer_ID → Customer_Name ). (Customer_ID, Order_ID → Customer_Name ). (Customer_ID, Order_ID, Order_Date → Customer_Name ). (Order_ID → Customer_Name ).
Composite datatypes may only include multi row and multi column values.Answers: Yes No
For the following Student table, find all the possible functional dependencies that arehe ld.Schema: Student (Regno, Name, DOB, Phone, Instructor_ID, Instructor_Name, Instructor_Office)Gender, Course_ID, Course_Na me ,Regno Name 14M01 Kumar 14M05 Mary 14M07 Ram 14M01 Kumar 14B01 Revathi 14M09 Steve 14B03 RamyaDOB 12-Jan-1996 10-Jun-1995 10-May-1996 12-Jan-1996 10-Dec-1995 23-Oct-1995 20-Jul-1996Phone 12345 12367 12898 12345 23456 34567 23456Gender CID M C1 F C1 M C1 M C3 F C3 M C4 F C4CNam
Implement the following ER model and sample data using Oracle SQL Developer and your CDM Oracle database account. You will submit a SQL script file and its entire outputs. The table name should be STUDENTS (plural). Each StudentID should be a five-digit number. LastName and FirstName must be entered. 12341, Doe, Jane 12342, [last name of your choice], [first name of your choice] 12343, [last name of your choice], [first name of your choice] Enrollment The table name should be ENROLLMENTS (plural). Quarters should be something like 2021Fall, 2022Winter, 2022Spring, 2022Summer1, 2022Summer2, 2022Summer10, and so forth. Grades in future quarters are entered as null. 2021Fall, 12341, IS411, A 2022Winter, 12342, IS421, null 2022Summer10, 12343, [course number of your choice], null Course The table name should be COURSES (plural). CourseNumbers should be strings of up to seven characters (e.g., IS411, DSC411, CSEC440). The course and instructor names should be strings of characters.…
You are given this table: Registration SID CourseID SemID Instructor Grade 282712 ENGL210 201701 H. Zacny B+ 362112 CS101 201701 K. Ross C 652123 CS403 201701 K. Ross A 362112 CS403 201701 K. Smith C+ 282712 BIO101 201601 I. Olsen C What will the result of the following query be? select sid, count(*)from registrationgroup by sid Select one: a. The entire table sorted by sid b. No results due to an error c. 282712 2362112 2652123 1 d. 282712 1362112 1652123 1
Find one type-2 functional dependency in the grade table Table GRADE Student ID Student Name Student Address Course ID Course Name Term Grade 700323570 Alice Roslyn, NY IT001 Information Systems 2015 Fall 3.5 700323570 Alice Roslyn, NY IT002 Python Programming 2015 Fall 4.0 700323580 Bob Mineola, NY IT002 Python Programming 2014 Spring 2.5 700323578 Cindy Jericho, NY IT110 Database 2015 Spring 3.7 700323578 Cindy Jericho, NY IT001 Information Systems 2015 Fall 4.0 700323582 Zachary Kearny, NJ IT001 Information Systems 2015 Fall 3.6 700323582 Zachary Kearny, NJ IT120 Network 2016 Spring 3.8
PART B Consider the college database you implemented in the image provided and answer the following questions. i. Write SQL statements to populate the relevant tables with the following data Studno givenName familyName faculty hons year courseno equipmentused subjectsubject 220123 Angel Matheaus FCI Computer Science 2 CSC101 laptop java 227456 Michael Jackson ACC Accounting 3 ACC510 calculator Statistics 223546 Joy Willian MGT Management 1 MGT305 project leadership Name roomno course Andrea Kulima 709 ACC510 Princess Bukohwo FCI 6 CSI101 Peter Jones 201 MGT305 Thandeka Pheto OB 12 CSI101 All staff (appraisees) are appraised by Thandeka Pheto. ii. Write an SQL statement to change Thandeka Pheto’s room number to “PH506”iii. Joy Willian decided to transfer to another college, write SQL statement to remove her details from the college’s database. iv. Write an SQL query to show all students in year 2 of their studies v. Write an SQL query to list all…
Convert the following relation into First Normal Form. If necessary, split into multiple tables to avoid redundancy anomaly. Product Name Color Maker Price Category ABC Red Yellow X 15 Toy Luxury PQR Blue Green Y 10 Luxury DEF Yellow Green X 15 Gadget Hardware
E4.11 Consider the following relation with sample data.STUDENT INTERNSHIP TABLEStudentID StudentName EmployerID EmployerName PositionID PositionDescription111 Joe A Axel Alarm 1 Sales Intern222 Mike A Axel Alarm 2 IT Help Desk Intern333 Sue B Banex Inc 2 Sales Intern444 Pat B Banex Inc 1 Front Desk Intern555 Bob B Banex Inc 1 Front Desk Intern666 Joe C Calypso Corp 1 Marketing Specialist Intern• The STUDENT INTERNSHIP Table captures the data about student internships.• Each student has a unique Student ID and a Student Name.• Each employer has a unique Employer ID and an Employer Name.• Within each employer, there are positions available.• Each position has a unique Position ID within an employer (two positions from two different employers can have thesame Position ID) and a Position Description.• Each student can work for only one employer and can hold only one position within that employer.• More than one student can work in the same position at the same employer.E4.11a Depict full…
Closely examine the following tables and use it to answer the questions that follow:departmentstudent_type student_categorycourseStudentregistration registration_typeSuppose that the following are true:- all id column are primary keys in whichever table they are- the dept_id in course table is foreign key that is referencing the id column in the department table- the foreign keys stud_type_id, stud_cat_id in the student table are referencing the id columnsin the student_type and student_category tables respectively.- the coursecode and stud_id columns in the registration table are foreign keys in the courseand student tables respectively.1. Design an Entity Relationship Diagram for the system above.2. Write query that would return the names and contacts of all Local students.3. Write a query that would return names, contact and locations of all departments that has alocation text with Ave 3 as part of it. [hint: use the LIKE clause with “_” or “%”]4. What would be the result returned…
In the following example JSON data, how could we query for the instructor's first name with the following JSON attribute called info? Assume PostgreSql { "ID": "22222", "name": { "firstname:"Albert", "lastname:"Einstein" }, "deptname":"Physics", "children": [ {"firstname": "Hans", "lastname": "Einstein" }, {"firstname": "Eduard", "lastname": "Einstein" } ] } a. info.name.firstname b. info->>'firstname' c. info->name->>'firstname' d. info->'name'.firstname