4 assign the attributes to each entity and

This preview shows page 3 - 5 out of 9 pages.

We have textbook solutions for you!
The document you are viewing contains questions related to this textbook.
Oracle 12c: SQL
The document you are viewing contains questions related to this textbook.
Chapter 6 / Exercise 7
Oracle 12c: SQL
Casteel
Expert Verified
4. Assign the attributes to each entity and relationship type. 5. From the attributes, recognize the possible identifiers such as primary keys, foreign keys, or composite keys for the entities 6. Determine if the relations of the keys makes the entities regular or weak ones. 7. Model the required ERM Diagram. Risks of Not Performing Any of the Developmental Steps for the ERD Diagram
Five (5) Entities Required for the Development of the Data Repositories
We have textbook solutions for you!
The document you are viewing contains questions related to this textbook.
Oracle 12c: SQL
The document you are viewing contains questions related to this textbook.
Chapter 6 / Exercise 7
Oracle 12c: SQL
Casteel
Expert Verified
DATABASE MODELING AND NORMALIZATION 4 repositories we might say that the most important ones would be the HR related ones like employee documents, 401K, attendance, retirement, health insurance, performance reviews, training history, skills and many others relating to the reporting needs. The reality is that these entities relating to HR come secondary because we need to establish the base or foundation needed to gather information on any employee in the agency. Having stated that fact, the five (5) entities that as a consultant I deem requires are the following: Employee, Training, Job, Position, and Department. The rank would be in that particular order since it establishes the foundation on which to build any other employee related entities.

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture