BOOKS BookID BookName YearOfPublication AuthorID Price Bk1 Databases 2007 A1 1000 Bk2 Programming 2020 A2 500 … ….       From the tables given above, write the following in form of relational algebra Selects rows from the table Books where Book Name is ‘History’ and 'price' is 1000 or those books published after 2015

Appendix A: Database to be used for SQL select problems STUDENT Name Student_number Class Major CS Smith 17 1 Brown 8 CS COURSE Course_name Course number Credit hours Department Intro to Computer Science CS1310 4 CS Data Structures CS3320 4 CS Discrete Mathematics MATH2410 3 MATH Database CS3380 3 CS SECTION Section_identifier Course_number Semester Year Instructor 85 MATH2410 Fall 07 King 92 CS1310 Fall 07 Anderson 102 CS3320 Spring 08 Knuth 112 MATH2410 Fall 08 Chang 119 CS1310 Fall 08 Anderson 135 CS3380 Fall 08 Stone GRADE REPORT Student_number Section_identifier Grade 17 112 17 119 C 85 8. 92 8 102 8 135 A PREREQUISITE Course_number Prerequisite_number CS3380 CS3320 CS3380 MATH2410 CS3320 CS1310 Ex 5) Write SQL statement to retrieve the names of all students who took both sections 112 and 119. Show the result of this query applied to the given DB state. ANSWER: Ex 6) Write SQL statement to retrieve the names of all freshman students majoring in computer science. (Freshman students…

Need help writing SQL queries for sample data base

Write the relational algebra formula to apply an INTERSECT relational operator to the tables shown in Figure Q3.13.

how to build a bookstore database with   Entities for Tables Book  Authors  Bookstore Members  Sales transaction  Inventory

Need help writing SQL queries for sample data base

sql code sql code sql code

SQL query question

Schema: Frequents(kid, store)  Sells(store, candy)  Likes(kid, candy) d) Use SQL to list the names of all the candies that are liked by at least one kid, along with the names of the stores that sell them. Sort the result in alphabetical order by candy name.

Assume the EMPLOYEE table contains four attributes, ID, DEPT, SALARY and NAME, and has the following rows ID      DEPT     SALARY   NAME    100   SALES     40000       Smith     101     RD         38000       Terry     102     HR         60000       David     103   SALES    58000       Ellie     104      RD       70000       Judy The DEPARTMENT table contains two attributes, DEPTNAME and PHONE, and has the following rows:  DEPTNAME    PHONE     RD               8596001234     SALES        8596005555    HR              8596009876  A.) The EMPLOYEE table needs to enforce the following integrity constraints: • The ID is the primary key.  • The DEPT column is a foreign key that references the DEPTNAME in the DEPARTMENT table, so that any value that appears in the DEPT column should also exist in the DEPARTMENT table.  • The value for the NAME column can never be null.  What should be the statement used to create the EMPLOYEE table, if 1) the table was created as a partitioned table such…