Step 1. Draw an ER diagram for the story below. Use the ERD tool only. Draw Relations in Oracle notation. Please read the story carefully. Use the mentioned Entities ONLY. The company sells various Products to Customers. The Sales Agent books an Order. A new order is created for each Product. While booking an Order, Agent records Order Date, Product, Customer, Product Quantity, and Sales Agent. Product has Description and UnitPrice. Each Agent reports to a Manager. A Manger has a Name and Commission Percent.

Step 1. Draw an ER diagram for the story below. Use the ERD tool only. Draw Relations in Oracle notation. Please read the story carefully. Use the mentioned Entities ONLY. The company sells various Products to Customers. The Sales Agent books an Order. A new order is created for each Product. While booking an Order, Agent records Order Date, Product, Customer, Product Quantity, and Sales Agent. Product has Description and UnitPrice. Each Agent reports to a Manager. A Manger has a Name and Commission Percent.

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

Please follow this ER diagram, give a description, and make a schema diagram from it. Also, make database (constraint tables) & intent some sample data. Lastly, run some SQL functions code. Please don't copy from anywhere. I need it for my project.
Query design by referring the following scenario.Scenariocompany has a huge database to handle their employees’ details.Most of the details regarding the employee activities and department details are stored in Employeestable and Departments table. Write the appropriate query to support the manager to complete thefollowing:
Create tables for the following, where the first 2 are entity-types and the last one is relationship. Feel free to add additional fields that you think are appropriate.Course: courseNum, department, semester, maximumEnrolled Instructor: ssn, instructorid, firstName, lastName.Teaches: instructorid, courseNumPay special attention to assigning primary key and foreign key in each table and use appropriate data types.Print out the SQL commands that you use to create the tables.Then populate your tables with at least 2 rows each and print out the contents of each table with SELECT. (Include the content of the print-out in your homework).
Create tables for the following, where the first 2 are entity-types and the last one is relationship. Feel free to add additional fields that you think are appropriate.Course: courseNum, department, semester, maximumEnrolled Instructor: ssn, instructorid, firstName, lastName.Teaches: instructorid, courseNumPay special attention to assigning primary key and foreign key in each table and use appropriate data types.Print out the SQL commands that you use to create the tables.Then populate your tables with at least 2 rows each and print out the contents of each table with SELECT. (Include the content of the print-out in your homework). I want answers for this part Get to know the HR database, its tables, and their contents. Show the SQL query and the output.Use INNER JOIN for multiple table query.1- Display details of jobs where the minimum salary is greater than 10000.2- Display the first name and join date of the employees who joined between 2002 and2005.3- Display first name and join…
If an employee can work for only one department and a department can have many employees (one to many relationship). Which answer the relationship table "work" that has the best values to describe the relationship between employee and department? The employee table has two columns (eid, name) with records ('E1','A'), ('E2','B'), ('E3','C'). The department table has two columns (did, name) with records ('D1','X'), ('D2','Y'), ('D3', 'Z'). work(eid, did) with values ('E1','D1'), ('E1','D2'), ('E2,'D2'). work(eid, did) with values ('E1','D1'), ('E2','D2'), ('E3,'D2'). work(eid, did) with values ('E1','D1'), ('E2','D2'), ('E2,'D3'). work(eid, did) with values ('E1','D1'), ('E2','D2'), ('E3,'D3').
Query design by referring the following scenario.Scenariocompany has a huge database to handle their employees’ details.Most of the details regarding the employee activities and department details are stored in Employeestable and Departments table. Write the appropriate query to support the manager to complete thefollowing:
Implement a new independent entity phone in the Sakila database. Attributes and relationships are shown in the diagram below The diagram uses Sakila naming conventions. Follow the Sakila conventions for your table and column names: All lower case Underscore separator between root and suffix Foreign keys have the same name as referenced primary key Write CREATE TABLE and ALTER TABLE statements that: Implement the entity as a new phone table. Implement the has relationships as foreign keys in the Sakila customer, staff, and store tables. Remove the existing phone column from the Sakila address table. Step 2 requires adding a foreign key constraint to an existing table. Ex: ALTER TABLE customer ADD FOREIGN KEY (phone_id) REFERENCES phone(phone_id) ON DELETE SET NULL ON UPDATE CASCADE; Specify data types as follows: phone_id, phone_number, and country_code have data type INT. phone_type has date type VARCHAR(12) and contains strings like 'Home', 'Mobile', and 'Other'. Apply these…
Write the relations clearly showing the Primary key bolded and underlined (e.g., CustomerId). Foreign key shown in italics (e.g., OrderNumber) and separately defined beneath the relation (e.g., ShoppingCart OrderNumber FK to Order OrderNumber)
write the sql queries for the following er diagram: Create all the tables and relationships (including all primary keys, foreign keys, attributes and appropriate data types) shown in the ER diagram above.and Insert 3 records into each table. In the Item table, consider the first record as your favorite dress, second record as a gift that you have recently bought to someone, and the third record as your most favorite accessory that you are currently using; then insert the appropriate data. Similarly, insert some valid data into the other three tables. and Write an SQL statement to update the third row of Item table: Item_Name as ‘Hat’, Brand as ‘Puma’, and Type as ‘Ferrari’. and Write an SQL statement to display the Branch_ID, Location_ID, Item_ID, Units_Sold and Dollars_Sold of each customer. Results should be in a descending order of Item_ID.and also Write an SQL statement that displays the number of items, the sum of units_Sold and the sum of dollars_sold in each location. (Hint: Use…
Write SQL statements for the five queries: (a) Show the id and name of the feedback activity, and the id, short name, and full name of the course the feedback activity belongs to (across all feedback activities for your site). (b) Show the id, name, presentation, and type (numeric, textarea, textfield, etc.) for the feedback items for two of your feedback activities (specify these feedback activities in your query). (c) Show how many feedback activities are provided for your site. In the same query also show the number of courses that have feedback activities (e.g., there could be 5 activities across 2 courses for your site; The query is asking for two numbers.). (d) Present which of the users has provided feedback on which feedback activity. Show the name of the feedback activity and the first and last name of the user. Arrange the query results in the order of the feedback activity name, and then the user's last name. (e) Show the information about feedback items and the…
Based on the ER design create the schema for your online auction database, apply some combination of translating the ER components to relations and normalization. Provide SQL statements to create all of the relations in your database.
Convert the following table to third normal form (3NF). In this table, StudentNum determines StudentName, NumCredits, AdvisorNum, and AdvisorName. Advisor Num determines AdvisorName. CourseNum determines Description. The combination of StudentNum and CourseNum determines Grade. STUDENT (StudentNum, StudentName, NumCredits, AdvisorNum, AdvisorName, CourseNum, Description, Grade). Identify the primary key for the original table and the primary keys for the resulting tables. Indicate the foreign keys with italic font. Give meaning names to the resulting tables.