database programming project assignment
DESCRIPTION
Database for the Maintaining Grade 1 Students DetailsTRANSCRIPT
![Page 1: Database Programming Project Assignment](https://reader035.vdocuments.us/reader035/viewer/2022062405/555e0dd1d8b42a9e188b4d70/html5/thumbnails/1.jpg)
Database
Programming
Project Assignm
ent
Panorama Group
Database for the Maintaining
Grade 1 Students Details
![Page 2: Database Programming Project Assignment](https://reader035.vdocuments.us/reader035/viewer/2022062405/555e0dd1d8b42a9e188b4d70/html5/thumbnails/2.jpg)
Our Panorama Team MembersName Index Number
K.K.M.Kodithuwakku MMW/13/B1/14
I.P.S.Siriwardhana SOF/13/B1/18
H.M.P.Renuka SOF/13/B1/16
E.M.K.Udayakanthi SOF/13/B1/21
H.G.S.K.Wijenayake SOF/13/B1/27
H.A.V.Nishshanka SOF/13/B1/07
L.P.D.Perera SOF/13/B1/11
G.D.S.Madhuwanthi MMW/13/B1/18
![Page 3: Database Programming Project Assignment](https://reader035.vdocuments.us/reader035/viewer/2022062405/555e0dd1d8b42a9e188b4d70/html5/thumbnails/3.jpg)
Problem Description
Prajapathi Gothami Girls’ College is one of the leading girls’ colleges in Southern Province.More than 3000 students are learning there. In every year 200-250 students are selected to the Grade 1 out of 1000-1500 Applications. At present, they use a manual database to maintain Grade 1 Students’ information but its accuracy is very low. Therefore, we decided to create a new computer based database system for it. This DBMS also can be used for the other schools in Sri Lanka.
![Page 4: Database Programming Project Assignment](https://reader035.vdocuments.us/reader035/viewer/2022062405/555e0dd1d8b42a9e188b4d70/html5/thumbnails/4.jpg)
Conceptual Database DesignER Diagram
![Page 5: Database Programming Project Assignment](https://reader035.vdocuments.us/reader035/viewer/2022062405/555e0dd1d8b42a9e188b4d70/html5/thumbnails/5.jpg)
Teacher
Parent
Category
has
has
Select by
Student
Student_IDName
Date_of_B
Distance
NIC
Name
Address
No
Ste:
Town
Teacher_ID
Class Name
Telephone_No
C_Name
CID
![Page 6: Database Programming Project Assignment](https://reader035.vdocuments.us/reader035/viewer/2022062405/555e0dd1d8b42a9e188b4d70/html5/thumbnails/6.jpg)
Mapping (Final Step of the Mapping)
NameStudent_ID Date_of_Birth Distance
Student
NameNIC No Occupation
Parent
Street Town
NICStudent_ID
Stu_Pa
![Page 7: Database Programming Project Assignment](https://reader035.vdocuments.us/reader035/viewer/2022062405/555e0dd1d8b42a9e188b4d70/html5/thumbnails/7.jpg)
Telephone_NoNIC
Telephone_No
NameNIC No Occupation
Parent
Street Town
NameTeacher_ID Class
Teacher
NameStudent_ID Date_of_Birth Distance
Student
Student_IDTeacher_ID
Teacher_St
![Page 8: Database Programming Project Assignment](https://reader035.vdocuments.us/reader035/viewer/2022062405/555e0dd1d8b42a9e188b4d70/html5/thumbnails/8.jpg)
C_NameCatagory_ID
Select_Catagory
NameStudent_ID Date_of_Birth Distance
Student
Student_IDCatagory_ID
Stu_Catagory
![Page 9: Database Programming Project Assignment](https://reader035.vdocuments.us/reader035/viewer/2022062405/555e0dd1d8b42a9e188b4d70/html5/thumbnails/9.jpg)
Physical Database Design Using MS SQL
![Page 10: Database Programming Project Assignment](https://reader035.vdocuments.us/reader035/viewer/2022062405/555e0dd1d8b42a9e188b4d70/html5/thumbnails/10.jpg)
Views
![Page 11: Database Programming Project Assignment](https://reader035.vdocuments.us/reader035/viewer/2022062405/555e0dd1d8b42a9e188b4d70/html5/thumbnails/11.jpg)
Interface Design With using Microsoft C#
![Page 12: Database Programming Project Assignment](https://reader035.vdocuments.us/reader035/viewer/2022062405/555e0dd1d8b42a9e188b4d70/html5/thumbnails/12.jpg)
Interface Design With using Microsoft C#
![Page 13: Database Programming Project Assignment](https://reader035.vdocuments.us/reader035/viewer/2022062405/555e0dd1d8b42a9e188b4d70/html5/thumbnails/13.jpg)
Download Software related with this presentation https://www.dropbox.com/s/uz5kqfv06bavnrz/Panorama_Team.7z
![Page 14: Database Programming Project Assignment](https://reader035.vdocuments.us/reader035/viewer/2022062405/555e0dd1d8b42a9e188b4d70/html5/thumbnails/14.jpg)
References:
http://technet.microsoft.com/en-us/sqlserver/
![Page 15: Database Programming Project Assignment](https://reader035.vdocuments.us/reader035/viewer/2022062405/555e0dd1d8b42a9e188b4d70/html5/thumbnails/15.jpg)
Thanking
• Our Dear Sir Senior Lecture Mr. P.Uruthiran
• Mr Welligton Perera (Microsoft)
• Mr Sachith Dissanayake
• Mr T. Jayashan