This assessment is an individual Project. A college is maintaining student progress through the course. The students are reading towards a degree (e.g. BBA, BIT, etc.). Every student is identified with his student number. Other information such as student address, phone number, degree towards which he is reading, is also stored. The degree that student is enrolled is characterized by its code, title, elective and compulsory modules to be completed in it. A module is characterized by its code, title, credits, department, lecturers and unit coordinator. A Module can generate many classes. Necessary information about class should be stored in the system such as class code, module with which it is associated and lecturer responsible for E.g. a task marked out of 40 will incur a 2 mark penalty . Student Policies and Forms Kent Institute Australia Pty. Ltd. Assessment Brief ABN 49 003 577 302 CRICOS Code: 00161E RTO Code: 90458 Version: as at 9th November, 2017 TEQSA Provider Number: PRV12051 conducting the class. Each class will be taught by one lecturer only. All the lecturers teaching classes of same module are coordinated by a unit coordinator who is also a Lecturer. Every lecturer’s name, his employment code, his address, phone number, his qualifications must also be stored in the system. A lecturer can have many Qualifications. A student can choose any module from the available list. However, some Modules can have prerequisites (one or more than one modules) to be completed before a student can be enrolled for the course. There are some extracurricular activity clubs available in the college too. Students can enroll themselves into any extracurricular activities (such as debating club, sports club, reading club, etc.). A club can have a code, its title, its description, its establishment date and current president. The president of every club is an elected student. Tasks to be completed Given the above information: 1. Create a complete ERD with all entities and relationships. 2. Convert the ERD to a set of Relational tables in at least 3NF and draw a dependency diagram. 3. Create a database using MS ACCESS – with primary keys, foreign keys and other attributes mentioned for each entity using proper constraints. 4. Create a form to input/update data. 5. Input some significant data in each table showing your understanding of the scenario. 6. Create three Queries. SELECT, JOIN and an AGGREGATE function QUERY. You can use any table and fields for your Queries. 7. Create a report.
The post → appeared first on mynursinghomeworks.