Database Entities and Attributes Essay
Professor Jennifer Morocco Database Entities and Attributes A database as documented according to “Dictionary. Com” (20141 is a “systematized collection of data that can be accessed immediately and manipulated by a data- processing system for a specific purpose. ” These collections of data are used to make searching for a needed product or service easy for a user. Each of these databases is comprised of a number of entities and attributes that are connected relationally to optimize the search for the best possible results.
One such database is used by Booking. Com. This is a database used for searching hotel rooms throughout the world. This database gives the user the option to find the best hotel room for their leisure or business travel. Following will discuss the Booking. Com database and the entitles and attributes that are used In their database. Booking. Com Hotel Database Booking. Com is a subsidiary of Principle. Com which Is a leader In the world of booking accommodations online. 625,000 rooms are booked each day using Booking. Com.
The site was established In 1996 and guarantees the best prices for any yep of rentable property ranging from bed and breakfasts to executive apartments and five-star luxury hotels. It Is available In 40 languages making It available to literally the entire world. Their database contains all the pertinent Information for hotels In most cities and countries throughout the world. These properties are broken down by each significant part of the property and placed in the database to criteria (“Booking. Com”, Entities 1996-2014). Entities are described as business subjects or objects.
These are the types of people, places, or things that are used in or interact with the business that you are trying to maintain data about. Each of these entities will have a candidate key (KC) that will identify them from every other entity in the system. These keys need to be features that will not change but will remain constant (Avalanche, Hoofer, & Hoofer, 2012). The Entities for the Booking. Com database would be as follows: Hotel – KC – ID_number – Hotels are assigned unique ID numbers to assure that they are uniquely defined in the system.
The ID numbers are not displayed for the customer to see but re used for identification purposes only. Location – KC – postal_code & street_address – these are both used as they will uniquely identify the hotel in their city at the exact address. There cannot be two hotels at the same street address in the same city, therefore this is a unique key for this attribute. Policies – KC – online_booking – the policies are defined by whether or not they have online booking. If they do not then the rest of the policies are a moot point as they may not book using the database.
Amenities – KC – property_type – amenities are defined by the yep of property they represent. This could range from vacation home, hotel, apartment, hostel, or resort. Hotel Chain/Management – KC – Name – this would be the name of the chain of hotels that the property is linked to or the name of the management company. Each of these entities are uniquely defined by their KC (Candidate Key). The entities are the main descriptors that will be searched for by the user. The user will enter their unique search and depending on the criteria they choose the database will find the appropriate choices for them.
A user can choose to reach all descriptors or Just some of them depending on what they are looking for. Attributes Each entity has at least one attribute that describes it. The attributes further define the property. Some relationships between the entities can share more than one attribute and others share only one. The relationship diagram 1. 1 will illustrate how the entities and attributes are linked together. Below is a list of the attributes for each of the entities in the database: Hotel – ID_number uniquely identifies the property, Name is the given property name, and rating is the number of stars and customer review ratings.
Location – Postal_code and street_address give the physical location of the property, country in which the property resides, and the distance from the city center is given for reference. Hotel Chain/Management – name is the management company’s information, staff_id is the person in charge of the property. Rooms – available is whether or not the property is available for the users selected dates, bet_type is whether the room has king, queen, full, or twin beds, and cost is the cost of the selected room types.
Policies – online_booking availability, cancel_type is he cancellation policy including whether or not the room may be cancelled after booking, checking_time is the check in time available, checkout_time is the policy for check out time, and fast_free is whether or not the property provides a free there is a restaurant on-site or if they are in the area, bar_type is if there is a property bar and the type available, fitness_type is whether or not there are fitness facilities available and the type, and pool_type is whether or not there is a pool and if it is indoors or outdoors.
The purpose of the attributes is to further describe the entities so that users can pinpoint exactly the type of property they would like to stay in. Diagram 1. 1 Conclusion Booking. Com has a database that is accessed by millions of people. This database contains all these entities and attributes and goes even further to break down the properties that they provide booking for.
Each of these properties can be uniquely accessed by users to find the perfect property to meet their needs. Through the use of these technologies the owners of the database are able to make substantial amounts of money by Just utilizing technology and creating relationships with the repertories. Designing agile and effective databases through the comprehensive use of entities and attributes is a skill that can lead to a plethora of rewards.