Database代写 | Moursey School Individual Project

为一个学校设计一个课程管理数据库

Individual Project Example

Moursey School Database Example

Table Of Contents

PROBLEM DEFINITION  3

The Client: 3

Outcomes:  3

ANALYSIS 4

DESIGN  6

Tables and Relationships  6

Table Relationship Diagram    7

Data Dictionaries  8

DEVELOPMENT & VALIDATION  10

Validation Plan   10

Validation of Outcomes  11

Outcome 1 – A data entry form to enter current students into classes. 11

Outcome 2 – An alphabetical list of all current students that do Year 12 Physics or any Information Technology subject in 2002, showing their names and which of these subjects they are doing.  14

Outcome 4 – A user selected class list showing students names and ages, the teacher and the room. The number of students in the class will be shown.  22

EVALUATION  26

 

PROBLEM DEFINITION

The Client:

The client is Moursey School who require a database solution to store data about their students and the classes they take.

At the end of each school year, the school determines the teachers and classes for the following year.  Students need to be entered into a home group and the subjects they wish to study for the following year.   Lists are to be produced to give to each teacher showing their classes and the students in the class.

 

Outcomes:

 

  1. A data entry form to enter students into classes.

The administration staff would find the record of the class in the main form and then in the subform, enter in a student.

  1. A list of students who do Year 12 Physics or any Information Technology subject in 2019, showing their names and which of these subjects they are doing.

The subject coordinator (teacher) is given this list to counsel students doing these subjects before they commence.

  1. A list of year 12 students displaying the number of Year 12 subjects in which they are enrolled.

The year 12 coordinator will need to check that each student doing a year 12 subject is enrolled in the correct number of subjects.

  1. A user selected class list showing students names and ages, the teacher and the room. The number of students in the class will be shown.

This list allows a teacher to have a printed copy of all students in their class and use it as a checklist for attendance.

ANALYSIS

 

Outcome 1:      A data entry form to enter students into classes.

 

Main form:

Data required:     Class ID, Subject Name, Year, Year Level, Teacher, Room

 

Processing:         Where:        All records found

Sort:            Subject Name

 

SubForm:

Data required:    Student ID, First Name, Surname,

 

Processing:         Where:      Current = “yes”

Calculate:   Name = [First name]+” “+[Surname]

Sort:           Surname

 

 

Outcome 2:  A list of current students doing Year 12 Physics or any Information Technology subject in 2019 showing which of these subjects they are doing.

 

Data required:    First Name, Surname, Year Level, Subject, Current, Class

 

Processing:         Where:      Year level = 12 and Current = “yes” and Year level = 2019 and

Class= Physics

OR,

Current= “yes” and year = 2019 and Class = [Information Technology]*

Group:         First Name and Surname

Sort:             Subject name

Outcome 3:  A list of year 12 students displaying the number of Year 12 subjects in which they are enrolled.

 

Data required:     Teacher, Subject Name, Year Level, Room, First Name, Surname

Processing:         Where:      Year =12 and current =yes

Calculate: Student =  [Surname]+”, “+[First Name]

Group:        Subject Name

Calculate:   Count of subject

Sort:          Student

 

Outcome 4:  A user selected class list showing students names and ages, the teacher and the room. The number of students in the class will be shown.

 

Data required:     Teacher, Subject, Year Level, Room, Student

Processing:         Where:         Class ID = [Parameter box]

Calculate:  Teacher =  [Title]+” “+Left([T Name],1)+”. “+[T Surname]

Student =  [Surname]+”, “+[First Name]

Age = Int((Date()-[DOB])/365.2425)

Class Total = Count of Class ID

 

Sort:            Sort Surname

DESIGN

 

Tables and Relationships

 

The Moursey school database will need to store data about the students, the classes that they attend and the subjects that they are studying. The database will also need to store data about the teachers and the rooms

 

The first source table will be Students. There is a record in the Students table for each student in the school. Each record will need to contain data about the student’s name, age and if they are a current student. The student’s address and other personal details will also be stored. The students Date of Birth will be stored and the age calculated from that. Each student is identified by a Student ID.

 

The second source table will be Teachers. There is a record in the Teachers table for each teacher in the school. The database will store the teacher’s name, and address details. Each teacher is identified by a Teacher ID.

 

The third source table will be Subjects. There is a record in the Subjects table for each subject that is taught in the school. This will contain the name of the subject and the Year level. Each subject is identified by a Subject ID.

 

The fourth source table will be Classes. There is a record in the Classes table for each class in the school taught by a particular teacher and the subject that is taught. This will contain data about the year in which that class was taught and the room in which it was taught. This will allow the data to be stored over several years. Each class is identified by a class code.

 

Each class will have one teacher; however each teacher will teach many classes.

 

Each class will have one subject; however each subject will be taught in many classes.

A user selected class list showing students names and ages, the teacher and the room. The number of students in the class will be shown.

 

Class List Query

There is a combo box called ‘Class’ which is on the Menu Form. It is used by the user to select the class needed for the Class List.

 

Student: [Surname]+”, “+[First Name]

Connects the Surname and First Name of the student. The new field called Student displays the entire name of the student.

 

Teacher: [Title]+” “+Left([T Name],1)+”. “+[T Surname]

Connects the Title to the left-hand letter of T Name (initial), with the T Surname. The new field called Teacher is a better way to display the teachers name.

 

Age: Int((Date()-[DOB])/365.2425)

Age is calculated by subtracting the Date of Birth (DOB) from today’s date (Date()). This is in days and is divided by 365.2425 to get years. The function Int() is used to only show the whole number of years.

 

 

Report Design

 

A user selected class list showing students names and ages, the teacher and the room. The number of students in the class will be shown.

 

Class List Report

 

 

 

The information about Teacher, Subject, Year and Room is constant for one class and consequently appears in the Report Header.

 

=Count([age])    Is used to count the number of records in the field Age.

 

EVALUATION

 

The solution is very effective in its design and implementation. The menu appears when the file is opened and the screen is maximised on opening.

 

The Student/Classes Form is used to enter students into classes (Outcome 1). This enables students to be entered into classes efficiently by selecting the class using the navigation arrows on the left of the screen, and using the drop-down box in the sub-form to enter the student from a list of students currently enrolled in the school. The Student/Classes Form could be more user friendly by containing a combo box for the classes to choose from or by providing a search option to locate the class required instead of using the navigation buttons to locate the class.

 

Each of the reports are able to be displayed by selecting a button from the Outcomes in the Menu.  The “Students doing Year 12 Physics or any Information Technology subject” report clearly lists the names of students enrolled in the subjects for the coordinators to council.  This report however, could be more practical if parameter values could be used for the outcomes so that the user can enter the class and year level of the classes they wish to print.

 

The “Year 12 Subject” report also clearly lists the number of students enrolled in the course.  The Year 12 coordinator will easily be able to see if students are enrolled in the correct number of subjects.

 

The “Class List” report is very user-friendly.  It can simply be produced by selecting from the list of classes from the combo box.  Student names are listed alphabetically for the subject teacher.

 

Other improvements that could be made would be to include student’s photos which will to help identify students when entering in their data. A final grade for each student completing a subject could also be included so that it can be entered at the end of the year.


程序代写代做C/C++/JAVA/安卓/PYTHON/留学生/PHP/APP开发/MATLAB


本网站支持淘宝 支付宝 微信支付  paypal等等交易。如果不放心可以用淘宝交易!

E-mail: [email protected]  微信:dmxyzl003


如果您使用手机请先保存二维码,微信识别。如果用电脑,直接掏出手机果断扫描。

发表评论