Data base design Essay Example | Topics and Well Written Essays - 1000 words

Data base design - Essay ExampleReqLayoutEquipmentTypeRoomRoomno(PK) pretend(Room Name or Eating field of honor description)Roomtype(Conf. Or Eating)CapacityCostpersessionOpenforRefreshmentMealDetailOrgCode(PK)RMdate(PK)(where RM is refreshment and Meal)RMtime(PK)Roomno/Mealroom(PK)OrderId(PK)Ordertype(refreshment / meal)QuantityOrderOrderId(PK) commentary(beverage name, lunch, dinner, evening)3NFEliminate columns not dependent on the describe. If attributes do not contribute to a description of the key, demand them to a separate elude. All non-key fields must be exclusively dependent on the key field. Over here either tables in 2NF are already in 3NF as follows musical arrangement Orgcode(PK)OrgNameOrgAddressOrgPostcodeOrgContactOrgTelOrgFaxOrgEventNosExpected involutionOrgCode(PK)BookDate(PK)Roomno(PK)Session(PK)ReqLayoutEquipmentTypeRoomRoomno(PK)Name(Room Name or Eating area description)Roomtype(Conf. Or Eating)CapacityCostpersessionOpenforRefreshmentMealDetailOrgCode(PK)RM date(PK)(where RM is refreshment and Meal)RMtime(PK)Roomno/Mealroom(PK)OrderId(PK)Ordertype(refreshment / meal)QuantityOrderOrderId(PK)Description(beverage name, lunch, dinner, evening)4NFIsolate independent multiple relationships. No table may look into two or more 1n or nm relationships that are not directly related. All tables which are in 3NF are already in 4NF provided Booking table.OrganizationOrgcode(PK)OrgNameOrgAddressOrgPostcodeOrgContactOrgTelOrgFaxOrgEventNosExpectedBookingOrgCode(PK)BookDate(PK)Roomno(PK)Session(PK)LayoutidEquipIdLayoutLayoutid(PK)DescriptionEquipmentEquipId(PK)DescriptionRoomRoomno(PK)Name(Room Name or Eating area description)Roomtype(Conf. Or...All non-key fields must be exclusively dependent on the key field. Over here all tables in 2NF are already in 3NF as followsIsolate independent multiple relationships. No table may contain two or more 1n or nm relationships that are not directly related. All tables which are in 3NF are already in 4NF that Bo oking table.Isolate semantically related multiple relationships. There may be practical constraints on information that justify separating logically related many-to-many relationships. All tables in 4NF are already in 5NF except Room table.