Bessekai. Anime Cyclopedia

1.

Department of Information Systems and Mathematical Modeling
Anime Cyclopedia
IS 134K
Mussirov Alisher
Khakimov Temudjin
Almaty 2016

2.

Main purpose of our project is to
implement a website for anime fans
where users can maintain a list of
watched anime and communicate
with other users.

3.

1. Make an ER-diagram of Bessekai
2. Convert ER-diagram in the conceptual
schema and normalize the table.
3. Make SQL-scripts to create database
tables.
4. SQL-scripts to be developed for the
database management system.
5. Develop the necessary constraints for
the construction of the database.
6. Develop a Bessekai!

4.

The number of anime fans is
increasing from year to year. And
Bessekai will help newfags to choose
which anime to watch and on the
other hand it will help otakus to
remember what titles did they
watched.

5.

Actually there are some
websites with idea of list of
anime, however they are not
ideal, and we put structure of
our website as main, therefore
our project is more convenient.

6.

Myanimelist

7.

Research
One of needs of anime fan is
having a single database
where he/she can see their
watched anime and marks to
them, select objects and
other advantages of the
credit system.

8.

9.

Mapping
Step 1
anime(id)
PK: anime_id
to_add(id)
PK: to_add_id
user(id)
PK: user_id
watch(id)
PK: watch_id
comment(id)
PK: comment_id
Step 4
watch(id,anime_id,user_id,status)
PK: watch_id
FK: anime_id, user_id
to_add(id,anime_id,user_id,status)
PK: to_add_id
FK: anime_id, user_id
comments(id,anime_id,user_id,content,time)
PK: comments_id
FK: anime_id, user_id

10.

User_ID User_name User_name Anime_ID Anime_name Anime_rating
1
2
3
Uri28
Sasha
Mayuri_tuturu
Lena
LelouchLamperouge Misha
11
22
32
Clannad
Code Geass
Kiss x Sis
9.26
9.14
7.29
Planned_ID Planned_Anime
111
Clannad
222
333
1) 1st Normal Form
2) Primary keys: User_ID, anime_ID. Planed_ID
3) Full dep: (User_ID, Anime_ID, Planed_ID) -> {Username, User_name,
Anime_rating, Planned_Anime}
Fd1 (User_ID)->{Username, User_name}
Fd2 (Anime_ID)->{Anime_name, Rating }
Fd3 (Planed_ID)->{Planed_Anime}
4) Insertion Anomalies

11.

User_ID Username
User_name Anime_ID Anime_name
1
Uri28
Sasha
11
Clannad
2 Mayuri_tuturu
Lena
22
Code Geass
3 LelouchLamperouge Misha
32
Kiss x Sis
Anime_rating
9.26
9.14
7.29
Planned_ID Planned_Anime
111
Clannad
222
Code Geass
333
Kiss x Sis
1) Unnormal
2) Primary keys: User_ID, anime_ID. Planed_ID
3) Full dep: (User_ID, Anime_ID, Planed_ID) -> {Username, User_name, Anime_rating,
Planned_Anime}
Fd1 (User_ID)->{Username, User_name}
Fd2 (Anime_ID)->{Anime_name, Rating }
Fd3 (Planed_ID)->{Planed_Anime}
4) No Anomalies ^_^

12.

User_ID Username User_name
1
Uri28
Sasha
2
Mayuri_tuturu
Lena
3
LelouchLamperouge Misha
1) 2nd Normal Form
2) Primary keys: User_ID
3) Full dep: User_ID -> {Username,
4) Without anomalies
User_name}

13.

Anime_ID Anime_name
11
Clannad
22
Code Geass
33
Kiss x Sis
Anime_rating
9.26
9.14
7.29
1) 2nd Normal Form
2) Primary keys: Anime_ID
3) Full dep: Anime_ID -> {Anime_name,
4) Without anomalies
Anime_rating}

14.

Planned_ID
111
222
333
Planned_Anime
Clannad
Code Geass
Kiss x Sis
1) 2nd Normal Form
2) Primary keys: Planned_ID
3) Full dep: Planned_ID -> {Planned_Anime}
4) Without anomalies

15.

User_ID Username User_name
1
Uri28
Sasha
2
Mayuri_tuturu
Lena
3
LelouchLamperouge Misha
1) 3rd Normal Form
2) Primary keys: User_ID
3) Full dep: User_ID -> {Username,
4) Without anomalies
5) Foreign key: No
User_name}

16.

Anime_ID Anime_name
11
Clannad
22
Code Geass
33
Kiss x Sis
Anime_rating
9.26
9.14
7.29
1) 3rd Normal Form
2) Primary keys: Anime_ID
3) Full dep: Anime_ID -> {Anime_name,
4) Without anomalies
5) Foreign key: No
Anime_rating}

17.

Planned_ID User_ID Anime_ID
11
Clannad
9.26
22
Code Geass
9.14
33
Kiss x Sis
7.29
1) 3rd Normal Form
2) Primary keys: Planned_ID
3) Foreign key: User_ID, Anime_ID
4) Full dep: Planned_ID -> {User_ID, Anime_ID}
Full dep1: Planedid -> User_ID->{Username, User_name}
Full dep2: Planedid -> Anime_ID ->{ Anime_name, Anime_Rating ...}

18.

19.

The Bessekai now can help people to choose anime
and discuss it on comments. Now anime fan’s can
communicate with each other.