Topic : Database SystemsPlease follow the picture form answer these question! Vis Library is a multi-categories book library that provides a wide range of genres from kids books to special braille books. The customers can read the books on-site or choose a delivery service. As a database designer, they want you to design and implement a database to support their business. At the initial meeting to discuss the database design, the following requirements were gathered: A new customer is required to register the account, pick the membership type, and pay the necessary cost.The systems must be able to manage the detailed information of each member.There are two membership types: silver dan gold. This membership is necessary to borrow books and read on the spot.Silver membership can be obtained by showing the id card and filling the registration form without any cost.On the other hand, Rp 20000 registration costs and Rp 10000 monthly costs are needed to get a gold membership.Gold member is entitled to special delivery and pick-up services from Vis Library to avoid a late book return.The systems must be able to manage the detailed information of each book including its availability.Each member can borrow only two books in one transaction, and the borrowing period is 7 working days.There is an AudioBook version for some of the books. To distinguish the physical book from its Audio version, a different product_id format will be applied. The physical book will have 10-digits numbers, while the audio version id will be started by “AU” and followed by 3-digit numbers (e.g., AU241).Each late book return will be fined Rp. 1000 per day, and the maximum fine is Rp. 20000.All book borrowing services in Vis Library will be handled by a registered and authorized operator.Book delivery and pick-up service will be scheduled by the operator and to be assigned to a courier.Several forms are required for the system. Three main important ones are:Loan Form, capture all information related to a book borrowing transactionReturn Form, capture detailed information of all books return and the conditionMember Profile, capture detailed information of each memberBased on the form and explanation above,1. Please create a set of third normal form relations. You must show all relations at each stage in the normalization process! (20%)2. Please create an appropriate ERD, including the relationship and multiplicity! (20%)3. Based on the ERD that you made, please create the entire table and the constraints (based on the explanation above)! (20%) 4. Based on your table (in point 3), please change the constraint for physical book product_id with this format: started with “PBV” and followed by 4-digit numbers (e.g., PBV4252)! (10%)5. Please create a 3-minutes video to explain the normalization process (in point 1). Please include the link to your video in your answer sheet! LOAN FORMВookldBook TitleEdition ISBN/ISSN | QTYAudioLoanВookGigi Si CiciSeri111Rp. 0Rp.000000152629792024506Available000001525319792024459AvailableTokohTernama9: AlexanderGraham BellDelivery FeeTotalRp.10000Rp.10000Jakarta, 10/21/2021Aliya Return FormReturn Date:11/03/2021: G202163: AleenaMember IdReturn DayOperator IdOperator NameMember Type: Wednesday: OP13: Nania: GoldMember NameMember Address: Sawi Street No.23Jakarta, 14252:12/29/2001Member DOBВookldBook TitleEdition ISBN/ISSN QTY AudioВookFineConditionВookAvailableAvailableGigi Si CiciRp.2000Rp.20000000015262197920245061Good0000015253Seri11Good9792024459TokohTernama9: AlexanderGraham BellPick-up FeeTotalRp.4000Jakarta, 11/03/2021NaniaMember Profile: G202163Id Card Numer : 3271098918237: Aleena: 12/29/2001Member Phone : 0817485767Member Address : Sawi StreetMember IdMember NameMember DOBNo.23 Jakarta,14252

Let us create the UNF table first and gradually we will normalized the table upto 3NF to get the ERD…

Answered: Return Form Return Date :11/03/2021 :…

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Question

Topic : Database Systems

Please follow the picture form answer these question!

Vis Library is a multi-categories book library that provides a wide range of genres from kids books to special braille books. The customers can read the books on-site or choose a delivery service. As a database designer, they want you to design and implement a database to support their business.

At the initial meeting to discuss the database design, the following requirements were gathered:

A new customer is required to register the account, pick the membership type, and pay the necessary cost.
The systems must be able to manage the detailed information of each member.
There are two membership types: silver dan gold. This membership is necessary to borrow books and read on the spot.
Silver membership can be obtained by showing the id card and filling the registration form without any cost.
On the other hand, Rp 20000 registration costs and Rp 10000 monthly costs are needed to get a gold membership.
Gold member is entitled to special delivery and pick-up services from Vis Library to avoid a late book return.
The systems must be able to manage the detailed information of each book including its availability.
Each member can borrow only two books in one transaction, and the borrowing period is 7 working days.
There is an AudioBook version for some of the books. To distinguish the physical book from its Audio version, a different product_id format will be applied. The physical book will have 10-digits numbers, while the audio version id will be started by “AU” and followed by 3-digit numbers (e.g., AU241).
Each late book return will be fined Rp. 1000 per day, and the maximum fine is Rp. 20000.
All book borrowing services in Vis Library will be handled by a registered and authorized operator.
Book delivery and pick-up service will be scheduled by the operator and to be assigned to a courier.
Several forms are required for the system. Three main important ones are:

Loan Form, capture all information related to a book borrowing transaction
Return Form, capture detailed information of all books return and the condition
Member Profile, capture detailed information of each member

Based on the form and explanation above,
1. Please create a set of third normal form relations. You must show all relations at each
stage in the normalization process! (20%)
2. Please create an appropriate ERD, including the relationship and multiplicity!
(20%)
3. Based on the ERD that you made, please create the entire table and the constraints
(based on the explanation above)! (20%)
4. Based on your table (in point 3), please change the constraint for physical book
product_id with this format: started with “PBV” and followed by 4-digit numbers (e.g.,
PBV4252)! (10%)
5. Please create a 3-minutes video to explain the normalization process (in point 1). Please
include the link to your video in your answer sheet!

LOAN FORM
Вookld
Book Title
Edition ISBN/ISSN | QTY
Audio
Loan
Вook
Gigi Si Cici
Seri
1
1
1
Rp. 0
Rp.0
0000015262
9792024506
Available
0000015253
1
9792024459
Available
TokohTernama
9: Alexander
Graham Bell
Delivery Fee
Total
Rp.10000
Rp.10000
Jakarta, 10/21/2021
Aliya

Transcribed Image Text:Return Form Return Date :11/03/2021 : G202163 : Aleena Member Id Return Day Operator Id Operator Name Member Type : Wednesday : OP13 : Nania : Gold Member Name Member Address : Sawi Street No.23 Jakarta, 14252 :12/29/2001 Member DOB Вookld Book Title Edition ISBN/ISSN QTY Audio Вook Fine Condition Вook Available Available Gigi Si Cici Rp.2000 Rp.2000 0000015262 1 9792024506 1 Good 0000015253 Seri 1 1 Good 9792024459 TokohTernama 9: Alexander Graham Bell Pick-up Fee Total Rp.4000 Jakarta, 11/03/2021 Nania Member Profile : G202163 Id Card Numer : 3271098918237 : Aleena : 12/29/2001 Member Phone : 0817485767 Member Address : Sawi Street Member Id Member Name Member DOB No.23 Jakarta,14252

Expert Solution