SubtitleDictateFontParagraphA Select vStylesEditingVoiceQuestion 5IConsider the following database instance.For each of the following questions, show the contents of the database (1,e, re-draw thetables showing the data) after performing the given SQL statements. Assume each SQLstatement is performed on the original database instance considering the effect of theprevious statements, so these are done in the order listed. After each step the data iscommitted (written) to the database.Table name: StudentPrimary key: SIDSIDSNAME5.1)2.Freddelete from Student where sid = 1:commit:MackShellTable name: Course5.2)Primary key: CIDupdate Course set cid 5 where cid 1:commit:CIDCNAME1FinanceCISTable name: Register5.3)Primary key: SID.CIDForeign key: SID references Student(SID)on delete cascadeinsert Register values(3,2);commitForeign key: CID references Course(CID)on update cascadeCIDSID2.5.4)12.update Register set gid = 1 where sid=2commitQuestions on next page:A1 PM10/26/202154 F Mostly sunnyof 6931 wordsP Type here to searchpg dnpg updeleteinsertprtsc1>172.

Q: Table Output when given commands are run

Question 5I Consider the following database instance. Table name: Student Primary key: SID SID SNAME Fred 1. Mack 3. Shell Table name: Course Primary key: CID CID CNAME Finance 2. CIS Table name: Register Primary key: SID,CID 2)

Question 5I Consider the following database instance. Table name: Student Primary key: SID SID SNAME Fred 1. Mack 3. Shell Table name: Course Primary key: CID CID CNAME Finance 2. CIS Table name: Register Primary key: SID,CID 2)

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Consider the database shown in Figure 1.2, whose schema is shown in Figure 2.1.What are the referential integrity constraints that should hold on the schema?Write appropriate SQL DDL statements to define the database.
The database used for this question is a very simple one with the following schema: (Primary keys are bold, foreign keys are underlined) CUSTOMER (CustID, FirstName, LastName, City, Phone, Email) INVOICE (InvoiceNumber, CustID, Date) INVOICE_ITEM(InvoiceNumber, ItemNumber, Quantity) ITEM (ItemNumber, ItemName, UnitPrice) When a customer makes a purchase, an invoice is created. The invoice may be for many items. For example, in a single purchase, a customer might buy 10 Back Scratchers, 4 Hair Removers and a Dog Lead. Provide relational algebra (NOT SQL) queries to find the following information. NOTE: You can use the symbols s, P, etc., or the words’ PROJECT’, ‘RESTRICT’ etc. as you prefer. You do not need to try to make efficient queries – just correct ones. Where you use a join, always show the join condition. List the dates on which Homer Griffin made purchases. List the first and last names of customers who have bought “Back Scratcher” or “Hair Remover” List the first…
Consider the following structure of an inventory Oracle database. oman cutomer MMERIC ($) wRCHAR 30) VARCHAR(16 DECMAL2) SALESMANLID CUETOMERDMERC($) CUST JAME NAME MCHAR(30 CITY COMMISSION VARCHAR (1 NUMERIC (3) CITY ORADE SALESMAN D ERC ($) orders ORD NO PURCH AMT NUMERIC (5) DECIMAL (8.2) ORD DATE DATE CUSTOMER ID NUMERIC (5) 00 SALESMAN ID NUMERIC (5) Write the code to List the names of salesmen who are from the city of Paris. Use the editor to format your answer 81
Complete a database design for both the Invoice_printed and Real Estate Agent Listings problems / cases. Display your normalized tables as as demonstrated in the following format: TABLENAME(Field 1 (pk), Field 2, Field 3........)
Hints: 4:14 1 ● Option 2 1. Specify all the relationships among the records of the database shown below. Assignment Details COP5725 RVC 1231 • A relationship, in the context of databases, is defined as a situation that exists between two tables. COURSE Cary mat ● Example 1: STUDENTS take SECTIONS Example 2: SECTIONS are of specific COURSES STUDENT Name Student_number Class Smith 17 1 Brown 2 SECTION 8 Course_name Intro to Computer Science Data Structures Discrete Mathematics Database GRADE_REPORT Student_number 17 17 N Section_identifier Course_number 85 MATH2410 92 CS1310 102 CS3320 112 MATH2410 119 CS1310 135 CS3380 Major CS CS Course_number Credit_hours Department CS1310 4 CS CS3320 4 CS MATH2410 MATH CS3380 CS Section_identifier 112 119 Semester Year Fall 07 Fall 07 08 08 08 08 Spring Fall Fall Fall . . .... ..... Grade B C 3 3 Submit Assignment Module 1 | Introduction to DBMS | 1 week Instructor King Anderson Knuth Chang Anderson Stone >
Question A city college would like to maintain their academic information in a MySql database system. The following are the interested information: Courses: Catalog # (M170 for instance) Credit Hours; Name of the Course (Database Design Fundamentals for instance) Course Descriptions Prerequisite Components (Lecture, or Laboratory for instance) Classes: Class # Class Name (usually the course name, M 170 for instance) Start Date End Date Meeting time (9:30 am ~ 12:15 pm, for instance) Days in a week (Monday) Term (Spring 2018, for instance) Location (TIE Building for instance) Room (UB 301, for instance) Instructor Online status (online, or in-person) Faculty: Employee Id (001880301, for instance) First Name Last Name Title (professor, for instance) Email Phone Office Location (TIE building, for instance) Room (UB303, for instance) Student: Student ID First Name Last Name Plan Sub Plan Advisor Current GPA Grade of each course The Term you got the grade for a course. The class…
My current assignment is to work on a Access database for our college for clubs. Business rules are: Some students may join no clubs. Students can only join one club. There must be one student to be a club. I am having difficulties in establishing the above rules in Access. I think my relationships are incorrect. Please see attached.
Assume there is only one seat available in a class for which two students are registering. What prevents both students from being allocated to the final available seat in a database system?