Design a database for a world-wide package delivery company (e.g., DH, FedEX, UPS), with the following requirements.[1] The database must be able to keep track of customers who ship items The database must be able to keep track of customers who receive items Some customers may ship and receive items Each package must be identifiable and trackable. Thus the database must be able to store the location of a package, and its history of locations Locations include trucks, planes, airports, and warehouses

Design a database for a world-wide package delivery company (e.g., DH, FedEX, UPS), with the following requirements.[1] The database must be able to keep track of customers who ship items The database must be able to keep track of customers who receive items Some customers may ship and receive items Each package must be identifiable and trackable. Thus the database must be able to store the location of a package, and its history of locations Locations include trucks, planes, airports, and warehouses

Fundamentals of Information Systems

9th Edition

ISBN:9781337097536

Author:Ralph Stair, George Reynolds

Publisher:Ralph Stair, George Reynolds

Chapter3: Database Systems And Big Data

Section: Chapter Questions

Problem 2SAT

See similar textbooks

Similar questions

‘Problem 2: Data Modeling The recrultment agency TEMPO proposes intemship. employees for enterprises for a period of time. An internship employee is a temporary employee that will be recruited for a period of time. You must develop a database application in order to salisfy these: specifications: - The enterprises (id, name, address and phone number) define the posts for which they nead one or many employees. A post is defined with a label, a daily remuneration, the start date, the end cate and the number of employees for this post. A post needs eventually diploma(s) and a list of many skills. - Anintemship employee s described by a ssn, first name, last name, an address, a phone number, histher diplomas (we store for each diploma the year when it is obtained) and his/her skills. - An empioyee could be recruited for one or many posts. This recruitment of an employee for a given post is validated by a chief (ssn, first name, last name, address) designated by the enterprise. This chief…
A company database needs to store information about employees (identified by ssn, with salary and phone as attributes), departments (identified by dno, with dname and budget as attributes), and children of employees (with name and age as attributes). Employees work in departments; each department is managed by an employee; a child must be identified uniquely by name when the parent (who is an employee; assume that only one parent works for the company) is known. We are not interested in information about a child once the parent leaves the company. Draw an ER diagram that captures this information.
Draw an EER diagram for AIRLINE relational database. According to model, the following requirements are satisfied:The AIRLINE relational database schema shown in the above figure describes a database for airlineflight information. Each FLIGHT is identified by a Flight_number, and consists of one or moreFLIGHT_LEGs with Leg_numbers 1, 2, 3, and so on. Each FLIGHT_LEG has scheduled arrival anddeparture times, airports, and one or more LEG_INSTANCEs—one for each Date on which the flighttravels. FAREs are kept for each FLIGHT. For each FLIGHT_LEG instance, SEAT_RESERVATIONs are kept,as are the AIRPLANE used on the leg and the actual arrival and departure times and airports. AnAIRPLANE is identified by an Airplane_id and is of a particular AIRPLANE_TYPE. CAN_LAND relatesAIRPLANE_TYPEs to the AIRPORTs at which they can land. An AIRPORT is identified by an Airport_code.
Consider the following relational database for the Super Baseball League. It keeps track of teams in the league, coaches and players on the teams, work experience of the coaches, bats belonging to each team, and which players have played on which teams. Note the following facts about this environment: • Thedatabasekeepstrackofthehistoryofalltheteams that each player has played on and all the players who have played on each team. • The database only keeps track of the current team that a coach works for. • Team number, team name, and player number are each unique attribute across the league. • Coach name is unique only within a team (and we assume that a team cannot have two coaches of the same name). • Serial number (for bats) is unique only within a team. • In the Affiliation table, the Years attribute indicates the number of years that a player played on a team; the batting average is for the years that a player played on a team. Write SQL SELECT commands to answer the following…
Consider the following relational database for the Super Baseball League. It keeps track of teams in the league, coaches and players on the teams, work experience of the coaches, bats belonging to each team, and which players have played on which teams. Note the following facts about this environment: • Thedatabasekeepstrackofthehistoryofalltheteams that each player has played on and all the players who have played on each team. • The database only keeps track of the current team that a coach works for. • Team number, team name, and player number are each unique attribute across the league. • Coach name is unique only within a team (and we assume that a team cannot have two coaches of the same name). • Serial number (for bats) is unique only within a team. • In the Affiliation table, the Years attribute indicates the number of years that a player played on a team; the batting average is for the years that a player played on a team. Write SQL SELECT commands to answer the following…
Create the ER diagram and the database schema: Pick and Shovel Construction Company is a multi-state building contractor specializing inmedium-priced town homes. Assume that Pick and Shovel’s main entities are its customers, employees,projects, and equipment. A customer can hire the company for more than one project, and employeessometimes work on more than one project at a time. Equipment, however, is assigned to only one projectat a time.
Draw ER Diagram & Schema Diagram ================================ ER Diagram Description... During COVID-19 pandemic, it is not safe for the people to go out frequently for their daily needs. Similarly, people cannot live without their daily needs. ‘Online Sheba’ can minimize the suffering of people. ‘Online Sheba’ provides food delivery, emergency medicine delivery, laundry and grocery delivery. Besides, ‘Online Sheba’ provides courier services also. In this case, you have to build database management system for ‘Online Sheba’ to handle all the services it provides and to store all information related to ‘Online Sheba’ securely, like employee, customer, safety vehicle, shops, seller, receiver information. ‘Online Sheba’ provides few home services, food delivery, emergency medicine delivery, laundry, grocery delivery & courier service. Therefore, it must have few employees to initiate all the work. As COVID-19, safety issue is a very important factor; every employee must have a…
Using any diagramming software, create an ER Diagram for the following: A database is being constructed to keep track of the teams and games of a sports league. A team has a set number of players, not all of whom participate in each game. It is desired to keep track of the players participating in each game for each team, the position they played in that game, and the result of the game.
Please give a step-by-step answer. The ER Diagram must contain the ER-Diagram Symbols. Design an EER diagram for an Hotel Management System. The hotel wants to keep track of all their employees, customers, bookings, rooms and services. They have hired you to help them design the database for that purpose. You can design your EER as you wish, but it must satisfy the following constraints: a. there should be at least one overlapping-partial specialization/generalization. b. There should be at least five regular/strong entities [excluding subclasses] c. There must be a recursive relationship. d. There must be at least one 1:1 relationship. e. There must be at least one multivalued-composite attribute. Show all important attributes, entities and relationships in order to represent a clear and complete scenario. The EER diagram should be logically accurate and realistic, representing the database of the given scenario.
8.When constructing a database, the designer mustknow what types of relationships exist betweenrecords in different data sets, such as one-to-many or many-to-many. Give three examplesfor each of these relationships.
Consider an online auction database system in which members (buyers and sellers) participate in the sale of items. The data requirements for this system are summarized as follows: Members The online site has members who are identified by a unique member id and are described by an email address, their name, a password, their home address, and a phone number. Supertype and Subtypes for Members A member may be a buyer or a seller, but not both (disjoint subtype). A member must be one or the other (mandatory or required participation). A buyer has a shipping address recorded in the database. A seller has a bank account number and routing number recorded in the database. Both buyer and seller subtypes (entities) share the primary key with members which is membered. Items Items are placed by a seller for sale and are identified by a unique item number assigned by the system. Items are also described by an item title, an item description, a starting bid price, bidding increment, the start…
Construct an ERD for Leslie’s Auto Sales. Make sure to denote your primary and foreign keys. Note: Crow’s Foot Database Notation is required Question Leslie’s Auto Sales has a relational database with which it maintains data on its salespersons, its customers, and the automobiles it sells. areEach of these three entity types has a unique attribute identifier. The attributes that it stores are as follows: a. Salesperson Number(unique), SalespersoMaken Name, Salesperson Telephone, Hire Date b. Customer Number(unique), Customer Name, Customer Address, Value of Last Purchase c.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. Make sure to denote your primary and foreign keys. Crow’s Foot Database Notation is required.Construct an ERD for Leslie’s Auto Sales. Make sure to…