hi there tutors! im here to cure my doubts.i hv 3 sub questions to ask. must be based on the scenario given in text & clear explanation.Required:A. According to the situation above, state TWO (2) possible Entity with FOUR (4) Attributefor each entity that might be involved in the development of the system.B. Discuss the relevant FIVE (5) hardware and software, which would be required for higherefficiency of the company’s activities.C. Based on real world examples provide any FIVE (5) places of database that being used. Sporting Goods Direct (SGD) is a directly selling catalogue based retailer of Sporting Equipment.Customers select the items and complete an order form, which is processed by SGD. RecentlySGD has seen a considerable growth in the business with lot more sales than the first quarter ofthe year 2015. Demand for their stock have grown, therefore they need a well-designed relationaldatabase for stock maintenance and customer record purposes. Sporting Goods Direct sells manyItems under many Categories:i. Menii. Womeniii.iv. FootwearChildrenClothesAccessories etcV.Vi.The minimum details to be stored for each item are Item ID, Item Name, Category, Description,Price, Quantity, and Re-order Quantity. The Customers need to register before being able topurchase an item. The information customers must provide are:• First Name• Last Name• Date of Birth• Email• Contact Number• AddressMany Suppliers can supply items sold in the store and one supplier can supply many items. Eachitem is supplied at a particular price. The store needs to record details of each supplier in thedatabase. The respective details are: Supplier ID, Supplier Name, Address and Contact Number.All transactions between the store and the supplier need to be recorded.Sporting Goods Direct needs to maintain and record all the Orders made with details like ItemOrdered, Quantity Ordered, Order Date, and Total Amount. Their system later generates an orderform, which contains Order Number, Item Code(s), and the Quantity Ordered.

The two possible entities in the above scenario could be Customer Supplier The four attributes…

A. According to the situation above, state TWO (2) possible Entity with FOUR (4) Attribute for each entity that might be involved in the development of the system. B. Discuss the relevant FIVE (5) hardware and software, which would be required for higher efficiency of the company’s activities. C. Based on real world examples provide any FIVE (5) places of database that being used.

A. According to the situation above, state TWO (2) possible Entity with FOUR (4) Attribute for each entity that might be involved in the development of the system. B. Discuss the relevant FIVE (5) hardware and software, which would be required for higher efficiency of the company’s activities. C. Based on real world examples provide any FIVE (5) places of database that being used.

Principles of Information Systems (MindTap Course List)

13th Edition

ISBN:9781305971776

Author:Ralph Stair, George Reynolds

Publisher:Ralph Stair, George Reynolds

Chapter5: Database Systems And Big Data

Section5.4: Big Data

Problem 2CTQ

See similar textbooks

Similar questions

In ZIMS store the manager is interested in determining which items sell well together. Themanager assigned you this task and you opted for using Apriori Algorithm for finding thefrequent item sets and association rules.You set the following threshold parameters for given sales transactional database:Support: 0.4Confidence: 0.9The sales transactional database available to you in Table 2.1:Present your findings to the manager showing detailed workings and outcome of the process.Table 2.1Sales ID ItemsS1 {O,W,C,N,Z}S2 {O,C,K,N,Z}S3 {K,N,W,Z,O}S4 {K,W,Z,O}S5 {C,K,N,Z}S6 {O,K,N}S7 {O,N,W,Z}S8 {K,N,Z}
Leslie’s Auto Sales has a relational database with which it maintains data on its salespersons, its customers, and the automobiles it sells. Each of these three entity types has a unique attribute identifier. The attributes that it stores are as follows: Salesperson Number (unique), Salesperson Name, Salesperson Telephone, Years with Company Customer Number (unique), Customer Name, Customer Address, Value of Last Purchase From Us Vehicle Identification Number (unique), Manufacturer, Model, Year, Sticker Price Leslie’s also wants to keep track of which salesperson sold which car to which customer, including the date of the sale and the negotiated price. Construct an ERD for Leslie’s Auto Sales. Crow’s Foot Database Notation is required.
Exercise 3 Manufacturer A manufacturing company produces products. The following product information is stored: product name, product ID and quantity on hand. These products are made up of many components. Each component can be supplied by one or more suppliers. The following component information is kept: component ID, name, description, suppliers who supply them, and products in which they are used. Create an ERD to show how you would track this information. Show entity names, primary keys, attributes for each entity, relationships between the entities and cardinality. Assumptions A supplier can exist without providing components. A component does not have to be associated with a supplier. A component does not have to be associated with a product. Not all components are used in products. A product cannot exist without components. List of Entities and the Attributes List of Relationship and Cardinalities Draw the Conceptual Model Draw the Logical Model with…
Database Patterns:Consider the following example... what type of relationship is this "A part can have many suppliers and a supplier can provide many parts" which of these options? 1:1 Strong 1:N Strong 1:N ID-dependent Weak 1:N Non ID-dependent Weak N:M
The following figure shows a shipping ticket sent to a customer. Draw an ERD reflecting the data contained in the shipping ticket. Note:(1) The ERD must have Customer (Customer ID as the PK), Manufacturer (Manufacturer Name asthe PK), SalesOrder, Product and many other entities.(2) Assume that there is only one customer and one sales manager for each order.(3) No need to create a Recipient entity; recipient information must be attributes of SalesOrder.(4) The database must include unit price change history of products. (Hint: Create a ProductPrice entity to record all prices of products) The ERD must include not only entities and relationships with cardinalities but also all attributes.Underline the primary key. There must be no many-to-many relationships and no multi-valuedattributes. Enter all foreign keys in the ERD.
“Martial Arts R Us” (MARU) needs a database. MARU is a martial arts school with hundreds of students. The database must keep track of all the classes that are offered, who is assigned to teach each class, and which students attend each class. Also, it is important to track the progress of each student as they advance. 1.Create a complete Crow’s Foot ERD for these requirements: 2.Create a relational diagram for the data model. 3.Draw the dependency diagram showing partial and transitive dependency(if any). 4. Normalize the tables to 3NF. 5. Show the dependency diagram after normalization. 6. Use SQL to create all tables in Access. Do not forget FK,PK 7. Create relationships.
Functional Dependency & Normalization The table below lists customer/car hire data. Each customer may hire cars from various outlets throughout Glasgow. A car is registered at a particular outlet and can be hired out to a customer on a given date. carReg make model custNo custName hireDate outletNo outletLoc M565 0GD Tesla Model S C100 Smith, J 5/14/2018 101 San Francisco M565 0GD Tesla Model S C201 Helena, P 5/15/2016 101 San Francisco N734 TPR Nissan Sunny C100 Smith, J 5/16/2016 101 San Francisco M134 BRP Tesla Model S C313 Blatt, O 5/14/2018 102 Los Angeles M134 BRP Tesla Model S C100 Smith, J 5/20/2018 102 Los Angeles M611 0PQ Nissan Sunny C295 Alice, T 5/20/2018 102 Los Angeles Fig: Table 1 Identify the functional dependencies represented by the data shown in the table above. State any assumptions you make about the data. Using…
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.
A public sector hospital wants to automate its manual paper based operations to speed up the operations and facilitate its patients and staff members. For this purpose, they want to develop a database for their hospital management system to remove paper based records. Now, you are required to analyze the following scenario very carefully and draw entity relationship diagram (ERD) for the given system by identifying entities, attributes and relationship among these entities. A hospital consists of various specialized wards where each ward has its unique ID, name and capacity (total number of beds for patients in each ward). Multiple patients can be admitted in each ward on the recommendations of the doctor. Each doctor has a unique id, name, specialization and etc. Furthermore, a specialized team of doctors in each ward will take care of admitted patients and suggest treatment for the patients (such as medication, recommended tests, date of admission, and date of discharge). Each ward…
Given the following business scenario, create a Crow’s Foot ERD using a specialization hierarchy if appropriate for one case study.DB for Railway ReservationPurpose: The Database is for a railway reservation system which facilitates the passengers to enquire about the trains available on the basis of source and destination, booking and cancellation of tickets, enquire about the status of the booked ticket, etc. The database is for maintaining the records of different trains, train status, and passengers. The record of train includes its number, name, source, destination, and days on which it is available, whereas record of train status includes dates for which tickets can be booked, total number of seats available, and number of seats already booked.Passengers can book their tickets for the train in which seats are available. For this, passenger has to provide the desired train number and the date for which ticket is to be booked. Before booking a ticket for a passenger, the validity…
Database Which query in this relational database (represented by relational diagram) will provide you with the list of the 3 most transported products by shipper DHL in January 2020? Select one: a. SELECT TOP(3) p.ProductName, COUNT(od.Quantity) FROM Products p INNER JOIN [Order Details] od ON p. ProductID = od. ProductiD INNER JOIN Orders o ON od.OrderID = o.OrderID WHERE o. ShipVia = 'DHL' AND .ShippedDate > '01-01-2020' AND o.ShippedDate < '31-01-2020' GROUP BY p.ProductID, o.ShipVia ORDER BY COUNT (od.Quantity) DESC b. SELECT TOP (3) p.ProductID, p.ProductName, SUM(od.Quantity) FROM Products p LEFT JOIN [Order Details] od ON p.ProductID = od.ProductiD LEFT JOIN Orders o ON od.OrderID = o.OrderID LEFT JOIN Shippers s ON o.ShipVia = s.ShipperID WHERE S.CompanyName LIKE 'DHL' AND MONTH(o.ShippedDate) = 1 AND YEAR (o.ShippedDate) = 2020 GROUP BY od.ProductiD, o.ShipAddress ORDER BY SUM(od.Quantity) ASC C SELECT TOP (3) p.ProductID, p.ProductName, COUNT(od.Quantity) FROM…
Note: This question has been rejected three times now saying the question is incomplete. That's how the question is. Please do not reject it saying it is incomplete. The previous 4 questions were related. I was asked to provide question 3 but I will provide all of them. Question 1: Create the Entity Relationship (ER) Diagram for the following scenario. We want to maintain a database for a Faculty within a multi-campus regional university. The faculty has a number of schools and each school is characterized by its school-code which is unique, name and campus location. Schools employ professors who are characterized by their unique staff-id, name and the school they work for. A school offers courses that are characterized by their course-code which is unique, course name and the school. There are subjects offered within the faculty and these arecharacterized by unique subject-code, title and the school that offers them. Students enroll into courses that are characterized by student-id…