Star Inn is a chain of hotels. The reservation system is uses a centralized reservation database. The database contains booking information on all hotels of Star Inn. The following is a description of the conceptual model of the hotel reservation database at Star Inn.

The database contains information about hotels, hotel rooms, customers, and reservation. A hotel can be identified by its identification number (hotel_id). It is also described by hotel_name, address and phone_no. Rooms are identified by room_no which is unique for a hotel. The same room_no may exist in different hotels of Star Inn. Rooms are also described by type and rate.

Customers are identified by customer_id and are described by name (customer_name), address (customer_address), and phone number (customer_phone). When a customer makes a reservation, he/she is asked to specify the hotel, the room type, the arrival date (arrival_date) and duration of stay (duration). A specific room is then booked for the customer. A customer can book the same room more than once. Therefore, a reservation is identified by a reservation number (reservation_no).

Please use Visible Analyst or any other CASE tool to draw the ERD.

Business Intelligence & Database Technologies

As highlighted in chapter 6 of the Laudon text, the foundations of business intelligence are based upon advanced database related technologies. Some of these technologies include, but are not limited to, database management systems, data warehouses, data marts, data mining, and analytics. Also, the concept of Big Data is an evolving phenomenon which is sparking heightened interest among organizations and is paving a new direction in the arena of business intelligence.

Some questions to ponder:

1) Can we trust big data?

2) Why are organizations interested in capturing and mining their enterprise data?

3) Why are they especially interested in tapping into the power of "Big Data"?

4) Traditional database management tools are often insufficient when dealing with "Big Data". What technology tools do you think are more suitable?
5) Are there any pitfalls to using "Big Data?" What are some of the challenges?

6) By doing a search of the internet, or by other research methods, find another example of an organization that is using "Big Data" to solve a business problem. Did the organization achieve their objectives?

Complete combustion of 8.40 g of a hydrocarbon produced 25.4 g of CO2 and 13.0 g of H2O. What is the empirical formula for the hydrocarbon?

Complete combustion of 8.00 g of a hydrocarbon produced 24.5 g of CO2 and 11.7 g of H2O. What is the empirical formula for the hydrocarbon?

Complete combustion of 8.50 g of a hydrocarbon produced 27.2 g of CO2 and 9.73 g of H2O. What is the empirical formula for the hydrocarbon?

Complete combustion of 7.90 g of a hydrocarbon produced 24.2 g of CO2 and 11.6 g of H2O. What is the empirical formula for the hydrocarbon?

Empirical research shows that the existence of stock options may induce earnings management (Alexander et al., 2017). Discuss this claim.

Inventories Management

Evaluate the difference between Just In Time and Economic Order Quantity system with empirical example. Please write in the detail.