Design the database as a single relation called Movie. It should contain an ID, Title, Year Released, Genre (e.g., sci-fi, comedy, thriller, etc.), Rating (e.g., G, PG, R, etc.), Format (e.g., VHS, DVD, MP3, etc.)
Q: Each publisher has a unique name; a mailing address and telephone number are also kept on…
A: SQL database based on the given information and provide you with a textual representation of the…
Q: In this database we have users that can be two types students or instructors. They have groups and…
A: SQL which refers to the one it is a programming language used to communicate with databases. SQL…
Q: Using the getFirst() function as a template for reference, code the saveProduct() function that will…
A: In this question we have to understand and code for the saveProduct() function that will be called…
Q: Using the Henry Books database,update the paperback field for the book titled Black Houseto Y. You…
A: “Since you have posted a question with multiple sub parts, we will provide the solution only to the…
Q: and days/times (QaysTime; for example, 'MWF 9am-9.50am' or TR 3.30pm-5.20pm'- restricted to only…
A: Definition of ER Diagram : Entity Relationship Diagram or ER Diagram describes interrelated things…
Q: # Question 1 #Using the World database, in the city table, insert a new city for the Tasmania…
A: What is SQL: SQL is a language for interacting with databases. SQL is the standard language for…
Q: Create ERD for Real-estate database: There are Many Cities in each State There are Many Zip…
A: In this question we have to provide a ER Diagram for the real state database.Let's design and hope…
Q: Show the structure view of the table to see the field name ,field properties and it's data type.
A: Structure view of table : Structure view of table means schema or skeleton of table. It describes…
Q: What exactly does "Attributes" imply?
A: Introduction: Whenever we are working with or programming computers, an attribute refers to a…
Q: Below is part of a student database for your reference. The primary keys are highlighted in bold.…
A: 10) FROM student s, enrollment r, course c 12) AND r.courseno=c.courseno 22) FETCH course_list into…
Q: Primary keys and candidate keys may both be assigned to the same attribute.
A: In relational databases, keys are attributes or combinations of features that can be used to…
Q: The properties of the relation object can be used to implement the master-detail functionality which…
A:
Q: Question 7 Match a user request with the correct Express handler 1. app out product, fu Anna needs…
A: Lets see the solution.
Q: build a Gantt Chart for the project plan about. Gym/Fitness Database .
A: A Gantt Chart serves as a visual representation of a project's schedule. It effectively showcases…
Q: Because most events don't have an end time, the company only invoices the events afterward. To…
A: The given is a detailed description of EventHelper that is an organization that provides the medical…
Q: An index may speed up queries, but it's usually a terrible idea to create an index for every…
A: Index: Increasing the number of indexes in a database may significantly boost the pace at which…
Q: Task 1:Create a database Entity and Relationship Diagram (ERD) for the following application…
A: The objective of the question is to create an Entity Relationship Diagram (ERD) for a mobile…
Q: Using the Henry Books database, add the new title from Stephen King to the wrote table: Book code =…
A: The question is asking to add a new book title by Stephen King to the "wrote" table in the Henry…
Q: Design Database for the following scenario and Write SQL queries. Create an ERD for the following…
A: Create an ERD for the following scenario.Suppose there is a grocery store near your house. Answer:…
Q: Bookstore Members MemberID First Name Last Name Address Phone Number Email Date of Birth Sales…
A: A Database Management System (DBMS) provides an interface for users to interact with the database…
Q: Q2/ write the schema that descibes the following relations: 1- The course relation course id title…
A: Drawing the schema for given relation Here, PK means Primary Key and FK means Foreign Key.
Q: Task 1:Create a database Entity and Relationship Diagram (ERD) for the following application:Please…
A: The objective of the question is to create an Entity Relationship Diagram (ERD) for a mobile…
Q: An Art Museum needs to keep track of its artwork and exhibitions. The museum has a collection of…
A: In the realm of art management, maintaining a comprehensive database is crucial for efficiently…
Q: Below is “Book Order,” the only table in library management system’s database. The design of “Book…
A: 1NF (First Normal Form) Rules-->Each table cell should contain a single value. -->Each record…
Q: The database should contain the following six tables:
A: Solution:
Q: Design a survey form of your own. Fill it out as it might have been completed during the database…
A: The survey form six tables. Table name and their attributes are as follow: Branch (BranchNum,…
-
Design the
database as a single relation called Movie. It should contain an ID, Title, Year Released, Genre (e.g., sci-fi, comedy, thriller, etc.), Rating (e.g., G, PG, R, etc.), Format (e.g., VHS, DVD, MP3, etc.), a free-form Comments field, plus the main cast and crew members. Add the following entry plus at least two of your own:-
Title: Star Trek
Year: 2009 Genre: Sci-Fi
Rating: PG
Format: DVD
Director: J. J. Abrams
Starring: Chris Pine (Capt. Kirk), Zachary Quinto (Mr. Spock) Zoe Saldana (Uhura), Karl Urban (Bones McCoy)
-
![](/static/compass_v2/shared-icons/check-mark.png)
Step by step
Solved in 4 steps with 1 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
- # Question 1#Using the World database, in the city table, insert a new city for the Tasmania district. The city name is ‘Devonport’, #country code is ‘AUS’, district is ‘Tasmania’ and population is 25,387. Remember, the ID is set to auto-increment #and you will not assign a value. You will insert 2 snips for this question: #a. Insert a snip of the construct used. This MUST be a snip of the code used to insert this city into the city table. #b. Run a query to display the entire new row of Devonport inserted in the City table. Insert your snip here:Below is “Book Order,” the only table in library management system’s database. The design of “Book Order” as you may tell is in the zero normal formal form, you as the database designer want to convert the design into the third normal form. Order ID Special order date Customer ID Customer last name Customer First name Customer birth date Book ISBN1 Book Title 1 Book Author 1 Book publication year 1 Book ISBN2 Book Title 2 Book Author 2 Book publication year 2 Store ID Store name Store location Special order status Book Order(Order ID, Special order date, Customer ID, Customer last name, Customer First name, Customer birth date, Book ISBN1, Book Title 1, Book Author 1, Book publication year 1, Book ISBN2, Book Title 2, Book Author 2, Book publication year 2, Store ID, Store name, Store location, Special order status)Task 2: The Car Maintenance team also wants to store the actual maintenance operations in the database. The team wants to start with a table to store CAR_ID (CHAR(5)), MAINTENANCE_TYPE_ID (CHAR(5)) and MAINTENANCE_DUE (DATE) date for the operation. Create a new table named MAINTENANCES. The PRIMARY_KEY should be the combination of the three fields. The CAR_ID and MAINTENACNE_TYPE_ID should be foreign keys to their original tables. Cascade update and cascade delete the foreign keys. Answer in MYSQL please
- Each publisher has a unique name; a mailing address and telephone number are also kept on eachpublisher. A publisher publishes one or more books; a book is published by exactly one publisher. Abook is identified by its ISBN, and other attributes are title, price, and number of pages. Each book iswritten by one or more authors; an author writes one or more books, potentially for differentpublishers. Each author is uniquely described by an author ID, and we know each author's name andaddress. Each author is paid a certain royalty rate on each book he or she authors, which potentiallyvaries for each book and for each author. An author receives a separate royalty check for each book heor she writes. Each check is identified by its check number, and we also keep track of the date andamount of each check.TasksDesign a SQL database using the above US superstore sales data set.1.Use Visual Paradigm to draw conceptual diagram2.Use Visual Paradigm todraw ERDExplain the differences between variables and attributes in three pages.Task 2: The Car Maintenance team also wants to store the actual maintenance operations in the database. The team wants to start with a table to store CAR_ID (CHAR(5)), MAINTENANCE_TYPE_ID (CHAR(5)) and MAINTENANCE_DUE (DATE) date for the operation. Create a new table named MAINTENANCES. The PRIMARY_KEY should be the combination of the three fields. The CAR_ID and MAINTENANCE_TYPE_ID should be foreign keys to their original tables. Cascade update and cascade delete the foreign keys. Create a new table to store maintenance operations Test Query DESCRIBE MAINTENANCES Expected Results Field Type Null Key Default Extra CAR_ID char(5) NO PRI NULL MAINTENANCE_TYPE_ID char(5) NO PRI NULL MAINTENANCE_DUE date NO PRI NULL
- The database should contain the following six tables: Artists (artist_id: char(30), artist_name: char(30), artist_pop: int(5))Tracks (track_id: char(30), track_name: char(30), duration: int(10), tempo:real) Record (artist_id: char(30), track_id: char(30))Users (user_id: char(30), user_name: char(30), age: int(5), nationality: char(30), num_track_listened: int(10))Listen (user_id: char(30), track_id: char(30))Follow (user_id: char(30), artist_id: char(30), follow_date: datetime) Write a single SQL query for each request below. Find the ids of those users who have listened to at least one track but have not followed any artists. Find the ids and names of those users who have listened to some tracks recorded by the artist named 'Adele'. Find the ids and names of those users who have not listened to any track recorded by the artist named 'Adele'. Use ''NOT EXISTS'' to answer this query.The properties of the relation object can be used to implement the master-detail functionality which most appropriate for your application. You can delete a master-detail relation by selecting it in the Object Navigator and choosing Navigator => Delete. Discuss the Deletion of Relations in detail.Using the Henry Books database,update the paperback field for the book titled Black Houseto Y. You will insert 2 snips for this question. Insert a snip of the construct used to update the table: Insert your screen shot of the Books table here (be certain Black Housedisplays): Using the Henry Books database,add a new row to the AUTHORS table. The new author’s name is John Grisham. You will insert 2 snip s for this question. Insert a snip of the construct used to update the table: Insert your snip of the Authors table here showing the update: Using the Henry Books database,create a view named Paperback. It consists of the book code, book title, publisher name, and book price for every book that is available in paperback. You will insert 2 snips for this question. Insert a snip of the construct used to create this view: Run a query using this view and insert a snip of the resultset: Using the Henry Books database,write a stored procedure that…
- Using the Categories, Subjects, and Classes tables, list the category description, SubjectID, SubjectCode, and SubjectName for all subject that are taught on Wednesdays. Do not list any subject more than once.Create a procedure to allow company employee to add new product to the database. This procedure needs only IN parameters.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),…