utdaQ4: Consider the LIBRARY relational database schema shown in Figure belowa. Edit Author_name to new variable name where previoussurname was 'Al - Wazny'.Update book_Authorsset Author_name = 'alsaadi'where Author_name = 'Al - Wazny'b. Change data type of Phone to string insteadof numbers.عرفنه شنو الحلBOOKBook id Title Publisher_nameBOOK AUTHORSBook id Author_namePUBLISHERName Address Phonee ual bareragec. Add two Publishers Company existed in UK.insert into publisher(name, address, phone)value('ali','uk',78547889), ('karrar', 'uk', 78547889)d. Remove all books author when author name contains second character 'D' and ending bycharacter 'i'.es infrmarnce 1ticعرفته شنو الحلe. Add one book as variables data?عرفته شنو الحل

Q4: Consider the LIBRARY relational database schema shown in the figure below: a. Edit Author_name…

Answered: ut da Q4: Consider the LIBRARY…

Programming with Microsoft Visual Basic 2017

8th Edition

ISBN:9781337102124

Author:Diane Zak

Publisher:Diane Zak

Chapter11: Sql Server Databases

Section: Chapter Questions

Problem 6E

See similar textbooks

Similar questions

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,
q10- Options to fill in the blank to choose from are - 0,1,2
In this database we have users that can be two types students or instructors. They have groups and memberships. Any user can post and the post type can be video, photo or text. Here is the table structure: CREATE TABLE USER_ ( USER_ID INT NOT NULL AUTO_INCREMENT, CREATE_DATE DATE NOT NULL, PROF_DESC VARCHAR (100), PROF_PIC VARCHAR(40), LOCATION VARCHAR (40) NOT NULL, PRIMARY KEY (USER_ID) ); CREATE TABLE USER_INFO( USER_ID INT NOT NULL, SU_EMAIL CHAR(18), USER_FNAME VARCHAR(15), USER_LNAME VARCHAR (15), USER_DOB DATE, USER_GENDER CHAR(1), PRIMARY KEY (USER_ID), FOREIGN KEY (USER_ID) REFERENCES USER_(USER_ID) ON UPDATE CASCADE ); CREATE TABLE STUDENT ( SU_ID INT NOT NULL, USER_ID INT NOT NULL, YEAR_ VARCHAR (10), MAJOR VARCHAR (20), LOCATION VARCHAR (40) NOT NULL, PRIMARY KEY (SU_ID), FOREIGN KEY (USER_ID) REFERENCES USER_(USER_ID) ON UPDATE CASCADE ); CREATE TABLE INSTRUCTOR ( SU_ID INT NOT NULL, USER_ID INT NOT NULL, DEPARTMENT VARCHAR (40), INSTR_TYPE VARCHAR (40),…
In this database we have users that can be two types students or instructors. They have groups and memberships. Any user can post and the post type can be video, photo or text. Here is the table structure: CREATE TABLE USER_ ( USER_ID INT NOT NULL AUTO_INCREMENT, CREATE_DATE DATE NOT NULL, PROF_DESC VARCHAR (100), PROF_PIC VARCHAR(40), LOCATION VARCHAR (40) NOT NULL, PRIMARY KEY (USER_ID) ); CREATE TABLE USER_INFO( USER_ID INT NOT NULL, SU_EMAIL CHAR(18), USER_FNAME VARCHAR(15), USER_LNAME VARCHAR (15), USER_DOB DATE, USER_GENDER CHAR(1), PRIMARY KEY (USER_ID), FOREIGN KEY (USER_ID) REFERENCES USER_(USER_ID) ON UPDATE CASCADE ); CREATE TABLE STUDENT ( SU_ID INT NOT NULL, USER_ID INT NOT NULL, YEAR_ VARCHAR (10), MAJOR VARCHAR (20), LOCATION VARCHAR (40) NOT NULL, PRIMARY KEY (SU_ID), FOREIGN KEY (USER_ID) REFERENCES USER_(USER_ID) ON UPDATE CASCADE ); CREATE TABLE INSTRUCTOR ( SU_ID INT NOT NULL, USER_ID INT NOT NULL, DEPARTMENT VARCHAR (40), INSTR_TYPE VARCHAR (40),…
Assume you have a table in your database called World' with the following schema: Table: world | Column Name | Type +- | varchar | | varchar | | int | int | int | name | continent |area | I population I gdp | +-- name is the primary key column for this table. Each row of this table gives information about the name of a country, the continent to which it belongs, its area, the population, and its GDP value. It contains the following records of data: Input: World table: +-- | name | continent | area I population | gdp +-- | Afghanistan | Asia | Albania | Algeria | Andorra | Angola | 652230 | 28748 | 2381741 | 37100000 | 468 | 1246700 | 20609294 | 20343000000 | 12960000000 | 188681000000 | | 3712000000 | 100990000000 | | 25500100 | 2831741 | Europe | Africa | Europe | Africa | 78115 +- Write an SQL query to report the name, population, and area of the big countries. Return the result table in any order. A country is big if: it has an area of at least three million (i.e., 3000000 km2), or…
1-Write the syntax to insert into a relational table called students the address column references an object table called addresses that was created using an address_type. Other columns exist in the students table, but you are only inserting into the ones below. Aliases used should be the first letter of the table name, eg students would be s, addresses would be a Relational Table Name students attribute student_id attribute surname attribute address
q7- Options for both fill in the blanks are- primary key,foreign key
q4- Choose all that apply
using php We run a dog grooming shop, there are new 4 breeds that are being registered to our system. Please add their names, breeds, and ages to the database, also display the new inputs with non-prepared statements Requirement 1: Require the programmer to insert rows Requirement 2: Require the programmer to display the rows after they have been changed Requirement 3: Require use of a non-prepared statement
Assume that a database has a table named Stock, with the following columns:Column Name TypeTrading_Symbol nchar(10)Company_Name nchar(25)Num_Shares intPurchase_Price moneySelling_Price moneyWrite a Select statement that returns the Trading_Symbol column only from the rows where Purchase_Price is greater than $25.00.
Population Database Compile and run CreateCityDB.java which will create a Java DB database named CityDB. The CityDB database will have a table named City, with the following columns: CityName & Population. Their Data Types: CHAR(50) Primary Key & DOUBLE. The CityName column stores the name of a city, and the Population column stores the population of that city. After you run the CreateCityDB.java program, the City table will contain 20 rows with various cities and their populations. Next, create an application that connects to the CityDB database and allows the user to select any of the following operations: Sort the list of cities by population, in ascending order. Sort the list of cities by population, in descending order. Sort the list of cities by name. Get the total population of all the cities. Get the average population of all the cities. Get the highest population. Get the lowest population. CreateCityDB.java import java.sql.*; /** This program creates the CityDB…
Assume you have a table in database called Cinema' with the following schema: Table: cinema | Column Name 1 Туре +- | id | movie | description | rating | int | varchar | varchar | float +---- ---+ id is the primary key for this table. Each row contains information about the name a movie, its genre, it rating. rating is a 2 decimal places float in the range [0, 10] The table has the following records of data: Input: Cinema table: +----+--- | id | movie | description | rating | +----+- | 1 | 2 | 3 | 4 | 5 | War | Science | irish | Ice song I great 3D | fiction | boring | Fantacy | House card | Interesting | 9.1 | 8.9 | 8.5 | 6.2 | 8.6 +--- Write an SQL query to report the movies with an odd-numbered ID and a description that is not "boring". Return the result table ordered by rating in descending order. The results should be: Output: +-- | id | movie | description | rating | +----+ | 5 | 1 | House card | Interesting | 9.1 | 8.9 |War great 3D +----+

SEE MORE QUESTIONS

Recommended textbooks for you

Programming with Microsoft Visual Basic 2017

Computer Science

ISBN:

9781337102124

Author:

Diane Zak

Publisher:

Cengage Learning

A Guide to SQL

Computer Science

ISBN:

9781111527273

Author:

Philip J. Pratt

Publisher:

Course Technology Ptr

Programming with Microsoft Visual Basic 2017

Computer Science

ISBN:

9781337102124

Author:

Diane Zak

Publisher:

Cengage Learning

A Guide to SQL

Computer Science

ISBN:

9781111527273

Author:

Philip J. Pratt

Publisher:

Course Technology Ptr

SEE MORE TEXTBOOKS