Case Perpustakaan Nasional Indonesia is the largest library in Indonesia which is provides a facility to borrow book nat
Posted: Fri Apr 29, 2022 6:40 am
Case
Perpustakaan Nasional Indonesia is the largest library in Indonesia
which is provides a facility to borrow book nationally and open for
public. In pandemic era, Perpustakaan Nasional wants to digitalize
the borrowing method, so it will be less human interaction and all
borrowed books will be easier to track using website. Every
borrower is bound to do a registration which requires them to fill
in the personal data: full name, address, birth date, email, and
telephone number. After all the data is filled, then the borrower
needs to click submit button. If the borrowers already
registered as the library member, then they only need to sign in
with their member number provided after the registration process.
Upon signed in, to borrow books, the borrower needs to find the
borrowed book (up to three books) and fill in its data: book code
and book title. Then the system will do automatic logging for the
borrowed date, duration, and its returned date. For the last step
of borrowing books, the borrower needs to click submit button on
the website. If the borrower returns the book past its due dates,
then they need to pay the due penalty which calculated with the
total number of dates elapses after the due until it was returned
which already generated automatically by the system.
Based on the case above:
1. Create a normalization 1NF – 3NF to help the logical design of
book borrowing.
2. Upon normalization completed, create an ERD.
3. Create an query (DDL) for every listed entities, specify
its type, character length and at least one constraint in every
entity.
4. Create an query (DML) for every operation below:
a. Insert to member table, insert every member which “Alexandra
Westin” for its name.
b. Update the existing member information with “Alexandra Westin”
to “Alexandra Westina”.
c. Show the member information for every name that starts with “A”
letter.
Perpustakaan Nasional Indonesia is the largest library in Indonesia
which is provides a facility to borrow book nationally and open for
public. In pandemic era, Perpustakaan Nasional wants to digitalize
the borrowing method, so it will be less human interaction and all
borrowed books will be easier to track using website. Every
borrower is bound to do a registration which requires them to fill
in the personal data: full name, address, birth date, email, and
telephone number. After all the data is filled, then the borrower
needs to click submit button. If the borrowers already
registered as the library member, then they only need to sign in
with their member number provided after the registration process.
Upon signed in, to borrow books, the borrower needs to find the
borrowed book (up to three books) and fill in its data: book code
and book title. Then the system will do automatic logging for the
borrowed date, duration, and its returned date. For the last step
of borrowing books, the borrower needs to click submit button on
the website. If the borrower returns the book past its due dates,
then they need to pay the due penalty which calculated with the
total number of dates elapses after the due until it was returned
which already generated automatically by the system.
Based on the case above:
1. Create a normalization 1NF – 3NF to help the logical design of
book borrowing.
2. Upon normalization completed, create an ERD.
3. Create an query (DDL) for every listed entities, specify
its type, character length and at least one constraint in every
entity.
4. Create an query (DML) for every operation below:
a. Insert to member table, insert every member which “Alexandra
Westin” for its name.
b. Update the existing member information with “Alexandra Westin”
to “Alexandra Westina”.
c. Show the member information for every name that starts with “A”
letter.