Homework Help is Here – Start Your Trial Now!
Engineering
Computer Engineering
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

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

Computer Networking: A Top-Down Approach (7th Edition)
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
See similar textbooks
icon
Related questions
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 d (1,1) (0,N) ProductManager (1,1) InvoicelD Purchase SalesAgent &M) Client SpecialtyExperien (AvgSalePerMonth) ce TotalSales ThisMonth 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 d (1,1) (0,N) ProductManager (1,1) InvoicelD Purchase SalesAgent &M) Client SpecialtyExperien (AvgSalePerMonth) ce TotalSales ThisMonth TotalAmount PurchaseDate derived attribute processed by
Expert Solution
steps

Step by step

Solved in 4 steps with 8 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY
SEE MORE TEXTBOOKS