Create a database named music-collection-db and table named: musiccollect. Your table should contain the following columns: Song Title, Composer, Singer, Album Name, Genre (Rock/Alternative, Electronic, Classical, Country, Pop, Jazz, Blues, Reggae/Dub/Ska, World, Punk, Metal, Ambient/Instrumental ), Label, Date Released, Total Length, Youtube Link, Where to Buy, and Price. Create 30 rows containing list of songs with varied genre.

Create a database named music-collection-db and table named: musiccollect. Your table should contain the following columns: Song Title, Composer, Singer, Album Name, Genre (Rock/Alternative, Electronic, Classical, Country, Pop, Jazz, Blues, Reggae/Dub/Ska, World, Punk, Metal, Ambient/Instrumental ), Label, Date Released, Total Length, Youtube Link, Where to Buy, and Price. Create 30 rows containing list of songs with varied genre.

A Guide to SQL

9th Edition

ISBN:9781111527273

Author:Philip J. Pratt

Publisher:Philip J. Pratt

Chapter7: Database Administration

Section: Chapter Questions

Problem 4SCG: Write, but do not execute, the commands to grant the following privileges: a. User Oliver must be...

See similar textbooks

Similar questions

Write, but do not execute, the commands to grant the following privileges: a. User Rodriquez must be able to retrieve data from the TRIP table. b. Users Gomez and Liston must be able to add new reservations and customers to thedatabase. c. Users Andrews and Zimmer must be able to change the price of any trip. d. All users must be able to retrieve the trip name, start location, distance, and type forevery trip. e. User Golden must be able to add and delete guides. f. User Andrews must be able to create an index for the TRIP table. g. Users Andrews and Golden must be able to change the structure of the CUSTOMERtable. h. User Golden must have all privileges on the TRIP, GUIDE, and TRIP_GUIDEStables.
Write, but do not execute, the commands to grant the following privileges: a. User Ashton must be able to retrieve data from the ITEM table. b. Users Kelly and Morgan must be able to add new orders and order lines. c. User James must be able to change the price for all items. d. User Danielson must be able to delete customers. e. All users must be able to retrieve each customers number, name, street, city, state,and postal code. f. f User Pere7 must be able to create an index on the ORDFRS table. g. User Washington must be able to change the structure of the ITEM table. h. User Grinstead must have all privileges on the ORDERS table.
Do the tables exhibit referential integrity? Answer yes or no, and then explain your answer. Write NA (Not Applicable) if the table does not have a foreign key. FIGURE P3.17 THE CH03_TRANSCO DATABASE TABLES
Launch MSSQL program from YOUR computer and ensure command line interface is active. Create a database and name it MyFirstDatabase. Create two tables name Biodata and Contacts, choosing column names, datatypes primary keys and foreign key to link to tables. Insert twenty (20) into each table Take screenshot of the two tables, each showing all the records and save in a folder (Your name followed by index number). Obtain the ER diagram and save it in the above folder.(PLEASE INCLUDE THE STEPS)
The following tables form part of a database held in a relational DBMS: Hotel (h) hotelNo, hotelName, cityRoom (r) roomNo, hotelNo, type, priceBooking (b) bookingNo, hotelNo, guestNo, dateFrom, dateTo, roomNoGuest (g) guestNo, guestName, guestAddress where the bolded attributes are the primary keys for the respective tables. Using theabove tables, answer the following questions: 1. Create a view containing the hotel name and the names of the guests staying at the hotel. 2. Create a view containing the account for each guest at the Grosvenor Hotel. 3. Give the user Manager full access to the above 2 views, with the privilege to pass the access on to other users. 4. Create a separate table with the same structure as the Booking table to hold archive records. 5. Using the INSERT statement, copy the records from the Booking table to the archive table relating to bookings before 1st January 2021. 6. Delete all bookings before 1st January 2021 from the Booking table.
a) Create the proper database using sql queries that stores students information (ID,Name) with thier marks (Testl, Test2, Assignment1, Assignment2) then calculate and store the total mark and the final grade (A, B, C, D or F) within the same database. b) Add to the created database in (a), 10 records and then delete the record with the lowest total mark after viewing all the record (only ID and final grade).
Question 2 Launch MSSQL program from YOUR computer and ensure command line interface is active. Create a database and name it MyFirstDatabase. Create two tables name Biodata and Contacts, choosing column names, datatypes primary keys and foreign key to link to tables. Insert twenty (20) into each table Take screenshot of the two tables, each showing all the records and save in a folder (Your name followed by index number). Obtain the ER diagram and save it in the above folder.
You are given a database - MGMT2006_202324S02_Boutique Inc Student File.accdb, containing Currencies, Sales, and Locations tables to provide some results for MGMT Boutique INC. (That is, your CC will provide you with the database). You should: 1. Rename the database as MGMT2006_Boutique_ is your actual name. 2. Create relationships between pairs of tables and enforce referential integrity 3. Append two (2) new customers, two (2) old customers and two (2) new POS transactions. Be sure to include sales for your two new customers. 4. Create the following queries: a. List the names of places from which the company sells. Show all columns in the table. Name this query Q1-SELLING-LOCATIONS
Update you’re the database created in week5: lab5. Write some MYSQL code to select three different sets of data and display them on the screen. Also, delete two different records from any of the table in your the database and then print the remaining data on the screen. Finally, update one of your table with five more new rows of data and print the result of the table on the screen. Detail prior database below. Create the table StudentInf: CREATE TABLE StudentInf (rollNo INT(4) PRIMARY KEY,first_Name VARCHAR(50) NOT NULL,last_Name VARCHAR(50) NOT NULL,gender VARCHAR(10),course VARCHAR(50)); Inserting data in StudentInf table: INSERT INTO StudentInf VALUES (101, 'TONY', 'ANDREW', 'Male', 'JAVA'); INSERT INTO StudentInf VALUES (102, 'JOHN', 'MARTIS', 'Male', 'PHP'); INSERT INTO StudentInf VALUES (103, 'SWEETIE', 'JOHNSON', 'Female', 'C#'); INSERT INTO StudentInf VALUES (104, 'JIM', 'WATSON', 'Male', 'PYTHON'); INSERT INTO StudentInf VALUES (105, 'BRUCE', 'DOWNEY', 'Male', 'PHP');…
The screenshot of the Query and the results below is from the question of each number, and saved with the file name: UAS_NIM.docx or UAS_NIM.pdf Create database : - Show the date of the transaction that sells the red shoes- Show the name of the shoe purchased by the customer who has a name with the 2nd character 5 being a vowel- Show the name of the supplier who sells shoes at prices below the average shoe price Jenis_Sepatu: INSERT INTO Jenis_Sepatu values('S-01', 'Sepatu Lari');INSERT INTO Jenis_Sepatu values('S-02', 'Sepatu Basket');INSERT INTO Jenis_Sepatu values('S-03', 'Sepatu Soccer'); Supplier: INSERT INTO SUPPLIER Values('MA', 'PT. MitraAdi', 'Jl. Monginsidi 87');INSERT INTO SUPPLIER Values('SO', 'PT. Shakti Omega', 'Jl. Sudirman 23');INSERT INTO SUPPLIER Values('SS', 'PT. Sport Station', 'Jl. GunungKelud 8'); Merek: INSERT INTO Merek values('AS', 'Adidas','MA');INSERT INTO Merek values('DA', 'Diadora','SS');INSERT INTO Merek values('PA', 'Puma','SO');INSERT INTO Merek…
Create a MYSQL Database named 'db'Create a MYSQL User named 'dbuser' with a password 'dbpass' Grant Insert, Delete, Update and Select privileges for 'dbuser' on 'db' Create a MYSQL Table on database 'db' and name it as 'students' with the following field and field propertiesField Name Field Type Field Size Additional İnformationStudent No Varchar 6 Primary keyName Varchar 20 Surname Varchar 25 birthdate date
The screenshot of the Query and the results below is from the question of each number, and saved with the file name: UAS_NIM.docx or UAS_NIM.pdf Create database : - Show the name of the supplier who sells shoes at prices below the average shoe price- Show the name of the customer who bought shoes with odd sizes- Show Customer Name and Average Payment Amount for Customers who make 5transaction more than 1 Jenis_Sepatu: INSERT INTO Jenis_Sepatu values('S-01', 'Sepatu Lari');INSERT INTO Jenis_Sepatu values('S-02', 'Sepatu Basket');INSERT INTO Jenis_Sepatu values('S-03', 'Sepatu Soccer'); Supplier: INSERT INTO SUPPLIER Values('MA', 'PT. MitraAdi', 'Jl. Monginsidi 87');INSERT INTO SUPPLIER Values('SO', 'PT. Shakti Omega', 'Jl. Sudirman 23');INSERT INTO SUPPLIER Values('SS', 'PT. Sport Station', 'Jl. GunungKelud 8'); Merek: INSERT INTO Merek values('AS', 'Adidas','MA');INSERT INTO Merek values('DA', 'Diadora','SS');INSERT INTO Merek values('PA', 'Puma','SO');INSERT INTO Merek…

SEE MORE QUESTIONS

Recommended textbooks for you

A Guide to SQL

Computer Science

ISBN:

9781111527273

Author:

Philip J. Pratt

Publisher:

Course Technology Ptr

Oracle 12c: SQL

Computer Science

ISBN:

9781305251038

Author:

Joan Casteel

Publisher:

Cengage Learning

Fundamentals of Information Systems

Computer Science

ISBN:

9781305082168

Author:

Ralph Stair, George Reynolds

Publisher:

Cengage Learning

Fundamentals of Information Systems

Computer Science

ISBN:

9781337097536

Author:

Ralph Stair, George Reynolds

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

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

A Guide to SQL

Computer Science

ISBN:

9781111527273

Author:

Philip J. Pratt

Publisher:

Course Technology Ptr

Oracle 12c: SQL

Computer Science

ISBN:

9781305251038

Author:

Joan Casteel

Publisher:

Cengage Learning

Fundamentals of Information Systems

Computer Science

ISBN:

9781305082168

Author:

Ralph Stair, George Reynolds

Publisher:

Cengage Learning

Fundamentals of Information Systems

Computer Science

ISBN:

9781337097536

Author:

Ralph Stair, George Reynolds

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

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

SEE MORE TEXTBOOKS