Part B Create the entities, subtypes, and relationships according to the business rule below. Then map the entities identified into tables. Do these in SQL developer. BUSINESS RULE: A Seller can be categorized as Retailer or Wholesaler. All sellers have a seller id, first name, last name, contact no and maximum credit. A retailer has a RetailPrice, while a Wholesaler has a WholeSalePrice. Each seller should be categorized only to either a retailer or a wholesaler and cannot be a retailer and a wholesaler at the same time. A seller can have one or more shops and shops must be owned by a seller. A shop can contain many products and many products must be found in at least one shop or more shops. Products Shops price type manufacturer address name

Part B Create the entities, subtypes, and relationships according to the business rule below. Then map the entities identified into tables. Do these in SQL developer. BUSINESS RULE: A Seller can be categorized as Retailer or Wholesaler. All sellers have a seller id, first name, last name, contact no and maximum credit. A retailer has a RetailPrice, while a Wholesaler has a WholeSalePrice. Each seller should be categorized only to either a retailer or a wholesaler and cannot be a retailer and a wholesaler at the same time. A seller can have one or more shops and shops must be owned by a seller. A shop can contain many products and many products must be found in at least one shop or more shops. Products Shops price type manufacturer address name

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

Write SQL Queries for following set of tables:EMPLOYEE (EmpNo, Name, DoB, Address, Gender, Salary, DNumber)DEPARTMENT (DNumber, Dname, ManagerEmpNo, MnagerStartDate).i) Display the Age of ‘male’ employees.ii) Display all employees in Department named ‘Marketing’.iii) Display the name of highest salary paid ‘female’ employee.iv) Which employee is oldest manger in company?v) Display the name of department of the employee ‘SMITH’..
https://sqliteonline.com/ : Program link The first requirement: Using the SQL language, transform the following entity model into tables in the database. Entity Manger contains: M-name The name of the manager. M-ID and manager number.The department entity contains: D-name The name of the department. D-ID and department number.Create constraint master key name of the manager when creating the Manger table.Creating the foreign key constraint The name of the manager when creating the Department table. The second requirement: After creating the tables and specifying the primary and foreign key, do the following: * Add a column D_loc to the Department table, specifying the type of column.* Remove the column named M_name from the Manger table* Change the name of the department table to Dep Please:: ******* ATTACH A PICTURE OF THE CODES USED AND PICTURE OF THE PROGRAM SCREEN *******
Write SQL queries DDL Queries to implement the following Relational Model i.e. create the Nurse and Care_Center relations (including primary key and foreign key). Intelligently write data types.
Consider Following Tables.Student ( regNo, sName, sCity, sCGPA, sAge)Course ( cCode, cName, credit_hours)Enrollment (regNo, cCode, semester, Grade)Write SQL queries for the following statements.NOTE: you must use “JOINS” query only.i. Display names of all those students who have “A” grades.ii. Display list of all students by name and course name they have enrolled.iii. Display data of all those students who have enrolled at least 10 courses.iv. Display all those students who have not enrolled any course yet.v. Display grade of ‘Ali’ in course ‘CS101’.
Using the EMPLOYEE, JOB, and PROJECT tables in the Ch07_ConstructCo database, write the SQL code that will join the JOB, EMPLOYEE, and PROJECT tables using common attributes. Display the attributes shown in the results presented in Figure P7.2, sorted by project value.
Convert the following ER diagram into relational schema. Write the relational schema in SQL.
Write the syntax to create a table named Product in SQL with the following restrictions; Product(pid, pname, price, packaging, colour, manufacture_date, supplier, country_manufacture) Where pid is the primary key. pname and manufacture_date do not accept null values. price is greater than Rs 350. packaging accepts only box or bag entries. The default colour is “Red”.
HR wants to send the completed budget reports to the various department managers. To do so, they need a current listing of the department managers to contact. For this query, the HR department needs the department name, manager first name, manager last name, and job title. The results must be sorted by department name and include the elements in the order listed. This needs to be done in SQL
Write PL/SQL coomands for the following question5. Table student( name,age,inter_mark,entrance_rank,address,contact_no,ID,branch)Admission( college_name,mode( pay/free/star/NRI), date,ID)a) Write a query to display the students who are all admitted on starmode branchwiseb) Display the college under which maximum NRI student admittedc) Display the college which got minimum free students and atmost one NRI studentd) Display the student who got second maximum rank admission detailse) Display the students category wise admission detailsf) Write a plsql routine to check a perfect square number is the given number.
This is in sql. For all artists who are currently in a band: Return the artist’s full name (as a single value), the band name, and how long in years the artist has been in the band. The artist should only be shown once for each band. (Hint: Remember that the data might include an artist who left a band and then rejoined. That is the challenge here!) Tables with values are in image.
Below are three tables and their attributes: Table 1: customers ( CustomerID, CustomerName, City, Country) Table 2: orders ( OrderID, ProductID, CustomerID) Table 3: products (ProductID, ProductName, Price, SupplierID) Can you come up with a SQL statement to find all customers who ordered products from a supplier whose SupplierID is '222'. Remove duplicates
Using the Online SQL Editor, answer the following questions with screenshots. Link: https://www.programiz.com/sql/online-compiler/ Question 1: Show (in one table) customer id and first name from Customers table together with shipping id and status from Shippings table while assigning them, within the SQL code, the aliases CT and ST, respectively. *CT for Customers table and corresponding columns*ST for Shippings table and corresponding columns Question 2: Show customer id, item, and amount from Orders table together with the last name and age from Customers table whose age is 25 and above. Question 3: Create a new table named Suppliers, with the following columns: Supplier id, first name, last name, age, and country. Limit first name and last name to 40 characters, country to 15 characters, and age to 3 characters.