Database Systems: Design, Implementation, & Management
12th Edition
ISBN: 9781305627482
Author: Carlos Coronel, Steven Morris
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Expert Solution & Answer
Chapter 5, Problem 6P
Explanation of Solution
Crow’s Foot ER diagrams for Tiny College IT Staffing Solution:
The following data model shows the solution for the given question.
Explanation:
- In the above data model, the overlapping constraint (o) is used as a category symbol. Here the “Employee” supertype entity has optional subtype entity. The primary of “Employee” entity is “Emp_No”.
- The “Professor”, “Staff” and “Admin” are the subtype entities...
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
Q2:
To answer this question, let's take an example of a university faculty with six professors (3 men and 3 women). Professors are ranked from lowest to highest, with 1 being the lowest and 3 being the highest. The male professors are identified as Rao (1), Lalit (3) and Ahmed (2). The Professor's names with their ranks are Monu (3), Rana (1), and Kitty (2). Below are some examples of situations. For each example, provide an ASN.1 description of the record values and their corresponding data types. Consider the ProfessorData data type, which contains details about each professor.
An alphabetical list of professors.
A list of professors in descending order.
There are two sets of professors, each of which consists of a higher-ranking female professor and a male professor of a lower level.
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.
Instead of adopting the snowflake model, you may write forth the benefits and drawbacks of using the star schema instead. Which one deviates from the norm more so than the other?
Chapter 5 Solutions
Database Systems: Design, Implementation, & Management
Ch. 5 - Prob. 1RQCh. 5 - What kinds of data would you store in an entity...Ch. 5 - Prob. 3RQCh. 5 - What is a subtype discriminator? Give an example...Ch. 5 - Prob. 5RQCh. 5 - What is the difference between partial...Ch. 5 - Prob. 7RQCh. 5 - According to the data model, is it required that...Ch. 5 - Prob. 9RQCh. 5 - Prob. 10RQ
Ch. 5 - Prob. 11RQCh. 5 - Prob. 12RQCh. 5 - Prob. 13RQCh. 5 - When implementing a 1:1 relationship, where should...Ch. 5 - What is time-variant data, and how would you deal...Ch. 5 - Prob. 16RQCh. 5 - Prob. 1PCh. 5 - Prob. 2PCh. 5 - Prob. 3PCh. 5 - Prob. 4PCh. 5 - Prob. 5PCh. 5 - Prob. 6PCh. 5 - Prob. 7PCh. 5 - Prob. 8CCh. 5 - Prob. 9CCh. 5 - Prob. 10C
Knowledge Booster
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
- A derived attribute can be stored in a table or calculated on each occasion that it is required. An example of a derived attribute is your Grade Point Average which is calculated by adding together a score for each unit (e.g., HD=4, D=3, C=2, P=1, N=0) and dividing that by the number of units you have completed. Explain how the decision as to whether the Grade Point Average would be stored in a table or calculated would be made. You are administering a database in a large retail company that records sales at each of the company’s stores. Tuning the database to improve performance by adding indexes and optimising query execution is an important ongoing aspect of the physical database design. Which attributes in a database such as this (apart from the primary key) are likely to BENEFIT from being indexed? Which attributes would you generally avoid indexing, and why?arrow_forwardThis is the ER model for the case where there exists the entity of Product, which has the attributes of costPrice, salePrice, Identifier, factoryCode, description. These Products are manufactured by a Factory that has the attributes of description, factoryCode, factoryAddress, and this Factory sells its products to the Distributor entity, which has the attributes of distributorCode, factoryCode, email, description, distributorName. Please do the next thing: The requirement has been expanded with the following information: 'Currently, an Excel sheet is used where we store the information of the products that customers have ordered through orders; information is stored about when an order has been delivered and who or which company has made the delivery of the order.' Expand the ER diagram seen in class to comply with the new requirements requested, and also indicate what type of cardinality each of the relationships between the entities has." Please do the IMAGE E-R Diagram Expandedarrow_forwardBell State University Scenario Draw a detailed ERD with primary keys, foreign keys, and all provided attributes. If none are given in the scenario, provide at least one additional attribute for each entity. Scenario: When a person applies for a staff position Bell State University in the Chicago area, information about that person, including his or her social security number, name, address, and phone is stored. People applying for staff positions do not apply for a specific job, but apply for a job class. For example, a person might apply for a “Java programmer” job class position. Information stored about each job class includes a unique job code, a description, and a pay range. Each job applicant is assigned to an employment rep who processes the application and helps the job applicant with any questions. Information stored about the employment reps include their unique employee numbers, names, and phone numbers. Job applicants are not restricted to applying for a single job…arrow_forward
- Create and ERD based on the Crow's Foot Model, using the following requirements. Include Primary Keys, Foreign Keys, and Relationship types (weak/strong): 1. An INVOICE is written by a SALESREP. Each sales representative can write many invoices, but each invoice is written by a single sales representative. 2. The INVOICE is written for a single CUSTOMER. However, each customer can have many invoices. 3. An INVOICE can include many detail lines(INV_LINE), each of which describes one product bought by the customer. 4. The product information is stored in a PRODUCT entity. 5. The product's vendor information is found in a VENDOR entity.arrow_forwardContinuing with the Vince's Vinyl scenario from Hands-On Database, create an updated ERD after Normalization ? The diagram could pass the first three levels of normalization. There are a couple of issues, though, that could lead to further normalization: Customers and Sellers can be the same people. This could lead to update anomalies as the same person could have their information in two places. The solution is to create a Person entity that contains all names, phone numbers and email addresses. The person key could represent them in either role in Sale, Request, or Purchase. Another subtle issue relates to the entity Album. If Vince were to remove an album, and it was the only copy of that album, he would lose the album information. Also, there is potential redundancy in Album, since each physical vinyl is treated as an individual item in the table. Multiple copies of the same album would result in multiple entries identical except for purchase date and perhaps condition. To solve…arrow_forwardLet's break down the information into entities, attributes, and relationships: Entities: 1. Ship - ShipID (Primary Key) - ShipName - ShipType 2. Captain - CaptainID (Primary Key) - CaptainName - CaptainLicense 3. ShipmentTrip - TripID (Primary Key) - DeparturePort - ArrivalPort - RouteDetails 4. ShipmentManifest - ManifestID (Primary Key) - Date - GoodsList 5. Goods - GoodsID (Primary Key) - GoodsName - GoodsType (BM or LM) 6. Port - PortID (Primary Key) - Street - City - State - PostalCode - Country Relationships: - Ship to ShipmentTrip (Many-to-Many): - Ship can participate in multiple ShipmentTrips, and a ShipmentTrip can involve multiple Ships. Create a junction table `Ship_ShipmentTrip` with attributes `ShipID` and `TripID`. - Captain to ShipmentTrip (Many-to-Many): - A Captain can be assigned to multiple ShipmentTrips, and a ShipmentTrip can have multiple Captains. Create a junction table `Captain_ShipmentTrip` with attributes `CaptainID` and `TripID`. - Captain to Ship…arrow_forward
- Tiny College wants to keep track of the history of all its administrative appointments, including dates of appointment and dates of termination. (Hint: Time- variant data is at work.) The Tiny College chancellor may want to know how many deans worked in the College of Business between January 1, 1960, and January 1, 2018, or who the dean of the College of Education was in 1990. Given that information, create the complete ERD that contains all primary keys, foreign keys, and main attributes.To upload and submit your assignment, click the Choose File button below to find and select your saved document. Make sure that the file is saved with your last name in the file name. (Example: ch5_problem1_Jones.doc)arrow_forwardFor each of the following collection of entities, give the assumptions concerning the relationship between entities and attributes. EMPLOYEE(EMP_NUM, EMP_LNAME, EMP_INITIAL, EMP-DOB) DEPENDENT(EMP_NUM, DEP_NUM, DEP_FNAME, DEP_DOB)arrow_forwardGiven the following relation(s) and the functional dependencies, what is the highest normal form the data model complies to? Note: Primary keys are indicated in bold. TaxiRide (jobID, jobDateTime, driverID, driverName, taxiID, clientID, clientName, jobPickUpAddress)jobID -> jobDateTime, driverID, driverName, taxiID, clientID, clientName, jobPickUpAddressjobDateTime, driverID -> jobID, driverName, taxiID, clientID, clientName, jobPickUpAddressjobDateTime, taxiID -> jobID, driverID, driverName, clientID, clientName, jobPickUpAddressjobDateTime, clientID -> jobID, driverID, driverName, taxiID, clientName, jobPickUpAddressdriverID -> driverName, taxiIDclientID -> clientName A)1NF B)2NF C)3NFarrow_forward
- Consider an automobile dealership with three locations. Data fields exist for stock number, vehicle identification number, make, model, year, color, and invoice cost. Identify the possible candidate keys, the likely primary key, a probable foreign key, and potential secondary keys. What is the best keys possible?arrow_forwardFor the following collection of entities, give the assumptions concerning the relationship between entities. EMPLOYEE( EMP _CODE, EMP _LNAME, EMP _FNAME, EMP _INITIAL) BUILDING(BLDG_CODE, BLDG_NAME, EMP _CODE) ITEM(ITEM_ID, ITEM_DESCRIPTION, ITEM_ROOM, BLDG_CODE)arrow_forward2. Review the Personal Trainer fact-finding summary in Chapter 4 and draw an ERD with cardinality notation. Assume that system entities include members, classes, merchandise, and fitness instructors.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Database System ConceptsComputer ScienceISBN:9780078022159Author:Abraham Silberschatz Professor, Henry F. Korth, S. SudarshanPublisher:McGraw-Hill Education
Starting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSON
Digital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON
C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSON
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage Learning
Programmable Logic ControllersComputer ScienceISBN:9780073373843Author:Frank D. PetruzellaPublisher:McGraw-Hill Education
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)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education