ASSESSMENT COVERSHEET

Attach this coversheet as the cover of your submission. All sections must be completed.
Section A: Submission Details
Programme : DIPLOMA IN INFORMATION TECHNOLOGY
Course Code & Name : ITD22403, DATABASE SYSTEMS
Course Lecturer(s) : MISS AMALIA MUKHLAS
Submission Title : PROJECT PROPOSAL & PROJECT PROGRESS
Deadline : Decembe
Day 6 Month Year 2021 Time 12AM
r
Penalties :  5% will be deducted per day to a maximum of four (4) working days, after which the submission will
not be accepted.
 Plagiarised work is an Academic Offence in University Rules & Regulations and will be penalised
accordingly.

Section B: Academic Integrity

Tick (√) each box below if you agree:

√ I have read and understood the UniKL’s policy on Plagiarism in University Rules & Regulations.
√ This submission is my own, unless indicated with proper referencing.
√ This submission has not been previously submitted or published.
√ This submission follows the requirements stated in the course.

Section C: Submission Receipt

(must be filled in manually)

Office Receipt of Submission

Date & Time of
Student Name(s) Student ID(s)
Submission (stamp)
17/11/2021 MUHAMMAD ARIF BIN MOHAMAD YUSOF 52101120020
NUR WITRAH ATIKAH BINTI SYALMAN 52101120139
NUR DINI ASYIQIN BINTI ILHAM ARMALIS 52101120122

Student Receipt of Submission

This is your submission receipt, the only accepted evidence that you have submitted your work. After this is stamped by
the appointed staff & filled in, cut along the dotted lines above & retain this for your record.

Date & Time of

Course Code Submission Title Student ID(s) & Signature(s)
Submission (stamp)
17/11/2021 ITD22303 Project Progress 52101120020
52101120139
52101120122

Normalization

1NF

Book

ISBN_number Book_name Author Publisher Publish_date

978931295 Computer Saurabh Sighal MCA Department 20/9/2018
Networks
978935019 Junior Level Amit Garg Reader Zone 29/5/2011
Books
978938067 Client Server Kumar Sun India 6/8/2012
Computing Publications
978938087 CBOT Gunjan Verma Thakur 18/1/2020
Publications
978938596 Computer Sharad Kumar Sun India 1/9/2015
Networks Verma Publications

Student

Student_id Student_name Gender Age Student_contact Student_email

20020 Arif Yusof Male 19 1121960527 arifyusmarif@gmail.com
20122 Dini Asyiqin Female 19 147152840 diniasyiqin@gmail.com
20139 Witrah Atikah Female 19 122000806 witrahatikah@gmail.co
m
20208 Arif Fiqri Male 19 124009806 ariffiqri@gmail.com
20315 Aqil Qayyim Male 19 1121960527 aqilqayyim@gmail.com

2NF

Borrowing

Borrowing_id ISBN_Number Student_id Date_borrowed Date_return

1 978935019 20020 1/7/2021 14/7/2021
2 978938067 20122 1/10/2021 14/10/2021
3 978938596 20139 1/11/2021 14/11/2021
4 978938087 20208 1/9/2021 14/11/2021
5 978931295 20315 1/6/2021 14/6/2021

Transaction

Transaction_id Transaction_name Borrowing_id Student_id Transaction_dat

e
1000 Overdue Fine 1 20020 16 / 7 /2021
1001 Overdue Fine 2 20122 16 / 9 /2021
1002 Overdue Fine 3 20139 16 / 11 /2021
1003 Overdue Fine 4 20208 16 / 11 / 2021
1004 Overdue Fine 5 20315 16 / 8 / 2021

Reports

Report_id Transaction_id Borrowing_id Report_date

100 1000 1 15/7/2021
101 1001 2 15/10/2021
102 1002 3 15/11/2021
103 1003 4 15/11/2021
104 1004 5 15/11/2021

3NF

Book_Student_Borrowing

Borrowing_id ISBN_number Student_id Date_borrowed Date_return

1 978935019 20020 1/7/2021 14/7/2021
2 978938067 20122 1/10/2021 14/10/2021
3 978938596 20139 1/11/2021 14/11/2021
4 978938087 20208 1/9/2021 14/11/2021
5 978931295 20315 1/6/2021 14/6/2021
SQL Script

CREATE TABLE Book

(ISBN_number) NUMBER(11), NOT NULL,
Book _name NUMBER(11), NOT NULL,
Author VARCHAR(30),
Publisher VARCHAR(30),
Publisher_date DATE,
CONSTRAINT Book_PK PRIMARY KEY (ISBN_number));

CREATE TABLE Student

(Student_id NUMBER(11), NOT NULL,
Student_name VARCHAR(11), NOT NULL,
Gender VARCHAR(30),
Age VARCHAR(11),
Student_contact VARCHAR(30),
Student_email VARCHAR(30),
CONSTRAINT Student_PK PRIMARY KEY (Student_id));

CREATE TABLE Borrowing

(Borrowing_id NUMBER(11), NOT NULL,
ISBN_number NUMBER(11), NOT NULL,
Student_id NUMBER(11), NOT NULL,
Date_borrowed DATE,
Date_return DATE,
CONSTRAINT Borrowing_PK PRIMARY KEY(Borrowing_id)),
CONSTRAINT Borrowing_FK FOREIGN KEY((ISBN_number) REFERENCES Book(ISBN_number))
CONSTRAINT Borrowing_PK FOREIGN KEY((Student_id) REFERENCES Student(Student_id));

CREATE TABLE Reports

(Reports_id NUMBER(11), NOT NULL,
Transaction_id NUMBER(11), NOT NULL,
Borrowing_id NUMBER(11),
Report_date DATE,
CONSTRAINT Reports_PK PRIMARY KEY(Reports_id)),
CONSTRAINT Reports_FK FOREIGN KEY((Transaction_id) REFERENCES Transaction(Transaction_id)),
CONSTRAINT Reports_FK FOREIGN KEY((Borrowing_id)) REFERENCES ;

CREATE TABLE Transaction

(Transaction_id NUMBER(11) NOT NULL,
Transaction_name NUMBER(11) NOT NULL,
Borrowing_id NUMBER(11) NOT NULL,
Student_id NUMBER(11) NOT NULL,
Transaction_date DATE,
CONSTRAINT Borrowing_PK PRIMARY KEY(Transaction_id)),
CONSTRAINT Borrowing_FK FOREIGN KEY((Borrowing_id) REFERENCES Borrowing(Borrowing_id)),
CONSTRAINT Borrowing_PK FOREIGN KEY((Student_id)) REFERENCES Student(Student_id)) ;
SELECT BORROWING.Borrowing_id, BOOK.ISBN_number, STUDENT.Student_id,
BORROWING.Date_borrowed, BORROWING.Date_return
FROM STUDENT INNER JOIN BOOK INNER JOIN BORROWING ON BOOK.ISBN_number =
BORROWING.ISBN_number ON STUDENT.Student_id = BORROWING.Student_id;

Database created in MySQL

Book

Student
Borrowing

Reports
Transaction

Borrowing_Book_Student
GUI Forms

Book Form

Student Form
Borrowing Form

Transaction Form
 Reports Form

Borrowing Sub Form

Student FORM