The Use of Databases Essay Example | Topics and Well Written Essays - 750 words

The Use of Databases - Essay Example While selecting a database for a small organization like real estate business, Microsoft Access is the best. It gives an easy layout to design a database of our own, with wizard facility. In a small real estate business, tens of customers visit everyday and tell us about their requirements. Some needs to have house on rent and some wants to buy a house. Even few comes here to sell their house. So in order to keep a record of all these, we need to have a Database. So that whenever a customer comes here to seek a house on rent, we can show him/her a list that contains all the houses that we got. It can only be done with the help of a Database. A Database can not only store the information but it can give us the printable form of the data as well in Reports. The first thing while develop a Database is that we created tables, as they actually store the data in them. But the interface is provided with the help of forms. And we can access the data in our Database with the help of Queries that works simply as question been asked. This Database contains a table of permanent customers that includes their names, with a unique ID, contact number and address as well. The other table contains the list of houses that are available on rent. This table contains all the information about these houses, their size, location, number of rooms and the rent money as well. The other table contains the list of houses that are there to be sold. It also contains all information about them, like size, location, number of rooms and their prices. Another table contains the list of customers that are willing to rent a house. This table contains their demands as well, that what kind of house they need and the location, size and number of rooms in it. The other table contains the customer's details that want to buy a house. And also their demands. The above mentioned both tables contains the contact number of customers as well, so that they can be contacted when needed. Another table deals with the employees of the firm. The firm has 10 employees working at present. Two employees are for office work and eight are the salesmen. The table contains their details, like their names with a unique ID, their addresses, contact numbers, date of joining the firm, starting salary, current salary, and also their account numbers. The computer operator in the firm uses Forms to enter data in the database. Forms are the interface provided by the database so that data can be entered more conveniently. There is a main form, which gives the main menu, ask the operator whether he wants to enter employee information or customer information. In employee section he can enter the information for new employee or he can update the record of existing employee as well. In Customers section, he can enter the information about the customers who are looking for a house to rent and also those who are willing to give their houses on rent. And also the customers who want to buy a house and their demands as well and also the customer's information who are looking for the buyer. Queries are used, so that we can quickly have the information for our required house. Suppose a customer is looking for a house with three rooms in downtown, we can simply put the number of rooms a

Contemporary recreation, sports, or tourism legal issue Essay

Contemporary recreation, sports, or tourism legal issue - Essay Example The amount of lawsuit and the diversity of cases in the sports fraternity have been on a surge as more people rely on the courts to solve disputes. The laws have the required expertise to enable the smooth running of the sports. There exists variation as to the way the law is defined, one school of thought hold the view that a law is a congregation of regulations and rules that govern a particular action. Sport law refers to the application of existing laws to recreation and sports. Sports governing bodies operate almost similar to state administrative and federal institution. The governing structures of sports organization are based on the federal laws, regulations and rules. For example, the guideline adopted by the National Football League in the U.S resembles traditional state tort law principles. Thus when a dispute over the interpretation of a regulation or rule arises, lawyers represent the participants and the principal body to resolve the dispute via the administrative structures set up by the sport organization. The Constitution of United States does not guarantee freedom from an invasion of privacy. To justify an action for invasion of privacy, a petitioner must show the cause why the invasion is significant and is in an area for which there is anticipation of privacy (Flannery, 1998 pp 9). In the sports business, such cases are not uncommon especially in drug testing programs. Consider the case involving (Acton v. Vernonia School District 1995); James Acton challenged the drug testing program initiated by Vernonia School District as an invasion of privacy. However the Supreme Court established that school children had a smaller expectation of privacy because athletics subjected one to a need for medical attention, physical examination and a locker room environment. The Court thus upheld the view that drug testing does not constitute an invasion of privacy (Lisa, 2008 pp87). However the Vernonia ruling is not likely to be relevant to collegiate athletes. In the Acton v. Vernonia case, the judge further explained that the high school students had a lower expectation of privacy given their minor age and were under the care of the school in absence of their parents. Given the situation it was the sole responsibility of the teachers to ensure discipline is observed at school. On the other hand, collegiate athletes are considered adults under less supervision from the college and university administration. An example is the U.S Supreme Court decision not to grant a hearing of an appeal of the Supreme Court of Colorado's verdict which found that drug testing program on football players at the Colorado University constituted an invasion of privacy. During the Proceedings, (University of Colorado v. Derdeyn, 1993), the Supreme Court of Colorado ruled that despite the University's concerns in protecting the student's welfare, the argument is not sufficient enough to warrant the intrusion on privacy through random testing for drugs on the players (Lisa, 2008 pp 94). Herbs, (1985) notes that constitutional challenges to drug testing have been unsuccessful in professional sport. For instance, in 1994, the federal district court of Pennsylvania ruled that the National Football League (NFL) drug testing program was not subject to a constitutional challenge because of the absence of state action. The court (NFL v. Long) ruled that neither the commercial association between the Steelers and the City of Pittsburg