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

please i need a normalization for this logical diagram its for database course

just i need a the normalization part for this database course just i need a the normalization part for this P4

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!