Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need some help with this project. I need help creating a ORM diagram in visual studio Natural ORM Architect with these elementary facts, entity

I need some help with this project.
I need help creating a ORM diagram in visual studio Natural ORM Architect with these elementary facts, entity types, and sample data.
Scenario: Consider a manufacturing scenario:
1. joe, id =101, works at the ABC company, internally identified by name, and located in Phoenix, is male, and works on exactly one project that is identified by an external preferred identifier named Sales and was hired on Dec 10,2010
2. may, id =102, works at the ABC company, internally identified by name, and located in Phoenix, is female, and works on exactly one project that is identified by an external preferred identifier named Sales and was hired on Dec 12,2015
3. gene, id =201, works at the XYZ company, is male, and works on exactly one project, located in Phoenix, and is identified by an external preferred identifier named HR and was hired on Dec 10,2009
4. "yourlastname", id =500, works at the XYZ company, located in Phoenix, is female/male, and works on exactly one project that is identified by an external preferred identifier named HR
a) elementary facts
b) entity types
c) sample data
EXAMPLE DIAGRAM
46385164
Draw the ORM Diagram
a. use varchar 20 for names
b. use .code for Locations
c. use yymmdd for Date
d. HINT: The identifer for project is its "Name' A DOMAIN VALUE (this should clarify the question about preferred identifier for the project)
e. Show the gender constraints on your ORM 'M','F'I need some help with this project.
I need help creating a ORM diagram in visual studio Natural ORM Architect with these elementary facts, entity types, and sample data.
Scenario: Consider a manufacturing scenario:
1. joe, id =101, works at the ABC company, internally identified by name, and located in Phoenix, is male, and works on exactly one project that is identified by an external preferred identifier named Sales and was hired on Dec 10,2010
2. may, id =102, works at the ABC company, internally identified by name, and located in Phoenix, is female, and works on exactly one project that is identified by an external preferred identifier named Sales and was hired on Dec 12,2015
3. gene, id =201, works at the XYZ company, is male, and works on exactly one project, located in Phoenix, and is identified by an external preferred identifier named HR and was hired on Dec 10,2009
4. "yourlastname", id =500, works at the XYZ company, located in Phoenix, is female/male, and works on exactly one project that is identified by an external preferred identifier named HR
a) elementary facts
b) entity types
c) sample data
EXAMPLE DIAGRAM
46385164
Draw the ORM Diagram
a. use varchar 20 for names
b. use .code for Locations
c. use yymmdd for Date
d. HINT: The identifer for project is its "Name' A DOMAIN VALUE (this should clarify the question about preferred identifier for the project)
e. Show the gender constraints on your ORM 'M','F'
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions

Question

b. Determine the number of dependent variables, p. Pg45

Answered: 1 week ago