Question

In: Computer Science

Given the following business scenario, create a Crow’s Foot ERD using a specialization hierarchy (EER) if...

Given the following business scenario, create a Crow’s Foot ERD using a specialization hierarchy (EER) if appropriate.

Two-Bit Drilling Company keeps information on employees and their insurance dependents. Each employee has an employee number, name, date of hire, and title. If an employee is a full-time inspector, then the date of certification, the renewal date for that certification, and the yearly salary should also be recorded in the system. If an employee is a part-time inspector, then the date of certification, the renewal date for that certification, and the hourly wage should also be recorded in the system. For all employees, the Social Security number and dependent names should be kept. All dependents must be associated with one and only one employee. Some employees will not have dependents, while others will have many dependents.

Solutions

Expert Solution

I tried my best to answer. I hope you understood.
If you have any doubts mention in comments. Please give me a upvote. Thank You......


Related Solutions

Given the following business scenario, create a Crow’s Foot ERD using a specialization hierarchy if appropriate....
Given the following business scenario, create a Crow’s Foot ERD using a specialization hierarchy if appropriate. Two-Bit Drilling Company keeps information on employees and their insurance dependents. Each employee has an employee number, name, date of hire, and title. If an employee is an inspector, then the date of certification and the renewal date for that certification should also be recorded in the system. For all employees, the Social Security number and dependent names should be kept. All dependents must...
Given the information below, create the fully labeled Crow's Foot ERD using a specialization hierarchy where...
Given the information below, create the fully labeled Crow's Foot ERD using a specialization hierarchy where appropriate (use Visio). The ERD must contain all primary keys, foreign keys, and main attributes. Business rules are defined as follows: At a hospital, each patient is classified as either a resident patient or an outpatient. All patients have common attributes - ID, first and last name, and diagnosis - and unique attributes that are specific to their groups. The list of such attributes...
Create a Crow’s Foot notation ERD to support the following business operations: Create a Crowsfoot notation...
Create a Crow’s Foot notation ERD to support the following business operations: Create a Crowsfoot notation ERD to support the following business operations: - A friend of yours has opened Marshfield Electronics and Repairs (MER) to repair smartphones, laptops, tablets, and MP3 players. She wants you to create a database to help her run her business. When a customer brings a device to MER for repair, data must be recorded about the customer, the device, and the repair (also referred...
Create an ERD (using Crow’s Foot Notation) for the following description. Be sure to include all...
Create an ERD (using Crow’s Foot Notation) for the following description. Be sure to include all necessary entities, attributes, and correct cardinality in relationships between entities. You have been asked to build a database for a sportswear company called AthFleet. The company owner needs to keep track of the customers that buy their products, the employees that work at AthFleet, the vendors that provide them with products, and the products themselves. Each vendor has contact with one employee representative and...
Use following case and create Entity-Relationship Diagrams using the Crow’s Feet method for each. Each ERD...
Use following case and create Entity-Relationship Diagrams using the Crow’s Feet method for each. Each ERD should be completed on a separate sheet of paper, if drawn by hand. If additional assumptions are made for any of your 2cases, be sure to document the additional business rules and include them with your ERDs. Entity-Relationship Diagram : TEXTBOOK REVIEWS Your website would like to add the ability for school BIT students to provide reviews for textbooks they have previously used. Using...
Draw an EER model of given scenario We wish to create a database for a company...
Draw an EER model of given scenario We wish to create a database for a company that runs training courses. For this, we must store data about the trainees and the instructors. For each course participant (about 5,000),identified by a code, we want to store her social security number, surname, age, sex, place of birth, employer’s name, address and telephone number, previous employers (and periods employed), the courses attended (there are about 200 courses) and the final assessment for each...
Create an ERD based on the following business rules and requirements. Make sure that the ERD...
Create an ERD based on the following business rules and requirements. Make sure that the ERD follows good database design practices covered in Chapter 6. use an online visual paradigm tool to create the ERD NOST offers many different tours. For each tour, the tour name, approximate length (in hours), and fee charged is needed. Tours are classified into five categories: family friendly, adventure, hiking, camping, and water activities. Guides are identified by an employee ID, but the system should...
Use the following business rules to draw the fully labeled Crow's Foot ERD in Visio. The...
Use the following business rules to draw the fully labeled Crow's Foot ERD in Visio. The diagram must include all entities, attributes, and relationships. Primary keys and foreign keys must be clearly identified on the diagram. Write all appropriate connectivities and cardinalities on the ERD. a). A company has many divisions. Each division operates many departments, but each department is operated by one division. b). A department employs many employees but not more than 100. c). Each employee is employed...
Q1.Generate an ERD diagram for the following scenario using Lucidchart. I need to know what the...
Q1.Generate an ERD diagram for the following scenario using Lucidchart. I need to know what the diagram should look like. (I am not sure there should be any kind of relationship between entities.) Scenario: Southlands Electric Southlands Electric wishes to create a database with the following information: Customer with attributes Customer ID, Name, Address (Street, City, State, Zip Code), and Telephone Location with attributes Location ID, Address (Street, City, State, Zip Code), and Type (values of Business or Residential) Rate...
ERD Lucid chart with Crow's foot notation for the following. include all entities, attributes, and correct...
ERD Lucid chart with Crow's foot notation for the following. include all entities, attributes, and correct carnality in relationships between entities. primary and foreign keys. You have been asked to build a database for a sportswear company called Ath Fleet. The company owner needs to keep track of the customers that buy their products, the employees that work at Ath Fleet, the vendors that provide them with products, and the products themselves. Each vendor has contact with one employee representative...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT