ZuoTi.Pro
Question

You are helping design part of an employee database for XYZ Inc, that links employees to...

You are helping design part of an employee database for XYZ Inc, that links employees to their earned educational degrees and you are tasked with drawing the Entity Relationship Diagram (ERD) in Crow’s Foot notation. Entity: EMPLOYEE, EDUCATION, and BRIDGE. Business Rules: An employee can have one or more educational degrees (BS, MS, MBA, BA…) Each education degree is associated to one or more employees (more than one employee may have their MBA, BS…) This is a many-to-many relationship between EMPLOYEE and EDUCATION – which will be turned into two one-to-many relationships. This resulting ERD will have a one-to-many relationship between EMPLOYEE and BRIDGE entities and a one-to-many relationship between EDUCATION and BRIDGE entitites.

Attributes: EMP_NUM, EMP_NAME, EMP_HIREDT, ED_CODE, ED_DESCRIPT, ED_YEAR. Where: EMP_NUM is a number that’s unique to each employee.

ER_CODE is a letter code (MBA) that’s unique to each educational degree type employees have.

EMP_HIREDT is date employee was hired, ED_DESCRIPT is description of educational degree (Bachelors of Science) and ED_YEAR is the year that an employee earned their educational degree.

engineering   Computer-Science   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

EMPLOYEE EMP- NAME BRID ED- CoDE ED-DESCRİT ED-YEAR EDUCATI ON BS MS MBA ья

0 0
Add a comment
Know the answer?
Add Answer to:
You are helping design part of an employee database for XYZ Inc, that links employees to...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • Assume two entities ORDER and PRODUCT and the following business rules: An ORDER can contain one...

    Assume two entities ORDER and PRODUCT and the following business rules: An ORDER can contain one or more PRODUCTs. A PROUDCT can be in zero or more ORDERs. How would you convert this model into an ERM that displays only 1:M relationships? Be specific and complete. Draw the resulting ERM. 2. What is the difference between entity integrity and referential integrity? Given an example of each. 3. Suppose you have an EMPLOYEE table which has one row per employee. The...

  • Projects inc. is an engineering firm with approximately 50 employees A database is required to keep...

    Projects inc. is an engineering firm with approximately 50 employees A database is required to keep track of all employees, their skills, projects assigned and departments worked in. Every employee has a unique number assigned by the firm, required to store her or his name and data of birth. If an employee is currentty married to another employee of Projects tnc. the data of the marriage and who the employee is married to must be stored. Howeer no record of...

  • TM-315 DATABASE SYSTEMS Please help me to draw an ERD and the Relational Schema and please...

    TM-315 DATABASE SYSTEMS Please help me to draw an ERD and the Relational Schema and please mark the Primary and Foreign Key ..... Deliverable: Word document with grade sheet followed by Part 1 ERD and the Part 2 relational schema. Part 1: Draw the ERD for the following situation. 8 pts Be sure to: Convert all many-to-many relationships to associative entities. Make sure each regular entity has an appropriate identifier. Make sure attribute names are unique within the ERD Wally...

  • Database design Part One (Conceptual Database Design) As a database developer, you have been asked to...

    Database design Part One (Conceptual Database Design) As a database developer, you have been asked to design a new database the operation of the new project within the Liverpool John Moores University (LJMU). LJMU i planning to deliver a number of professional training courses in Al. Each course is delivered by one member of staff at LJMU's Training Centre; each staff is allocated a staff number. The policy of LJMU is to record the start working date of each staff,...

  • PART I: E-R Diagram Using MS Visio, you have previously practiced creating E-R diagrams. In this ...

    PART I: E-R Diagram Using MS Visio, you have previously practiced creating E-R diagrams. In this exercise, you will read and understand a scenario, identify relevant entities, then create proper ER diagrams You are tasked with drawing an ER diagram for a database that contains companies, departments, employees, employees' dependents (children), and employees' history. Answer each of the following questions (a)-(e) by providing an ER diagranm (a) [10 points] Each company operates four departments, and each department belongs to one...

  • Project 4: ER-Diagram and DBDL (25 Points) Database Design Language (DBDL) Use Visio or Word to...

    Project 4: ER-Diagram and DBDL (25 Points) Database Design Language (DBDL) Use Visio or Word to create the model. The correct syntax must be used. Remember to list out all alternate keys, secondary keys, and foreign keys. Entity Relationship Diagram (ERD) Draw the data model for the situation using LucidChart, Microsoft Visio, Word or other ERD Drawing Program. When drawing the objects, be sure to use the correct shapes, and syntax. Example: Entity is a rectangle box, and the name...

  • you are required to develop a simple HR application for a small accounting firm that wishes...

    you are required to develop a simple HR application for a small accounting firm that wishes to keep track of all the employees at the firm; storing details about their salary, phone numbers and Date of Birth. The firm has many departments and there are 5 to 20 employees in each department. The department information includes department name, description and total number of employees in that department. The company also provides vehicles for some of its employees. An employee maybe...

  • Create an Entity-Relationship Diagram (ERD). In the ERD include the following:

    Create an Entity-Relationship Diagram (ERD).In the ERD include the following: entities primary keys for all entities attributes - use "good" names for attributes, use only single-valued attributes relationships - use Crow's foot or UML notation; name relationships that could be ambiguous cardinality - minimum (optional/mandatory) and maximum (one or many) on both ends of the relationship - use reasonable assumptions if there is insufficient information in the descriptionStudent/Course registration system for a universityStudents have a unique identification number, first name, middle initial, last name, year...

  • . On-the-Vine Vineyard Valley. On-the-Vine Vineyard, Inc., is one of California's largest winemak...

    this is for CIS . On-the-Vine Vineyard Valley. On-the-Vine Vineyard, Inc., is one of California's largest winemaking facilities in Sonoma striving to make both a visit to the vineyard and the wine tasting an unforgettable On-the-Vine is a small, family-owned winery, specializing in limited production of Chardonnay, Sauvignon Blanc, Merlot, Syrah, Zinfandel, Sangiovese, Viognier, exper and Cabernet. currently employs over 12 full-time employees, with positions have rts to only one supervisor. Each employee is assigned a unique identification number. In...

  • Question 4. ER model (5 points). You are asked to design the ER diagram for a database to manage ...

    Question 4. ER model (5 points). You are asked to design the ER diagram for a database to manage data for athletes athletic game. Requirements are as follows: Each participating team has a name and a manager. Each athlete has a unique athlete ID, and is also described by first name and last name, gender and age. A team has many athletes but an athlete only belongs to one team. Each sport has a unique code and some sport name....

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT