Q2/ write the schema that descibes the following relations:1- The course relationcourse.idtitledeptnameBiologyBiologyBiologyIntro. to Computer Science Comp. Sci.Comp. Sci.Comp. Sci.Comp. Sci.Database System Concepts Comp. Sci.Elec. Eng.FinanceHistoryMusicPhysicscreditsBIO-101Intro. to Biology4BIO-301BIO-399CS-101CS-190CS-315CS-319CS-347EE-181FIN-201HIS-351MU-199Genetics4Computational Biology44Game DesignRoboticsImage ProcessingIntro. to Digital SystemsInvestment BankingWorld HistoryMusic Video ProductionPhysical PrinciplesPHY-1012- The section relationcourse.idsecidbuilding rooIJumbertimeslot.idsemesterynarBIO-101BIO-301CS-101CS-101CS-190CS-190CS-315CS-319CS-319CS-347EE-1811SummerSummerFall2009Painter51451410110131282010Painter2009Packard1Spring1Packard2009 Taylor2009 Taylor2010 | Watson20102010SpringSpringESpring312812010031283128Spring2.Watson2010 Taylor2009 Taylor2009 TaylorPackardBSpringFallAFIN-201HIS-351MU-1991SpringSpringSpring1Spring2010201020103128101514101PainterPackardD4334

Drawing the schema for given relation Here, PK means Primary Key and FK means Foreign Key.

Q2/ write the schema that descibes the following relations: 1- The course relation course id title BIO-101 deptname credits Biology Biology Biology Intro. to Computer Science Comp. Sci. Comp. Sci. Comp. Sci. Comp. Sci. Database System Concepts Comp. Sci. Elec. Eng. Finance History Music Physics Intro. to Biology BIO-301 BIO-399 CS-101 CS-190 CS-315 CS-319 CS-347 EE-181 FIN-201 HIS-351 MU-199 PHY-101 Genetics 4 Computational Biology 4 Game Design Robotics 4 3. Image Processing Intro. to Digital Systems Investment Banking World History Music Video Production Physical Principles 4 2- The section relation n333

Q2/ write the schema that descibes the following relations: 1- The course relation course id title BIO-101 deptname credits Biology Biology Biology Intro. to Computer Science Comp. Sci. Comp. Sci. Comp. Sci. Comp. Sci. Database System Concepts Comp. Sci. Elec. Eng. Finance History Music Physics Intro. to Biology BIO-301 BIO-399 CS-101 CS-190 CS-315 CS-319 CS-347 EE-181 FIN-201 HIS-351 MU-199 PHY-101 Genetics 4 Computational Biology 4 Game Design Robotics 4 3. Image Processing Intro. to Digital Systems Investment Banking World History Music Video Production Physical Principles 4 2- The section relation n333

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

. Students(stulD, lastName, firstName, major, credits) Faculty (facID, name, deptName, rank) • Classes(classNumber, facID, schedule, room) • Enrolls(stulD, classNumber, grade) The primary keys are underlined. The referential integrity constraints are as follows: . the column facID of relation Classes that references table Faculty, . the column stulD of relation Enrolls that references table Students, and the column classNumber of relation Enrolls that references table Classes. The following query is intended to retrieve the number of all classes taught by John Smith in the CST department. However, this query does not work properly. There are at least two faculty members who share the name, John Smith. Briefly explain and show the corrected SQL query_ why. SELECT classNumber FROM Classes WHERE facID= (SELECT facID FROM Faculty WHERE name='John Smith' AND deptName='CST');
The following relations kind a part of a on-line database (the relations area unit self-explanatory): CUSTOMER/CLIENT/SHOPPERS/BUYERS(Cust#, CAddress, Ctown, Balance,Cname) ORDER(Order.#, Date, Cust#.) ORDERLINE(Order#, Part#., Amount-Ordered) PART(Part#., Desc, Stock, Item-Class, Unit -Price) Design a physical ER for the above scenario. With respect to this relative schema, write SQL statements for the subsequent queries: List the name of the client United Nations agency has placed Order 123 (i.e. Order: = 123). List the names of shoppers United Nations agency in Cardiff and have ordered half 456 (i.e. Part. 456). List the order numbers (Order) for orders that contain a minimum of three elements and also the quantity ordered are minimum of ten. List the outline (Desc), of these elements that the typical quantity ordered is bigger than the number ordered for half .6 (Part. = 456) so as 123.(Order. .123).
Which one of the following statement is not true: A complex object is formed by combining other objects in a set of complex relations Abstract data type (ADT) defines a set of similar objects all other three answers are correct A complex object is formed by combining other objects in a set of complex relations
Primary keys and candidate keys may both be assigned to the same attribute.
A) The following relations kind a part of a on-line database (the relations area unit self- explanatory): CUSTOMER/CLIENT/SHOPPERS/BUYERS(Cust#, CAddress, Ctown, Balance, Cname) ORDER(Order.# Date, Cust#.) ORDERLINE(Order#, Part#, Amount-Ordered) PART(Part#., Desc, Stock, Item-Class, Unit -Price) a. Design a physical ER for the above scenario. b. With respect to this relative schema, write SQL statements for the subsequent queries: 1. List the name of the client United Nations agency has placed Order 123 (i.e. Order: = 123). 2. List the names of shoppers United Nations agency in Cardiff and have ordered half 456 (i.e. Part. 456). 3. List the order numbers (Order) for orders that contain a minimum of three elements and also the quantity ordered are minimum of ten. 4. List the outline (Desc), of these elements that the typical quantity ordered is bigger than the number ordered for half .6 (Part. = 456) so as 123.(Order..123).
Convert the following Relation into INF, 2NF, and 3NF and show the functional dependencies. StudentID StudentName Major CourselD CourseTitle InstructorName InstructorLocation Grade D-Building A-Building C-Building C-Building A-Building D-Building A-Building 111 Kevin CS CS201 Bob Computer Marketing Accounting Accounting Jeff 111 Kevin CS МАЗ3 Jeff 111 Kevin CS АCC234 Sarah 222 Alex BA АСC234 Sarah B. 333 МАЗ33 Marketing Computer Marketing Noor MA 444 CS201 Bob Luay Adam BA A 555 AC МАЗ33 Jeff
11. Foreign key is the one in which the ________ of one relation is referenced in another relation. a. Foreign key b. Primary key c. References d. Check constraint
Database Schema The schema for the Ch07_FACT database is shown below and should be used to answer the next several problems. Click this image to view it in its own tab. FIGURE P7.56 THE CH07_FACT ERD CHECKOUT PATRON PK Check Num PK Pat ID FK1 Book_Num FK2 Pat_ID Check_Out_Date Check_Due_Date Check_In_Date >0-----H- Pat_FName Pat LName Pat_Type BOOK AUTHOR PK Book_Num PK Au ID Book_Title Book_Year Book_Cost Book_Subject FK1 Pat_ID Au_FName Au_LName Au_BirthYear WRITES PK,FK1 Book Num PK,FK2 Au ID The CIS Department at Tiny College maintains the Free Access to Current Technology (FACT) library of e-books. FACT is a collection of current technology e-books for use by faculty and students. Agreements with the publishers allow patrons to electronically check out a book,
Write Two CREATE USER Statements for the Publisher -Author - Books - Marketing: Database -- drop the database Publisher -Author - Books - MarketingDB if it already exists DROP DATABASE IF EXISTS PublisherAuthorBooksMarketingDB; -- create a database with name Publisher -Author - Books - MarketingDB CREATE DATABASE IF NOT EXISTS PublisherAuthorBooksMarketingDB; -- ensure that the database is used USE PublisherAuthorBooksMarketingDB; -- create the table for Publisher DROP TABLE IF EXISTS Publisher; CREATE TABLE IF NOT EXISTS Publisher ( pid VARCHAR(25), pubName VARCHAR(50), email VARCHAR(50), address VARCHAR(50), phone VARCHAR(15), CONSTRAINT Publisher_PK PRIMARY KEY(pid) ); -- create the table for Author DROP TABLE IF EXISTS Author; CREATE TABLE Author( socSecNum VARCHAR(15), authName VARCHAR (50), phone VARCHAR (15), address VARCHAR (50), email VARCHAR (50), CONSTRAINT Author_PK PRIMARY KEY (socSecNum) ); -- create the table for Marketer…
3. In mathematical term Row is referred as a. Relation b. Attribute c. Tuple d. Domain
Material : Relational Algebra Course : Database Systems Create a Relational Algebra From Entity Relational Diagram (ERD) Below for:a) Displays books published in the last 5 years from 2020.b) Displays details of customers who have done shopping (using the Join operator)c) Displays email customers who have done shopping (using the Set operator)d) Displays the ISBN book that has never been purchased (using the Set operator)
Task 1:Create a database Entity and Relationship Diagram (ERD) for the following application (Submitted An image of the Diagram By using Any Application:Application: The Application idea: It is a mobile application called (Khair) to help people. This assistance is moral, material. This assistance is also provided by good people in our community. Example to understand the Application idea more: For example, a person urgently needs a medical chair or bed and does not have the ability to purchase what he needs. The medical chair or bed is requested through the application, and whoever has what he requests initiates the request through the application’s messages and determines the meeting place. Application models (page): Login included: login registration login included: user name password New registration included: name E-mail Password phone number date National Identification Number Home page included: Request - applicant name - address - send message Messages list form included: list…