The writer needs to have access to Microsoft Access, To take a snapshot of the projects
To create Tables and to link them in Microsoft Access.
Assignment 1 ONLY. please refer to the paper, the questions are also uploaded here.
* The Microsoft Access file is to be sent as well*
I want these main ER Schemas included
Students – Enrollment – Modules
+ the rest are optional. (10) in total. 2 should be strong entities + the three included. (students,enroll,modules)
The tables will be broken down with more information for Microsoft Access for ex:
Students:
Student number,Student name, family name , sex, country, date of birth, specialization.
give 10 rows of examples in each row.
Tables should connect together for linking in Microsoft access well, there should be no errors.
Write a report with the following 8 items below, giving an explanation at each step as to what you
have done. Ensure that all necessary diagrams, screenshots, and illustrations are included in the
report.
1. Create a snapshot of an ER schema of Wittenborg University, depicting at least ten (10)
entities of which a minimum of five (5) should be strong entities.
2. Explain in detail the attributes of each of the different entities + Snapshot
3. Describe in detail the types of relationships between the different entities
4. Transform your model into an actual linked table structure in MS Access + Snapshot provided in report
5. Ensure that your database is in the third normal form and explain any steps you have
taken (where necessary) to ensure it is in the third normal form.
6. Run a query within MS Access to demonstrate that data can be extracted from multiple
tables using one query. + Snapshots
7. Write an SQL statement that would demonstrate how the information was extracted from
the different tables.
8. Explain to management why a normalized (third normal form) might be the best system for use
in Wittenborg as oppose to a denormalized Bigdata system.
Last Completed Projects
| topic title | academic level | Writer | delivered |
|---|