Question: 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'
 I need some help with this project. I need help creating

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!