Implement the designed database using MS SQL. 1.1. Implement all tables 1.2. Save all SQL statements 1.3 Enter data to show your database is appropriately designed. You may enter the data directly into MS SQL. - At least five records in each table

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
icon
Related questions
icon
Concept explainers
Question
100%

1. Implement the designed database using MS SQL.
1.1. Implement all tables
1.2. Save all SQL statements
1.3 Enter data to show your database is appropriately designed. You may enter the data directly into MS SQL.
- At least five records in each table

TakeltAll Inc is a wholesaler company that has just opened up for business. They sell all kinds
of technology devices at their store, ranging from graphics cards to fully kitted gaming
motherboards. To help them develop the information system needed for their sales operations,
they have hired you to design their database.
They currently keep a wide variety of products at their warehouse. The usual information
stored for each product includes name, manufacturer, and price, etc...
Apart from keeping track of their products, they would like you also to keep track of the
purchases made by their clients. Purchases made by clients are shown in invoices that list all
the client's products and the quantities of each product. The price at which a product was
bought should also be recorded at the purchase of the products.
TakeltAll has two types of employees they would like to keep track of in their new information
system. Namely sales agents and product managers. Each employee can either be a sales
agent or product manager and not both. All of TakeltAll's sales agents are evaluated by the
number of invoices they process per month. Therefore, for all invoices made for clients, they
have asked you to have a way to keep track of which sales agent assisted the client.
Each product manager is in charge of a single category of technology products offered by
TakeltAll (such as Cameras, Kitchen Appliances, Toys, etc.). Therefore, they have asked you
to keep track of the product category that each product manager manages.
As this information system is new, TakeltAll would like you to suggest attributes for each of the
tables you create in line with the discussion above.
Transcribed Image Text:TakeltAll Inc is a wholesaler company that has just opened up for business. They sell all kinds of technology devices at their store, ranging from graphics cards to fully kitted gaming motherboards. To help them develop the information system needed for their sales operations, they have hired you to design their database. They currently keep a wide variety of products at their warehouse. The usual information stored for each product includes name, manufacturer, and price, etc... Apart from keeping track of their products, they would like you also to keep track of the purchases made by their clients. Purchases made by clients are shown in invoices that list all the client's products and the quantities of each product. The price at which a product was bought should also be recorded at the purchase of the products. TakeltAll has two types of employees they would like to keep track of in their new information system. Namely sales agents and product managers. Each employee can either be a sales agent or product manager and not both. All of TakeltAll's sales agents are evaluated by the number of invoices they process per month. Therefore, for all invoices made for clients, they have asked you to have a way to keep track of which sales agent assisted the client. Each product manager is in charge of a single category of technology products offered by TakeltAll (such as Cameras, Kitchen Appliances, Toys, etc.). Therefore, they have asked you to keep track of the product category that each product manager manages. As this information system is new, TakeltAll would like you to suggest attributes for each of the tables you create in line with the discussion above.
Name
belongs to
CategoryID
Description
ProductID
(1,)
ProductCategory
Name
JoiningDate
(1,M)
Name
(1,1)
UnitPrice
Product
Salary
EmployeelD
(1,M)
Manufacturer
Employee
Quantity
managed by
disjoingmeans one
employee belongs to one
sub type
includes
UnitPrice
(1,1)
(0,N)
ProductManager
(1,1)
InvoicelD
Purchase
SalesAgent
(QM)
Client
SpecialtyExperien
(AvgSalePerMonth)
TotalSales
ThisMonth
ce
TotalAmount
PurchaseDate
derived attribute
processed by
Transcribed Image Text:Name belongs to CategoryID Description ProductID (1,) ProductCategory Name JoiningDate (1,M) Name (1,1) UnitPrice Product Salary EmployeelD (1,M) Manufacturer Employee Quantity managed by disjoingmeans one employee belongs to one sub type includes UnitPrice (1,1) (0,N) ProductManager (1,1) InvoicelD Purchase SalesAgent (QM) Client SpecialtyExperien (AvgSalePerMonth) TotalSales ThisMonth ce TotalAmount PurchaseDate derived attribute processed by
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Query Syntax
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education