1. Consider the following tables and their structures, which are part of a common database: CUSTOMER (Customer ID, Company Name) SOFTWARE (SoftwareID, SoftwareName, Operating System, Description) LICENCE (LicenceID, Customer ID, SoftwareID, DateOfPurchase, LicenceType, Cost, Expiry Date) (a) Identify the keys (primary keys, alternate keys, foreign keys) from each of the tables. (b) Write a query to display all software for the operating system "Linux" from the table Software. (c) Write a query to list all the licences where cost is more than 35000. Group the output by CustomerID, and in ascending order of cost.

1. Consider the following tables and their structures, which are part of a common database: CUSTOMER (Customer ID, Company Name) SOFTWARE (SoftwareID, SoftwareName, Operating System, Description) LICENCE (LicenceID, Customer ID, SoftwareID, DateOfPurchase, LicenceType, Cost, Expiry Date) (a) Identify the keys (primary keys, alternate keys, foreign keys) from each of the tables. (b) Write a query to display all software for the operating system "Linux" from the table Software. (c) Write a query to list all the licences where cost is more than 35000. Group the output by CustomerID, and in ascending order of cost.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

8.DSA_ AND ALGO DATABASE MTT Following tables support the database of a shopping store. The schema contains four tables i.e.Customer, Product, Order and Order Product. Table details including attributes, primary keys(underline) and foreign keys (bold) are also shown below:CUSTOMER(CustID, CustName, CustEmail, CustPhone, CustCNIC)PRODUCT(ProdID, ProdName, ProdPrice)ORDER(OrderID, OrderDate, OrderPrice, CustID)ORDER_PRODUCT(OPID, ProdID, OrderID) i. Write SQL queries to create all above mentioned four tables in SQL. Must take care of correct data type and constraints (primary key, foreign key, not null etc.) where necessary. ii. Write a SQL query to get all customers’ data who use “yahoo” email. iii. Write a SQL query to show all product names that are in price range of 500 – 1500 (both inclusive) in descending order.?
Assume the e-commercial database shown in the Appendix. Write the following queries in (a) relational algebra and (b) SQL. State your assumptions if the semantics is not clear. 1) Find the names of all students who have not taken any courses. APPENDIX STUDENTS(student id, first_name, last _name, email, major_code, class_year) COURSES(course id, course_name, course_description, credits, department_code) ENROLLMENTS(student id, course id, semester, grade) MAJORS(major code, major_name, department_code) DEPARTMENTS(department code, department_name)
How to explain the view? "View" means what? Does view definition data exist in its format? What are the typical results of a view-based database access?
You receive the following requirements for a caterer's database: For a customer, store a customer ID, last name, first name, billing address, and phone number For an order, store an order number, order date, event date, customer ID, description of services, and total price for services When designing this database, which step do you take first? a. Identify the customer ID and order number as unique identifiers. b. Identify and name the entities CUSTOMER and ORDER c. Identify customer ID, last name, first name, billing address, and phone number as attributes d. Create a CUSTOMER table that includes all the customers' attributes as columns
Assume the e-commercial database shown in the Appendix. Write the following queries in (a) relational algebra and (b) SQL. State your assumptions if the semantics is not clear. 1) Find the names of all students who have taken courses in both the Computer Science and Mathematics departments. APPENDIX - You may detach this page from the exam: STUDENTS(student id, first_name, last _name, email, major_code, class_year) COURSES(course id, course_name, course_description, credits, department_code) ENROLLMENTS(student id, course id, semester, grade) MAJORS(major code, major_name, department_code) DEPARTMENTS(department code, department_name)
Complete a database design for both the Invoice_printed and Real Estate Agent Listings problems / cases. Display your normalized tables as as demonstrated in the following format: TABLENAME(Field 1 (pk), Field 2, Field 3........)
Q: 2. Create the database name Company which consists of one Entity name Employee which consists of 10 attributes (ID/First Name/Last Name/CNIC/Gender/Department/Sal ary/Address/Age) ID should be primary key Insert at least 10 records in the Entity Employee with respect to their type. a) Implementation the example of stored procedure now creates the stored procedure which: a. Have an ability to insert the record in the table. b. Have an ability to delete the record in table. c. Have an ability to update the record in the table. d. Have an ability to display the record in the table. |
Please provide a correct, clear answer for this SQL question 12)
(Q1) Begin with a table with all relevant columns and identify primary key(s). (Q2) Identify functional dependencies (full, partial, and transitive). (Q3) Remove the dependencies to decompose the table into a set of the third normal forms (NF3). (Q4) Create a relational model with normalized tables in 3NF using MySQL. Grade Report StudentID StudentName CampusAddress 168300458 Williams 208 Brooks 208 Brooks 168300458 Williams 543291073 Baker 543291073 Baker 104 Phillips 104 Phillips 543291073 Baker 104 Phillips Major CourselD IS 350 IS 465 IS 350 Acct 201 Mkgt 300 IS IS Acctg Acctg Acctg CourseTitle Database Mgt Systems Analysis Database Mgt Fund Acctg Intro Mktg Location Instructor Instructor Name Codd Parsons Codd Miller Bennett B 104 B 317 B 104 H 310 B 212 Grade A B C B A
I need the answer as soon as possible