Read the description of Sydney Crypto Group (SCG) and complete the tasks specified at the end.
The Sydney Crypto Group (SCG) has contacted you to create a conceptual model whose application will meet the expected database requirements for the company's training program. The SCG administrator gives you the description (see below) of the training group's operating environment.
The SCG has 5 instructors and can handle up to 20 trainees per class. SCG offers five "advanced investment" courses, each of which may generate several classes. If a class has fewer than 5 trainees, it will be cancelled. Therefore, it is possible for a course not to generate any classes. Each class is taught by one instructor. Each instructor may teach up to four classes or may be assigned to do market research only. Each trainee may take up to four classes per year.
Given that information, do the following:
Tasks to be completed
Given the above information:
-
Create a complete ERD to support the business needs as described above.
-
Convert the ERD to a set Relational tables in at least 3NF and draw a dependency diagram.
-
Create a database for SCG using MS ACCESS - with primary keys, foreign keys and other attributes mentioned for each entity.
-
Create a form to input/update data for Course.
-
Input some significant data in each table showing your understanding of the scenario.
-
Create three queries - SELECT, JOIN and one NUMERIC Function query; you can use any tables and any fields.
-
Create a report using any one of the above queries.
List any additional business rules that you may assume to submit the ERD and database as complete as possible.