School Managment

School mgmt :-

Student: 5 - Ashok/Nikil
rollno :pk
fist name string
Last name string
DOB date
sex
mail id
joining_date date
father name
mother name
primary mobile no
seconday_mobile_ no
parent_working_in str  - done

permenent_address_id-fk -1 - Nikil
current_address_id-fk

parent_id -fk- need to analyze 

MediumId int FK - 2 -Chandra -done
Fee-details_id Integer(fk)
Section-Id Integer(fk)

BranchId -FK -2 -Ashok
transport_id Integer(fk)
class_id-fk -


Address: 1 -Nikil -done 
address_id - pk
house_no string
street_no string
street1_address str
street2_address string
state string
pincode int


Attendance :2-Nikil    - done
attendence_id - pk
Student_id - fk - many to one
attendence_date date
attendence char(P - present,O - offsent ,H - holiday)

Staff: 2 - Nikil - done
staff_id - pk
staff name
subject_id - fk
address_id - fk

Time table: 3 -Prasad - done
time table_id -pk
class_id -fk
class_start_time  date
class_end_time  date
subject_id - fk
staff_id - fk

Class: 1 - Ashok -done
className(String)
classId(int (PK))
Description(String)
StartDate(Date)
EndDate(Date)

Branch: 1 -Ashok - done
Id(int PK)
BranchName(String (L OR G))
BranchAddress(String)

Subject: -2 - Nikil   - done
SubjectID(int )
title(String)
SubjectHeadId(int FK)-->STAFFID

Topic : 1-Nikil -  done
TopicId(intPK)
TopicName(String)
SubjectId(int FK)
Duration(Date)
title(String)

Medium: 1 - Chandra - done
MediumId(int PK)
MediumType(String)

SECTOION:1 - Chadra -done
Section-Id Integer(PK)
Section Name-String

Exam-MARKS:3 -Prasad  -done
marksId Integer (pk)
Student-Id Integer (FK) -1 - Prasasd
Subject_id Integer (FK)
Exam_Type-Id Integer(FK) - may to one - done
Date date
Marks Integer

EXAM-TYPE:1 - Prasad - done
EXAM -Id integer(pK)
Exam-Type name string

FEE-DETAILS:2 -Chandra - done
Fee-details_id integer(pk)
Fee-type Id Integer(fk)  may to one
Fee Integer

Fee-type :1 -Chandra  - done
Fee-type Id Integer(pk)
Fee -type name String

TRANSPORT:2 -Ashok -done
Transport-Id integer(pK)
Route Id Integer(fk)

Route:1 - Ashok -done
Route Id Integer(pk)
Route Name String



UI :-
1. Basic build UI (HTML-Angular) application - 5 - ParthaSaradhi

• basic login page need to develop, user name need to display in home page
• document workspace setup steps. 
• code ckeck-in.

Sprint-1 Retrospective :

What went well:-
1.sprint planning
2.technical discussion going.
3.understood requirement

What went not well :-
1.in sprint planning only few developers involved
2.Development not completed on time.
3.sprint not closed on time.
4.faced code check-in issues


Actions :-
--------
1.in sprint planning/estimation only few developers involved
->every alternative Friday sprint will start and every developer need to involve in estimation.-developers
2.Development not completed on time.
Problems :-
1. code check-in issue.
Action :
1. team need to understand code check-in process. -developers
2. need to add another developer as admin, he can quickly add/remove from github-BayaReddy
2. few developers not there in sprint planning so they don't know when they need to complete.
Action : every developer need to involve in sprint planning and estimation.-developers
3. new to development.
Action : team need to understand agile process. -developers
4. developer not planned well.
Action : need to plan well -developers
3.sprint not closed on time.
Problem :
1. not planned well
Action : need to plan well - scrum master
5.faced code check-in issues
Action : 2.1