write down your SQL statements on the exam paper

By
Responsive Centered Red Button

Need Help with this Question or something similar to this? We got you! Just fill out the order form (follow the link below), and your paper will be assigned to an expert to help you ASAP.

Order Form

Learning Goal: I’m working on a mysql test / quiz prep and need an explanation and answer to help me learn.The following questions are based on the Alexamara Marina Case. Please write down your SQL statements on the exam paper, use the Henry Books Case database files downloaded from myCourses (Miterm Exam folder) to understand the database design and test your SQL statements. 1.List the title of each book that has word “the” in its title.2.How many book copies have a price that is greater than $20 but less than $25?3.List the branch name, copy number, quality, and price for each copy of Electric Light.4.For each book copy with a price greater than $25, list the book’s title, quality and price.5.For each book copy available at the Henry on the Hill branch whose quality is excellent, list the book’s title and author names (In the order listed on the cover).6.List the author’s firstname and lastname for the book with the most copies.7.Create a new table named FictionCopies using the data in the BookCode, Title, BranchNum, CopyNum, Quality and Price columns for those books that have the type FIC.8.Ray Henry is considering increasing the price of all copies of fiction books whose quality is excellent by 10%. To determine the new prices, list the book code, title and increased price of every book in the FictionCopies table. (Your computed column should determine 110% of the current price, which is 100% plus a 10% increase).9.Use an update query to change the price of each book in the Fiction Copies table with a current price of $14.00 to $14.50.10.Use a delete query to delete all books in the Fiction Copies table whose quality is poor.1.Normalization (20 Points)GradeReport (StudentID, StudentName, StudentAddress, StudentMajor, CourseID, CourseName, InstructorID, InstructorName, InstructorOffice, Grade)Assumptions:1.One student can only have one major.2.One course can only have one instructor.3.One instructor can only have one office.Using the GradeReport table structure above, do the following:a)Explain in which normal form this table is (1 Points)b)Find the Primary Key for this relation and explain your choice (2 Points)c)Make Functional Dependency Diagram (indicate all partial and transitive dependencies) (6 Points)d)Normalize the table to 2NF (3 Points)e)Normalize the tables to 3NF(4 Points)f)Draw crow’s foot notation ERD (4 Points)
Requirements: Exam asap

How to create Testimonial Carousel using Bootstrap5

Clients' Reviews about Our Services