Question: Step 1 : Create an ER diagram ( already created see next page ) o Step 2 : Convert it to a relational schema (
Step : Create an ER diagram already created see next page o Step : Convert it to a relational schema already created see next page o Step : Implement the relational schema as an empty MS Access database file ie collection of tables and the relationships between them Name the MS Access database file SunConsulting.accdb o Step : Populate the MS Access database with the data given in the spreadsheet o Step : Create a form that will enable entry into the consultant table and name it ConsultantForm o Step : 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 : 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 : Create a query named ConsultantSkillsQuery which will list for each consultant: first name, last name, and the descriptions of all of hishers expert skills. o Step : 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
