Database The solution is in clear handwriting Consider a library database with the following tables, then answer following Questions:Publisher TablePublisher_ID Publisher_Name Country1WileyUSA2PearsonAUS3Mcgraw hillKSABook TableBook ID Publisher_IDBook_NameAuther_Name Price13Accounting Principles21Business MathCynthia ClarkSteve Slavin1251003142Database SystemsIntro to DB Management Mark L. Gillenson 90Thomas Connolly 1501- Find the name of Publisher along with book which they published. (Using Relational algebra).2- Display name of publishers and where they locate. (Using Relational algebra).3- Update the country name of 'Mcgraw hill' to 'USA' (Using SQL Query).4- What is the output of following query: (Draw the diagram of the table with values)A. II Book_name, price (σ price->100 (Book))B. alter table Publisher add Phone_num int;

1. Find the name of Publisher along with the book which they published. (Using Relational…

Answered: Consider a library database with the…

Principles of Information Systems (MindTap Course List)

12th Edition

ISBN:9781285867168

Author:Ralph Stair, George Reynolds

Publisher:Ralph Stair, George Reynolds

Chapter5: Database Systems And Applications

Section: Chapter Questions

Problem 11SAT

See similar textbooks

Similar questions

The ABC Database Tables Table A TRUCK_NUM BASE CODE TYPE_CODE TRUCK_MILES TRUCK BUY DATE TRUCK SERIAL NUM 501 502 501 23-Sep-07 AA-322-12212-WM1 05-Feb-06 AC-342-22134-Q23 11-Nov-OS AC-445-78656-Z99 06-Jan-07 WVQ-112-23144-T34 01-Mar-06 FR-998-32245-W12 15-Jul-03 AD-456-00845-R45 17-Oct-04 AA-341-96573-284 07-Aug-05 DR-559-22169-D33 12-Feb-08 DE-887-98458-E94 1001 1032 1003 1004 1005 1006 1007 1009 1009 Table C Table B BASE CODE 501 502 Lexington 503 Cape Girardeau 504 Detton 503 501 502 502 T TYPE_CODE 503 BASE CITY Murfreesboro TYPE DESCRIPTION 1 Single box, double-sode 2 Single box, single-axde 3 Tandem trailer, single-exde 1 1 2 1 2 2 3 32 2 32123.5 76934.3 12346.6 2894.3 45673.1 193245.7 32012.3 44213.6 10932.9 BASE STATE BASE_AREA_CODE TN KY MO GA 615 568 456 901 BASE PHONE 123-4567 234-5678 345-6789 458-7890 BASE MANAGER Andree D. Gallager | George H. Delarosa Maria J. Talindo Peter F. McAvea
Create the ERM. FIGURE Q3.22 THE CH03_THEATER DATABASE TABLES Database name: Ch03_Theater Table name: DIRECTOR DIR_NUM DIR LNAME DIR DOB 100 Broadway 101 Hollywoody 18-Nov-53 102 Goofy 12-Jan-65 21-Jun-62 Table name: PLAY PLAY CODE PLAY NAME 1001 Cat On a Cold, Bare Roof 1002 Hold the Mayo, Pass the Bread 1003 I Never Promised You Coffee 1004 Silly Putty Goes To Washington DIR NUM 102 101 102 100 1005 See No Sound, Hear No Sight 101 1006 Starstruck in Biloxi 102 1007 Stranger In Parrot Ice 101
Create the table that would result from Tstu_code, dept_code (student a professor). FIGURE Q3.8 THE CH03_COLLEGEQUE DATABASE TABLES Database name: Ch03_CollegeQue Table name: STUDENT STU CODE PROF_CODE 100278 128569 2 512272 4 531235 2 531268 553427 1 Table name: PROFESSOR PROF CODE DEPT CODE 12 26 36 44 To upload and submit your assignment, click the Choose File button below to find and select your saved document. Make sure that the file is saved with your last name in the file name. (Example: ch3_review1_Jones.doc)
Insert the following data into your database tables.STUDENTSSTUDENT_ID STUDENT_NAME STUDENT_SURNAMES123456 Neo PetleleS246810 Derek MooreS369121 Pedro NtabaS654321 Thabo JoeS987654 Dominique WoolridgeMODULESMODULE_ID MODULE_NAME MODULE_CREDITDATA6212 Database Intermediate 30INPU221 Desktop Publishing 20PROG6211 Programming 2A 15PROG6212 Programming 2B 15WEDE220 Web Development (Intermediate) STUDENT_MODULESSTUDENT_ID MODULE_IDS123456 PROG6211S123456 PROG6212S246810 DATA6212S369121 DATA6212S369121 INPU221S369121 WEDE220S987654 PROG6211S987654 PROG6212S987654 WEDE220LECTURERSLECTURER_ID LECTURER_NAME LECTURER_SURNAMEL578963 Kwezi MbeteL876592 Julia RobinsL916482 Trevor JanuaryLECTURER_MODULESMODULE_ID LECTURER_IDDATA6212 L578963INPU221 L876592PROG6211 L916482PROG6212 L916482WEDE220 L876592Correct INSERT statements used and all data correctly inserted per table.
to de Category 15 PK to do id PK category id name description create date 18 deadine FK categoryid FK user id create date user PK user id first name last name email create_date The above ER Diagram shows a simple TODO tasks management database. The create table script for Category table is given to you below. Complete the script by providing the correct definitions of the other two tables. Choose the data types of each attribute and assume all primary keys to be auto incrementing integers. Create Table Category ( user_id int primary Key identity(1,1), name varchar(255),
name of table 1 Staff_info: Staffid (pk) Fname Lname Dob Genderid Course_code (fk) Gender_info: Genderid (pk) gender Course_info: Course_code (pk) Course_name Departid (fk) Depart_info: Departid (pk) Depart_name using the information above develop a database using mysql workbench and connect the tables to each other using the propper fk (foreign key) and pk (primary key) database name should be connectstaff
Publisher Books Wagon Blackwell Pub Orion Orion Visual For Dummies ISBN 9788184122077 1855543575 9781118530801 9781119356332 047029079X B01JXRM6MO Book Title Structured Query Language Structured Query Language The Data Warehouse Toolkit Windows 10 Anniversary Update Bible Master Visually Windows XP IBM Lotus Symphony for Dummies YearPublished | Author_FirstName Author_LastName 2017 Ashis 1994 Akeel 1972 Ralph 2019 Rob 2005 Rob 2008 Rob Saklani Din Kimball Tidrow Tidrow Tidrow Please note that the ISBN is a code that uniquely identifies a book. In other words, there are no two books globally that have the same ISBN. 1. Using the above data, create an Entity Relationship (ER) diagram. You may use any external tool to create this (including hand drawn and photographed). Where necessary, please create primary keys for the entities.
FIGURE P8.31 CH08_SALECO2 DATABASE TABLES Database name: Ch08_SaleCo2 Table name: CUSTOMER Table name: INVOICE CUS CooE CuS LNAMECUS PNAME CuS NMAL CUSAREACOCE CU PHONE CuS BALANCE OIE Rumas CO1 Dure W NUNGER | CUS_CO DATE 100 19014 16--1 1001 16Jan-18 TOTAL TA otAL Ahet Lre Kay 544 04-126 000 1070 19012 16n-t 10011 17an-18 10018 153S 0013 Obenki KCO14 Odundo Myren COS O 56 76 00 0.00 221 19 16 4-210 222-1 403 2-12 1004 100s 280 7044 James Gege 1000 10014 17an-18 10017 wane 15 10015 1tlan18 200 00 Fart 210 000 Are Clate 1001 t 1008 431 de 615 207-00 Table name: LINE WNUMEES DENUMBERCOCE| LHE UNTS UE PRICE UHE TOTAL Table name: PRODUCT 1499 149 1001 1DERO Power pairte, 15 pa, Seorz 13-02 per bde 140 900 p e 00 1000 499 130eo-17 140 1000 1.223/OPD 13Nv-17 15a1a 12 1749 000 21344 1000 3 13022 749 14 90 19.00 70.44 207 108 92 1000 1490 19 om H 10n,0 z Y DO gnew. 12n 15-n-1 23 43 199 20e-17 24ec1 1004 1006 22OHE 1 PVCZDRT 1 SM 1077 2 22OTY 9.06 ar 12 22ORD BIO conder I0 20He O hanmer 21LAA…
This feature of a database insures that each row in a table is unique. Group of answer choices database key foreign key primary key composite key
Identify the foreign keys. FIGURE Q3.22 THE CH03_THEATER DATABASE TABLES Database name: Ch03_Theater Table name: DIRECTOR DIR_NUM DIR LNAME DIR DOB 100 Broadway 101 Hollywoody 18-Nov-53 102 Goofy 12-Jan-65 21-Jun-62 Table name: PLAY PLAY CODE 1001 Cat On a Cold, Bare Roof 1002 Hold the Mayo, Pass the Bread PLAY NAME DIR NUM 102 101 1003 I Never Promised You Coffee 102 1004 Silly Putty Goes To Washington 1005 See No Sound, Hear No Sight 1006 Starstruck in Biloxi 1007 Stranger In Parrot Ice 100 101 102 101
Given a small company database tables below. Create the database and tables for the company and answer all the questions below. LINE CUSTOMER VENDOR INV_NUMBER LINE_NUMBER P_CODE LINE_UNITS LINE_PRICE Cus CODE CUS_LNAME CUS_FNAME CUS_INITIAL cus AREACODE CUS_PHONE CUS_BALANCE V_CODE V_NAME V_CONTACT V_AREACODE V_PHONE V_STATE V_ORDER 1000 3 23100-HB 0.05 10010 Ramas Afred 015 844-2573 21225 Bryson, Ine. Smithson 015 223-3234 TN 1006 4 89-WRE-Q 256.00 10011 Dunne Leona 713 804-1238 21220 SuperLoo, Inc. Flushing 04 215-8006 FL N 1 13-Q2/P2 2 14.00 1007 10012 Smith Kathy 015 804-2205 345.88 21231 DSE Supply Singh 815 228-3246 TN 1007 254778-2T 4.00 10013 Olowski Paul 815 804-2100 530.75 21344 Gomez Bros. Ortega 815 889-2546 KY N 1008 1 PVC23DRT 5.87 10014 Orlando Myron le15 222-1872 22507 Dome Supply Smith 01 e78-1419 GA IN 1008 2 WR3/TT3 3 110.05 10015 OBrian Amy 713 442-3381 23110 Randsets Ltd. Anderson 001 078-3008 GA 1008 3 23100-HB 0.05 10010 Brown James 015 297-1228 221.19 24004…

Recommended textbooks for you

Principles of Information Systems (MindTap Course…

Computer Science

ISBN:

9781285867168

Author:

Ralph Stair, George Reynolds

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

Principles of Information Systems (MindTap Course…

Computer Science

ISBN:

9781285867168

Author:

Ralph Stair, George Reynolds

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS