Customer Relationship Management System

computing - the system? ERD .. a bit of help?

I got a computing project to do and i chose to design a Hotel Management System. It can manage employees by having their profiles on the system, calculate the net pay of each employee and it can also book rooms/cancel rooms for customers. Im really confused and i dont know how to make an erd from this, i need to have one to many relationship instead of many to many. I guess the bit i dont quite understand is how to link something like booking with the other parts ... as it has to be in one ERD not multiple ones. thx 4 any help

Public Comments

1. 2 things. First, and ERD can have any number of tables in it. There's no reason to have multple ERD's 2nd, when reduced to a physical model, relational databases can not resolve many to many relationships-- they require a many to many resolver table between the tables that have the logical M-M relationship. Start by listing the entities you have -- employees, rooms, customers, jobs, etc. Then determine how these basic entities relate to each other. The important thing is not attribute attributes to the basic entities when they don't belong. For example, a rookie mistake would be to assign a Pay rate to an employee. The pay rate should go in the table that relates the employee to the job that employee holds. This then allows for the possibility that an employee might have multiple jobs at the hotel over a period of time. In general, it's really all about following the basic rules of normalization, and reading up on database design patterns.
2. Take A look on freshbloger.com