Question: please i need a normalization for this logical diagram its for database course just i need a the normalization part for this P4 Guidelines Task

please i need a normalization for this logical diagram its for database course
just i need a the normalization part for this 
P4 Guidelines Task Deliverables (items in Database) A report containing the followings: Logical ERD (global data model) Relational database schemas (normalized up till BCNF) Data dictionary for the normalized logical design. Transform the conceptual ERD in P3 into logical ERD. (e.g.: by removing non-relational features e.g.:* relationships, complex relationships etc.) Derive relations schema from the logical ERD produced above. Perform normalization up till BCNF to these relations. Draw the final logical ERD to represent the BCNF relations produced. Update the data dictionary based on the normalized relations produced from above. Validate logical ERD with the system's transaction requirements. Assessment based on report Prepare a Database conceptual design as below: 1.0 2.0 3.0 4.0 Introduction Overview of project Database conceptual design 3.1 Update business rule 3.2 Conceptual ERD DB logical design 4.1 Logical ERD 4.2 Updated Data dictionary 4.3 Normalization Relational DB Schemas (after normalization) SQL Statements (DDL & DML) Summary 5.0 6.0 7.0 Acti Go to Booking Navagation bookID (PK) paymentM {FK) address {F} username {FK) poNo. {FK) placeID {FK arrival departure direction {FK} -1.4 allows -1..1- placeName {FK} placelD {FK} address {FK) direction (PK) 0..1 allows 1 1..* Place 1..* 1.* Tourist Add placeID {PK} placeName description availability username {PK password poNo. address payment 1..1 Payment placeID {FK} placeFee paymentM {FK) totalFee -1..1 -gets- 0..1 Booking Order orderld {PK} dateOrdered placel {FK) username {FK)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
