0% found this document useful (0 votes)
29 views7 pages

Features Table Boarding - Owner - ID: Parking Parking Space

The document contains information about boarding owners, students, and boarding properties. It includes tables with data on boarding owner ID, name, phone number, email, and more. It also has tables with data on student ID, university, name, and graduation date. Additionally, it includes data on boarding properties like kitchen facilities, bathroom access, gender restrictions, rent fees and more.

Uploaded by

maneka bandara
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
29 views7 pages

Features Table Boarding - Owner - ID: Parking Parking Space

The document contains information about boarding owners, students, and boarding properties. It includes tables with data on boarding owner ID, name, phone number, email, and more. It also has tables with data on student ID, university, name, and graduation date. Additionally, it includes data on boarding properties like kitchen facilities, bathroom access, gender restrictions, rent fees and more.

Uploaded by

maneka bandara
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 7

features Table

Boarding_Owner_ID Parking Parking Space


1 yes No
2 yes Yes
3 yes No
4 yes No
5 yes No
6 No Yes
7 yes no
8 no yes
9 yes no
10 no yes

Boarding Owner Table

Boarding_0wner_ID Bo _Name Phonnum


1 Nimal 768780981
2 Geetha 768780980
3 Malani 768560980
4 Mala 768900980
5 Nimal 767880980
6 Aravinda 768780560
7 palitha 768775580
8 senaka 788780980
9 Nimal 768756980
10 Palitha 768770980
768778980

Student_ID University_Mail University Student _Name


S01 hmmm@jhjhuhi NSBM Hansamali
S02 huiuiooo@jkiuioi NSBM Shehan
S03 liiouiuhh@hkjkljl Colombo Lakshitha
S04 ryuyioo@jilopuio colombo Lakshitha
S05 gtuijkkvvr@mkkk Kelaniya maneka
S06 gyuuiioooo@jklooo NSBM Kalindu
1NF

Kitchen Town University_Distence_to_Boarding


yes Homagama 10 m
yes Homagama 19 m
yes Kelaniya 12 m
no Colombo 11 km
no Kottawa 14 km
yes Maharagama 20 m
no Homagama 18 m
yes Colombo 17 km
yes Pannipitiya 18 km
yes Kottawa 17 km

Email Join_Date Expire Date Image


manekab2024@gmail.com 2020.10.10 2020.11.10
manekab2025@gmail.com 2020.10.11 2020.11.11
manekab2026@gmail.com 2020.10.13 2020.11.13
manekab2027@gmail.com 2020.10.13 2020.11.13
manekab2028@gmail.com 2020.10.14 2020.11.15
manekab20249@gmail.com 2020.10.14 2020.11.15
manekab24@gmail.com 2020.10.16 2020.11.17
manekab7824@gmail.com 2020.10.10 2020.11.18
manekab206794@gmail.com 2020.10.18 2020.11.19
manekab29974@gmail.com 2020.10.19 2020.11.20
manekab26767894@gmail.com 2020.10.26 2020.11.21

Graduation_Date
2023
2023
2024
2024
2022
2025
Attatched Bathroom Gender RentFee
yes Ladies Only 5000
yes Boys only 10000
yes Boys only 6000
yes Ladies Only 6000
yes Ladies Only 12000
no Ladies Only 25000
no Boys only 4500
no Boys only 7000
no Boys only 5500
no Ladies Only 12000
features Table

Boarding_Owner_ID Parking Parking Space


1 yes No
2 yes Yes
3 yes No
4 yes No
5 yes No
6 No Yes
7 yes no
8 no yes
9 yes no
10 no yes

Boarding Owner Table

Boarding_0wner_ID Phonnum Email Join_Date


1 768780981 manekab2024@gmail.com 2020.10.10
2 768780980 manekab2025@gmail.com 2020.10.11
3 768560980 manekab2026@gmail.com 2020.10.13
4 768900970 manekab2027@gmail.com 2020.10.13
5 767880980 manekab2028@gmail.com 2020.10.14
6 768780560 manekab20249@gmail.com 2020.10.14
7 768775580 manekab24@gmail.com 2020.10.16
8 788780980 manekab7824@gmail.com 2020.10.10
9 768756980 manekab206794@gmail.com 2020.10.18
10 768770980 manekab29974@gmail.com 2020.10.19

Student Table

Student_ID University_Mail University


S01 hmmm@jhjhuhi NSBM
S02 huiuiooo@jkiuioi NSBM
S03 liiouiuhh@hkjkljl Colombo
S04 ryuyioo@jilopuio colombo
S05 gtuijkkvvr@mkkk Kelaniya
S06 gyuuiioooo@jklooo NSBM
Kitchen University_Distence_to_Boarding
yes 10 m
yes 10 m
yes 12 m
no 11 km
no 14 km
yes 20 m
no 18 m
yes 17 km
yes 18 km
yes 17 km

Expire Date Image


2020.11.10
2020.11.11
2020.11.13
2020.11.13
2020.11.15
2020.11.15
2020.11.17
2020.11.18
2020.11.19
2020.11.20

Student_ID Student _Name


S01 Hansamali
S02 Shehan
S03 Lakshitha
S04 Lakshitha
S05 maneka
S06 Kalindu
Attatched Bathroom Gender RentFee Boarding_Owner_ID
yes Ladies Only 5000 1
yes Boys only 10000 2
yes Boys only 6000 3
yes Ladies Only 6000 4
yes Ladies Only 12000 5
no Ladies Only 25000 6
no Boys only 4500 7
no Boys only 7000 8
no Boys only 5500 9
no Ladies Only 12000 10

Main Tb

Boarding_0wner_ID Bo _Name
1 Nimal
2 Geetha
3 Malani
4 Malani
5 Nimal
6 Aravinda
7 palitha
8 senaka
9 Nimal
10 Palitha

Student_ID Graduation_Date
S01 2023
S02 2023
S03 2024
S04 2024
S05 2022
S06 2025
Boarding_Owner_ID Town
Homagama
Homagama
Kelaniya
Colombo
Kottawa
Maharagama
Homagama
Colombo
Pannipitiya
Kottawa

You might also like