Ask a question from expert

Ask now

CSI5135 - Assignment on Systems and Database Design

9 Pages709 Words156 Views
   

Edith Cowan University Australia

   

Systems and Database Design (CSI5135)

   

Added on  2020-03-07

About This Document

CSI5135 -  The assignment consists of four tasks, focusing on normalization and entity-relationship modeling.

CSI5135 - Assignment on Systems and Database Design

   

Edith Cowan University Australia

   

Systems and Database Design (CSI5135)

   Added on 2020-03-07

BookmarkShareRelated Documents
CSG1207/CSI5135Assignment 1Student NameStudent CodeInstructor Name
CSI5135 - Assignment on Systems and Database Design_1
Task 10NFR1 = (customerPhone, customerName, room#, roomDescription {bookingID, bookingDateTime, bookingDuration, bookingPaid, bookingNotes, staffID, staffName})1NFR1 = (customerPhone, customerName, roomID, room#, roomDescription {bookingID, bookingDateTime, bookingDuration, bookingPaid, bookingNotes, staffID, staffName})R11 = (customerPhone, customerName, room#, roomDescription)R12 = (bookingID, customerPhone, bookingDateTime, bookingDuration, bookingPaid, bookingNotes, staffID, staffName)2NFR11 = (customerPhone, customerName, room#, roomDescription)R12 = (bookingID, customerPhone, bookingDateTime, bookingDuration, bookingPaid, bookingNotes, staffID, staffName)R121 = (bookingID, customerPhone, staffID, bookingDateTime, bookingDuration, bookingPaid, bookingNotes)R122 = (staffID, staffName)3NFR11 = (customerPhone, customerName, room#, roomDescription)R111 = (customerPhone, customerName, room#)R112 = (room#, roomDescription)R121 = (bookingID, customerPhone, staffID, bookingDateTime, bookingDuration, bookingPaid, bookingNotes)R122 = (staffID, staffName)
CSI5135 - Assignment on Systems and Database Design_2
Final Named RelationsRoom (room#, roomDescription)Customer (customerPhone, customerName, room#)Staff (staffID, staffName)Booking (bookingID, customerPhone, staffID, bookingDateTime, bookingDuration, bookingPaid, bookingNotes))Physical ERDAssumptions1.One customer can book multiple rooms2.Staff can utilize bookingNotes for further reference3.Customer Number will be unique
CSI5135 - Assignment on Systems and Database Design_3

End of preview

Want to access all the pages? Upload your documents or become a member.