PROJECT OVERVIEW
The Commerce Coaching Point Management System project Overview is as follows:
- To allow storage of detailed records on all teacher, students, subject, section.
- To make the system easier to handle by reducing the time in searching specific record needed when required. Oracle provides the facility of data accuracy and consistency which helps to search the required data easily.
- To make it efficient by quickly searching the records
- To allow the system to be easily adjustable for further developments. In future when the record of the institution increases, the system going to be developed should handle it properly.
- To make sure that student level remains updated.
- To make sure the subject and section are being updated.
ANALYSIS OF AN INSTITUTION
The function of the institution which we have chosen for our project is teaching. The name the institution is Commerce Coaching Point (CCP). Teachers are doing their job very well. They put their full effort in explaining their topics and are very cooperative and supportive with their students. They pay full attention to every student. We observe that every student get good marks in their exams. There are five teachers' in this organization. Students get excellent GPAS and CGPAS in their exams by studying in this institution. There result is 100%.The subjects which are being taught in CCP is related to business field that is principles of accounting, finance, marketing, economics, income tax, total quality management, data base management system, cost accounting, research methods, management, business mathematics and statistics. Every teacher teaches two or three subjects. The timings of CCP are according to the students need. These teachers are very hard working. They apply different methods' of teaching. For example they provide their own notes for each subject and extra questions for practice to get through exams. Test of every subject are taken on weekly basis and grand final tests separately. This institution is becoming very successful day by day. There are more than 100 students studying in CCP. They are cooperative in the sense if any student doesn't able to pay the fees due to any reason they give special discount to that student. Otherwise their charges are very reasonable and affordable by every student. Teachers of CCP also provide the facility of fees on installment basis .Students are very satisfied with their teaching that's why the strength of students is increasing day by day. They provide extra knowledge to the students. Teachers are well spoken and deal well with their newly admitted student. If any student is weak in any subject then they give separate time to that student. The good thing about these teachers is that they respect their student. One thing which we observe is that there is lack of space. Teachers should build another branch of CCP as well. They should hire more experienced teachers as well because strength of students is increasing day by day. COMMERCE COACHING POINT is more reliable organization for the study than any other organization.
DEFINE ENTITY, ATTRIBUTES & RELATIONSHIP:
ENTITY:
Entity is a person, place, object, event, or concept in the user environment about which the organization wishes to maintain data.
ATTRIBUTES:
A property or characteristic of an entity type that is of interest to an organization.
RELATIONSHIP:
A relationship is an association representing an interaction among the instances of one or more entity types that is of interest to organization.
TYPES OF RELATIONSHIP:
- Unary RELATIONSHIP:
A relationship between the instances of a single entity type.
- BINARY RELATIONSHIP:
A relationship between the instances of two entity types.
- TERNARY RELATIONSHIP:
A simultaneous relationship among the instances of three entity types.
IDENTIFY ENTITIES OF THE INSTITUTION
ENTITIES:
- STUDENTS
- TEACHERS
- SUBJECTS
- SECTION
DEFINE ATTRIBUTES OF THE ENTITIES:
1. STUDENTS
- Name
- Father's_Name
- Roll_No
- Blood_group
- Student_Gender
- Student_Address
- Student_Date of Birth
- Contact_no
2. TEACHERS
- Teacher's_ID
- Teacher's_Name
- Teacher's_Address
- Teacher's_Gender
- Contact_no
3. SUBJECT
- Subject_Name
- Code_No
- Areas
4. SECTION
- Morning (A-H)
- Afternoon (A-G)
DEFINE RELATIONSHIP BETWEEN THE ENTITIES
* 1 *
*
*
1
1 q * *
*
1 *
E-R DIAGRAM OF THE INSTITUTION
* 1 1 *
* 1
* 1
TABLES
1. STUDENTS
1 | ID_no | Primary key |
2 | Student_Name | More than 6characters |
3 | Student_Gender | Values can be M/F |
4 | Student_Address | Permanent address |
5 | Contact_number | Area code-number |
6 | Blood_Group | A+,A-,B+,B-,AB+,AB-,O+,O- |
7 | Date of Birth | mm-dd-yyyy format |
8 | Morning/Afternoon | Key of Section |
2. TEACHER
SNO | Attribute Name | Description |
1 | Teachers_ID | Primary key |
2 | Teachers_Name | More than 6characters |
3 | Teachers_Address | Permanent address |
4 | Teachers_Gender | Values can be M/F |
5 | Contact_Number | Area code-number |
6. | Morning/Afternoon | Key of Section |
3. SUBJECT
SNO | Attribute Name | Description |
1 | Subject_Name | More than 6 characters |
2 | Code_no | Primary key |
3 | Areas | According to Subject |
4. SECTION
SNO | Attribute Name | Description |
1 | Morning | A-H |
2 | Afternoon | A-G |
RELATIONSHIP OF THE INSTITUTION:
The relationship of the organization is TERNARY relationship. A ternary relationship is a simultaneous relationship among the instances of three entity types. Typical situation that lead to a ternary relationship may include
teacher, subject, section
They are interlinked as the teacher teaches a particular subject to different sections.
student,subject,section.
They have a ternary relationship as the students of different sections study a particular subject.
SQL QUERIES:
SQL> create table student_info (ID_no constraint 031 primary key, father's_name, gender, address NOT NULL, contact_no , bloodgroup constraint check_bloodgrp check (blood_group in ('A+','A-','B+','B-','AB+','AB-')), age number, Name constraint name references Subject(name),Morning constraint Morning references Section(Morning));
SQL> create table teacher_info(name constraint shahid primary key, teacher's subject constraint DBMS check, address NOT NULL, contact_no , gender NOT NULL, morning constraint morning references section(morning));
SQL> create table subject (name constraint name references student (name), name constraint accounting primary key, subject_code area);
SQL> create table section(morning ,afternoon);