1. Implement the designed database using MS SQL.1.1. Implement all tables1.2. Save all SQL statements1.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 sexnamebirth_daterelationshipnamebudgetlocationDEPENDENTPROJECTstart_datehoursNNWorksM/NDependentsofAssignedtostart_datessn11(birth_datestatusNEmployed 1sexΕMPLOYE ΕsalaryDEPARTΜΕNTaddressnamename1first_nameManageslocationssupervisorsuperviseemiddle_initiaNlast_name1number_of_employees,Supervisionstart_date TakeltAll Inc is a wholesaler company that has just opened up for business. They sell all kindsof technology devices at their store, ranging from graphics cards to fully kitted gamingmotherboards. 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 informationstored 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 thepurchases made by their clients. Purchases made by clients are shown in invoices that list allthe client's products and the quantities of each product. The price at which a product wasbought 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 informationsystem. Namely sales agents and product managers. Each employee can either be a salesagent or product manager and not both. All of TakeltAll's sales agents are evaluated by thenumber of invoices they process per month. Therefore, for all invoices made for clients, theyhave 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 byTakeltAll (such as Cameras, Kitchen Appliances, Toys, etc.). Therefore, they have asked youto 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 thetables you create in line with the discussion above.1. Illustrate a conceptual design of the database by means of an Extended EntityRelationship Diagram (EER).1.1. You may use any tool to draw the ER diagram.

Answered: 1. Illustrate a conceptual design of…

1. Illustrate a conceptual design of the database by means of an Extended Entity Relationship Diagram (EER). 1.1. You may use any tool to draw the ER diagram.

Principles of Information Systems (MindTap Course List)

13th Edition

ISBN:9781305971776

Author:Ralph Stair, George Reynolds

Publisher:Ralph Stair, George Reynolds

Chapter12: System Acquisition And Development

Section: Chapter Questions

Problem 3PSE: A new sales ordering system needs a relational database that contains a customer table, a product...

See similar textbooks

Similar questions

A new sales ordering system needs a relational database that contains a customer table, a product inventory table, and an order table. Use a word-processing, graphics, or spread-sheet program to draw an entity-relationship diagram showing the relationships among these entities. Next, design each of these tables showing the keys and attributes to be included in each table. Include five sample records for each table.
I understand the intentions of a database, being to streamline the data record-keeping of any organizations. And I understand the hardware needed to do such. The area I find myself the most lost in is the idea of programming the rules and structure of a database. In my head a database is a chart (or multiple charts) with fields that is used to store records. And then those records stored in one chart intertwine with other charts of course so we need to have relationships between the charts. Where I get lost is in the thought of programming a structure for the data to fit in. Are we making metaphysical locations to store data or are we just writing relationshipds between data that is stored on a plethora of different options?
You are the CTO of a startup based out of Arlington, VA that needs to setup a database to keep track of the details of the customers: last name, ﬁrst name, customer ID, street address, customer star rating (a rating on a 1 – 5 scale, with 5 being best, representing the type of customer) and phone number. It also needs to keep track of similar information for suppliers as well (although instead of supplier ﬁrst and last name, there will just be a supplier company name). The database should maintain the data on products that are oﬀered. Information about which product is oﬀered by which supplier should also be maintained. Finally, which customers have purchased which products should also be tracked (note that we are only interested in which customers bought which product, but not concerned about the date or how many were bought).1.1 Business RulesAssumptions for the business model are as follows: • Only customers that have purchased one or more products will exist in the database. • Only…
You are the CTO of a startup based out of Arlington, VA that needs to setup a database to keep track of the details of the customers: last name, first name, customer ID, street address, customer star rating (a rating on a 1 – 5 scale, with 5 being best, representing the type of customer) and phone number. It also needs to keep track of similar information for suppliers as well (although instead of supplier first and last name, there will just be a supplier company name). The database should maintain the data on products that are offered. Information about which product is offered by which supplier should also be maintained. Finally, which customers have purchased which products should also be tracked (note that we are only interested in which customers bought which product, but not concerned about the date or how many were bought). 1.1 Business Rules Assumptions for the business model are as follows: Only customers that have purchased one or more products will exist in the database.…
An unusual problem has occurred for a small multinational company: People are getting confused about dates in internal memos, purchase orders, and email. When the company’s database was originally designed, the designer was not aware that the format for dates in Canada and Mexico was different from the format used in the United States. For example, in Canada and Mexico, the notation 7/1/19 indicates January 7, 2019, whereas in the United States the same notation indicates July 1, 2019. Although it seems like a small point, the date confusion has resulted in several order cancellations. How would you fix this issue in the database?
You are a database consultant with Ace Software, Inc., and have been assigned to develop a database for the Johnson Video Store in town. The owners have been keeping their records of videos and DVDs purchased from distributors and rented to customers in stacks of invoices and piles of rental forms for years. They have finally decided to automate their record keeping with a relational database. You sit down with the owners to discuss their business and watch their operation for about a week. You discover quickly that a video and a DVD are both copies of a movie kept in a separate plastic case that is rented out. They have several copies of each movie they rent; therefore, there are several videos and DVDs for each movie title. You learn that in their inventory they have several thousand videos and DVDs, which they get wholesale from about a half dozen distributors. The video and DVD prices for them are based on the quantity of their shipment and the past business they have done with…
I understand the purpose of a database, which is to make data record-keeping easier for any company. And I'm aware of the hardware requirements. The concept of programming the rules and structure of a database is the area in which I am most confused. A database, in my mind, is a chart (or many charts) containing fields that are used to hold records. Then, of course, those records in one chart interweave with those in other charts, necessitating the creation of chart linkages. The concept of developing a framework for the data to fit into is where I get stuck. Are we creating metaphysical venues to store data, or are we just recording relationships between data saved on a variety of platforms?
Your Division Head's point of view is as follows: "Pictures are stored in a database, and the basic design/structure we chose includes some very sensitive driver information." What if we placed it in its own folder, out of reach of people who shouldn't have access to it? What would your stance be, or, more precisely, which strategy would you prefer? It is necessary to present justification.
suppose you are planning to develop a database where you store information about the students, courses and student grades. This is a very simple database - but would help us to learn several important concepts. How would you design and implement the database?
Dr. Jones, knowing that you are an intuitive database design student, has come to you with a possible database solution for his medical practice. He is interested in storing data related to his patients and the medications that they take. He specifically would like to keep track of the drug names, the drug price, the dosage each patient takes, and the dates that the medications were prescribed. He needs to be able to pull patient data quickly to make sure that each patient is taking the least medication to help their illness. Create business rules that might go with this scenario. Keep in mind that nouns (subjects) will become entities and their characteristics attributes. Verbs will translate into the relationships between entities. Create the ER diagram using Visio that would go with this scenario. Be sure to include entities, attributes, keys, and relationships using the crow’s feet notation
Air-india want to create database to stores details about an airline’s fleet, flights, and seat bookings. Again, it’s a hugely simplified version of what a real airline would use, but the principles are the same. Draw an ER diagram based on the information given.Consider the following requirements list: • The airline has one or more airplanes.• An airplane has a model number, a unique registration number, and the capacity to take at most 100 passengers.• An airplane flight has a unique flight number, a departure airport, a destination airport, a departure date and time, and an arrival date and time.• Each flight is carried out by a single airplane.• A passenger has given names, a surname, and a unique email address.• A passenger can book at most 5 seats on a flight.[7](b) Convert the diagram 1(a) in relational model.
Think of a database that would be needed at a professional service firm to maintain the contact list of clients/patients at the office of a CPA, attorney, or medical doctor. Identify the fields likely to be used in this database. If one person were constructing this database, how many spaces would it allow for each field?