Question: Step 1 : Create an ER diagram ( already created see next page ) o Step 2 : Convert it to a relational schema (

Step 1: Create an ER diagram (already created see next page) o Step 2: Convert it to a relational schema (already created see next page) o Step 3: Implement the relational schema as an empty MS Access database file (i.e. collection of tables and the relationships between them). Name the MS Access database file SunConsulting.accdb o Step 4: Populate the MS Access database with the data given in the spreadsheet o Step 5: Create a form that will enable entry into the consultant table and name it ConsultantForm o Step 6: Using the newly created form, add an additional consultant which is placed in any of the three regions and which has your first and last name. o Step 7: Make sure that the additional consultant has at least one expertise skills (of your choosing) and is assigned to at least one contract (of your choosing). You can enter this data directly into the appropriate tables. o Step 8: Create a query named ConsultantSkillsQuery which will list for each consultant: first name, last name, and the descriptions of all of his/hers expert skills. o Step 9: Create a report named RegionReport which will show current contract for each region. More precisely, the report will show information about each region (region id and region name) and the information about all the current contracts (contract id, amount, and date) in each particular region.

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 Programming Questions!