[go: up one dir, main page]
Scribd
Upload
43 views3 pages

Name: Paul Justine D.Tindugan Professor: Mengvi Gatpandan Year Section: 2ndyear / Itc - c201 - 301ga

Uploaded by

justine tindugan

The document provides information for a data modeling activity, including the student's name, professor, and section. It outlines learning objectives related to accurately representing database objects using Oracle Data Modeler. The activity requires students to create a conceptual, logical, and physical data model for a laboratory using Oracle Data Modeler based on a given business scenario involving employees, projects, and employee billing rates for different projects.

Copyright:

© All Rights Reserved
Download as PDF, TXT or read online from Scribd
Download as pdf or txt

Name: Paul Justine D.Tindugan Professor: Mengvi Gatpandan Year Section: 2ndyear / Itc - c201 - 301ga

Uploaded by

justine tindugan
43 views3 pages
The document provides information for a data modeling activity, including the student's name, professor, and section. It outlines learning objectives related to accurately representing database objects using Oracle Data Modeler. The activity requires students to create a conceptual, logical, and physical data model for a laboratory using Oracle Data Modeler based on a given business scenario involving employees, projects, and employee billing rates for different projects.

Original Description:

Entity Relationship Diagram

Original Title

TinduganPauljustine_DMAct1

Copyright

© © All Rights Reserved

Available Formats

PDF, TXT or read online from Scribd

Did you find this document useful?

Is this content inappropriate?

The document provides information for a data modeling activity, including the student's name, professor, and section. It outlines learning objectives related to accurately representing database objects using Oracle Data Modeler. The activity requires students to create a conceptual, logical, and physical data model for a laboratory using Oracle Data Modeler based on a given business scenario involving employees, projects, and employee billing rates for different projects.

Copyright:

© All Rights Reserved
Download as PDF, TXT or read online from Scribd
Download as pdf or txt
43 views3 pages

Name: Paul Justine D.Tindugan Professor: Mengvi Gatpandan Year Section: 2ndyear / Itc - c201 - 301ga

Uploaded by

justine tindugan
The document provides information for a data modeling activity, including the student's name, professor, and section. It outlines learning objectives related to accurately representing database objects using Oracle Data Modeler. The activity requires students to create a conceptual, logical, and physical data model for a laboratory using Oracle Data Modeler based on a given business scenario involving employees, projects, and employee billing rates for different projects.

Copyright:

© All Rights Reserved
Download as PDF, TXT or read online from Scribd
Download as pdf or txt
You are on page 1/ 3

Name : Paul Justine D.

Tindugan
Professor : Mengvi Gatpandan
Year Section : 2ndyear / itc_c201_301ga

Learning Objectives:
At the end of this lesson, the students shall be able to:

 Ensures that all data objects required by the database are


accurately represented using ORACLE data modeler.
 It helps design the database at the conceptual, physical and
logical levels.
 It helps the data model structure to define the relational tables,
primary and foreign keys and stored procedures.

Creating a conceptual, logical, and physical design of the given


business scenario using the data modeler.
Captured all the process of creating the business scenario using
ORACLE data modeler.
ALL file must be in PDF format.
FileName: LastNameFirstname_LastnameFirstname_DMAct1.pdf
Business Scenario of Laboratory Data Modeler Activity #1

 A company has number of employees.


 The attributes of employee includes Emp_ID as identifier, Name,
Address and Birthdate.
 The company also has several projects. Attributes of projects
includes Project_ID as identifier, Project_Name and Start_Date.
 Each employee may be assigned to one or more projects, or may
not be assigned to a project. A project must have at least one
employee assigned, and may have any number of employees
assigned.
 An employees billing rate may vary by project and the company
wishes to record the applicable billing rate (billing rate) for each
employee when assigned to a particular project.
Creating Data modeler

Output Using Engineer Command


Entity Diagram

You might also like