1 / 13

Data base project

AN_Najah national university. Data base project. (For alloban primary school ). Falasteen nobane. Eman abuzaid. Description. Entity Relationship Diagram. Description for Student’s Entity and Attributes. Student’s entity :

hogan
Download Presentation

Data base project

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. AN_Najah national university Data base project (For alloban primary school ) Falasteen nobane Eman abuzaid

  2. Description Entity Relationship Diagram

  3. Description for Student’s Entity and Attributes Student’s entity: Each student will have various of attributes , on which we choose the primarykey depending on collection of attributes that distinct all together the entity . Student number (STU_ID) which composite three attributes : Serial number (serial_no) :contain six digits . Sex: contain one digit either 1 for male or 2 for female . YOE (year of entering) : contain 2 digit representing in which year the student enter the school. Previous three attributes are gathered in one attribute compound key , (STU_ID ) which represent primary key.

  4. Student name containing the full name of each student represented by (Name) : first name (fname) , father name (faname) , grandfather name (grname) , last name(lname) . Birth date (B_Date) : represented by month / day / year . student Subject , which subjects each student take represented by (subject) which is a multi_valued attribute it values are Subject { Arabic, English , History , Art , Geographic , Science , Sport , Technology , Math , Religion , National , Civic } . Telephone number (Tel) : represent telephone (house) number , telephone (mobile) number . Student’s religion ( Religion) . Student’s address : Address { city , street , apart_no}. Student’s class : class {type} type represent the type of the class . Student’s age : (Age ) derived attribute . student’s class : class{ first class , second class , third class , forth , class , fifth class}. Class’s type: type { A , B , C }.

  5. Description for Employee’s Entity and attributes: Employee entity: Employee name containing the full name of each employee represented by (Name) : first name (fname) , father name (faname) , grandfather name (grname) , last name(lname) . Serial number (serial_no) :contain three digits which represent primarykey for each employee within the school. Employee identification number represented by ( empid) . Birth date (B_Date) : represented by month / day / year . Employee Subject , which subjects each employee teach some employee subject could be NULL represented by (subject) which is a multi_valued attribute it values are Subject { Arabic, English , History , Art , Geographic , Science , Sport , Technology , Math , Religion , National , Civic } . Telephone number (Tel) : represent Tel{ telephone (house) number , telephone (mobile) number } .

  6. Employee address : Address { city , street , apart_no}. Employee age : (Age ) derived attribute . Employee work hours ( Hours ): calculating teaching hours for that each teacher and administrator do weekly . Employee college degree (college_degree) for each employee specific college degree or more than one . Employee position (position) which specify if the employee work in the school full time job Which means that he does not for another school or part time job means that he work for another school .

  7. Description for Subject’s Entity and Attributes Subject’s entity: Both student’s entity and employee’s entity have it’s own relation with subject ’s entity . Subject’s attributes : S_name :subject name Level :level of the class (first ,second ,third ,forth,fifth,sixth) Techers who belong to employee teach many students and many subjects Many student take many subjects and teach by many teachers Every student must teach by teacher Teach relation ship: Attribute (date,day,time) Give relation ship : Attribute (class)

  8. x Sex YOE faname Serial_no lname grname fname B B_Date STU_ID STU_ID Nameme Age Age student B Tel.me subject Tel. Ac class A Address Ac Ac type Religion AparNO city street

  9. faname grname laname fname Serial no Name Hours subjects College_ degree s employee Age position Address Tel.me B_Date Tel. city ApartNO. street

  10. v S_name Subject level

  11. Administrative N Employee 1 Class 1 Date M day Give teach Time P N N student Subject

  12. Relational schema

  13. Employee(serial num , fname,faname,laname,hours,position,city,street,apart_no, b_date, admid) Emp subject(subject,serial num) Emp tel (tel,serial num) Emp collage _degree(collage degree,serial num) Student (serialno , sex , yoe, fname , faname , grname , lname, class, type , religion , b_date , city ,street,apartno) Stu subject(subject , serialno,sex,yoe) Stu telephone(tele, serialno,sex,yoe) subject(level,s_name,seial_num,class) teach (date,time,day,serial num,serialno,sex,yoe,level,s_name )

More Related