The system will achieve the goals of the project, which align with business obje

Question

The system will achieve the goals of the project, which align with business objectives through the new technology, which it uses to communicate between customers, staff of services, and mangers in hotel. It gives a good feedback about the system will be a part of the operations of the organization. The customers The system must be easy to all customers The customer with special needs The intercom help in that case The adjustment of the touch screen in the room. Management the system The main problem to management that system by the manger we can place screen in front the manger of each departments involve in that process and provide report of all process Hotel staff The main factor for services the hotel staff it must to know how deal with all services.

Explanation / Answer

Database specification means complete details from the lower level of the database and its model. Actually this contains list of entities and erd'd with their description.

The below is the specification of the database for the above scenario.

For the above we need to have the below entities need to created in the database. Those are

1. Staff

2. Customers

3. Services

4.Maintainence

These are required mainly. The staff table will contain names,id, phone no, floor no e.t.,

The customer table will have customer name, mob number, address,idproof, alloted room no, check in, check out e.t c

The service table will have service name, id for service, amount,time for service e.t c

The maintenance table will have name of staff, time of maintenance, wha they done,e.t.c

Based on your requirement you can have your additional attributes as you want.

And this is the specification for the above database.

And for the other functionality you have get that through front end application design after that you have to link or connect that application to the database. Then you may get the required functionality.

And the other main thing is you have to provide the relationship between the tables through the required constraints.

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.