Free Essay

Sunny

In:

Submitted By sunny477
Words 258
Pages 2
Travels company
Requirements:
Booking ID Seating Capacity
Booking Date starting Miles
Pickup Date Return miles
Return Date Price per Mile
No. of miles booked Price per Day
No. of days booked Vehicle Insurance
Deposit Vehicle Registration ID
Insurance Contractor ID
Invoice ID Contractor Name
Tax % Contract Type
Total Bill Type of Vehicles
Type of payment Contract Period
Rep ID Reviewer ID
Rep Name Reviewer Name
Rep Address Review
Commission
Customer ID
Customer First Name
Customer Last Name
Customer Address
No. of Travelers
Customer Driver License ID
Vehicle ID
Vehicle Type
Vehicle Name
Vehicle Class
Vehicle Value
Entities:
Bookings (BookingID, Booking Date, PickupDate, ReturnDate, No. of Miles booked, No. of days booked, Deposit, Insurance)
Representative (RepID, RepName, RepAddress, Commission)
Customers (CustomerID, CustomerFName, CustomerLName, CustomerAddress, No. of Travelers, CustomerDriverLicenseID)
Invoice (InvoiceID, InvoiceTax%, TotalBill, TypeofPayment)
Vehicles (VehicleID, VehicleName, VehicleType, VehicleClass, VehicleValue, SeatingCapacity, StartingMiles, ReturnMiles, PriceperMile, PriceperDay, VehicleInsurance, VehicleRegistrationID)
Contractors (ContractorID, ContractorName, ContractType, TypeofVehicles, ContractPeriod)
Reviewers (ReviewerID, ReviewerName, Review)

Relationships:
Bookings by Representative (BookingID, RepID, No. ofDaysBooked, Commission)
Fk BookingID -> Bookings
Fk RepID -> Representative
Bookings by Customers (BookingID, CustomerID, CustomerDriverLicenseID, No. of MilesBooked)
Fk CustomerID -> Customers
Fk CustomerDriverLicenseID -> Customers
Bookings by Invoice (BookingID, InvoiceID, TotalBill)
Fk InvoiceID -> Invoice
Fk BookingID -> Bookings
Bookings by Vehicles (BookingID, VehicleID, Vehicle RegistrationID, VehicleInsurance)
Fk VehicleID -> Vehicles
Fk VehicleRegistrationID -> Vehicles
Bookings by Contractors (BookingID, ContractorID, ContractPeriod)
Fk BookingID -> Bookings
Fk ContractorID -> Contractors
Bookings by Reviewers (Booking ID, ReviewerID, Review)
Fk BookingID -> Bookings
Fk ReviewerID -> Reviewers
Reviewers by Customers (CustomerID, ReviewerID, Review)
Fk CustomerID -> Customers
Fk ReviewerID -> Reviewers.

Similar Documents

Premium Essay

Hubris and Gun Control in Always Sunny in Phikladelphia

...Elias Schrank Waters CWL 320 November 28, 2014 There is an overbearing sense of narcissism of most of the main cast. Satirizing America’s gun control agon and consumer reaction to sensationalized media, the fervor of the cast’s “hot” stances in “Gun Fever Too: Still Hot” is ultimately an examination of futility in impulsive response catalyzed by hubris. The cast’s narcissistic tendencies are seen in their insistence of proving their claims. Both sides display a hyperbolic sense of enthusiasm for their side of the debate, illustrating the comic message. The groundation - liberation dichotomy is examined in their stances concerning the active agon regarding gun control in America. While both sides exhibit extreme beliefs, groundation can be seen in Dee and Dennis’ intent to prove guns need to be eradicated from the streets entirely, and liberation in Charlie and Mac’s wishes that guns be freely available for personal defense. Also subjective is the nature of the dichotomy; relative to one’s belief, the roles still serve either function. Their dealing in “all or nothing” ultimates allows for complementary illustration, and allows a more radical contrast of the gun control debate. The gang’s zealous nature invites the audience to consider their own stance respective to the gun control debate, allowing opportunity for reflection and possible reconsideration of their own preconceived standpoint. The cast’s inflated sense of worth and (lack of) payoff in their shortcomings...

Words: 1070 - Pages: 5

Free Essay

Sunny

...I attended the event “Justice for Children: A Landmark human Rights Case with Dr. Cindy Blackstock, Thursday January 15 2015 from 7 to 9 pm at the Central Library. The event focused on how education and services remain seriously underfunded for children on reserves. The event was important to me as it brought awareness of the issues that are faced daily by Aboriginal families and their communities. I had previously read about how there was a discrimination complaint filed against Canada that was in violation of the Canadian Human Rights Act, that Canada provides significantly less funding for family and child services on reserves than that provided off reserves, but never knew much about the case so I was glad to be able to attend the event and gain more knowledge on the issue. In 2007, First Nations Child and Family Caring Society and the Assembly of First Nations (AFN) filed a human rights complaint alleging that the inequitable funding of child welfare services on First Nations reserves amounts to discrimination on the basis of race and national or ethnic origin, contrary to Section 5 of the Canadian Human Rights Act, RCS 1985, c. H-6 (the Act). Some of the current inequities in Canada are that almost half of all children in care under the age of 14 are Aboriginal. The placement of Aboriginal children in informal care with relatives is 11.4 times the rate for non-Aboriginal children, and 12.4 times the rate of non-Aboriginal children for formal placement in the child...

Words: 683 - Pages: 3

Premium Essay

Sunny Hotel

...6 Service P urchasing a t t he Sunny Hotel 1 Company Background The Sunny Hotel/Spa & Wellness Resort is well known in Izmir, Turkey. Founded in 1995, it started as a family-owned business and has dramatically expanded especially during the recent five-year period. It has grown at the rate of 200% during the period of 2000-2006. Mr. and Mrs. Gunes, owners of the hotel, stated during an interview in 2006 that the secret of their success is: We believe that we have a different point of view than that of our competitors. Our focus is on our core competency in providing hotel management services. Although it can be difficult to determine one’s core competencies and bound- aries of a company in the tourism sector, success of the business enterprise depends on this point. Functions that are not in one’s core competencies should be examined for outsourcing to other firms. Recently the Sunny Hotel’s owners have thought about outsourcing critical services. The tourism sector has been rapidly expanding the flow of hotel management services; this flow has become more significant than the materials flow management for us. Mr. Gunes has remarked that purchasing has turned into more of a strategic function for the organization, especially in recent years. Although traditionally materials flow is accepted as the core flow that should be managed effectively along the supply chain, the reverse—i.e., that of the...

Words: 1074 - Pages: 5

Premium Essay

Sunny Hotel

...Service Purchasing at the Sunny Hotel Jen Daniely MGT608 Summary A well known Hotel and Spa Resort in Turkey started off as a family owned business and has expanded 200% during a six year period. Previously the purchasing department only handled the purchasing of the supply of goods. The responsibilities of purchasing services were handled by the related department directly receiving the services. The owners decided to bring in a Purchasing Manager, Murat Var, to take over all the purchasing of services for the entire Hotel therefore centralizing responsibilities and building strong customer-supplier relations and improved levels of customer service. The department managers believe this new consolidated purchasing organization is logical and advantageous, however they do have a few complaints which include purchasing personnel not engaging department heads in the source selection process which has sometimes lead to wrong or bad selections. Discussion Questions 1. What makes the procurement of services different from that of the purchase of goods and materials? In the case of the Sunny Hotel/Spa & Wellness Resort, strategic procurement of services is crucial for the company’s success. The services flow is treated as a focal point that should be properly managed by outsourcing to service companies, whereas the flow of goods and materials supports service management. Therefore the procurement team for services at the Sunny Hotel are focused on securing service...

Words: 885 - Pages: 4

Premium Essay

Klaus Baudelaire

...The Baudelaire’s lives were just miserable. Their lives had become even more miserable when they went to Prufrock Preparatory School. Violet Baudelaire was the oldest, Klaus Baudelaire was the second oldest, then there was Sunny Baudelaire who was merely an infant. These children’s parents had been in a terrible fire at their home Due to the events, that had happened the children were place with a horrible person. Count Olaf was the Baudelaire’s first guardian, after he was caught trying to get the Baudelaire fortune. Guardian after guardian Count Olaf was there in disguise. The setting of this story is at Prufrock Preparatory School. Lemony Snicket described as “The school was made up of many buildings, all made of smooth gray stone, they...

Words: 602 - Pages: 3

Free Essay

Mnmn

...Puri, Masaba Gupta, Archana Kochhar, Ramona Narang and Varoin Marwah in Mumbai. Bollywood's true-blue fashionista Kangana Ranaut sashayed the ramp in a maroon Archana Kochhar creation with a sheer skirt, while celebs like Sunny Leone, Shazahn Padamsee, Celina Jaitly, Sophie Choudry and Mandira Bedi, among many others graced the front rows. The four-day fashion extravaganza commenced with the launch of the very first edition of India Resortwear Fashion Calendar on December 11 and will conclude with the India Glamour & Fashion Awards on December 14. Other designers participating this season include Nandita Mahtani, Malini Ramani, Surily Goel, Rocky S, Babita Malkani, Sai Suman and Sounia Gohil. Best known as the Queen of kaftan, designer Pria Kataria Puri opened the show with her colourful and glamorous Lust line. The collection included her signature kaftans and swimwear but a unique thing about her designs this time was the use of belts, slits and antique gold lace which added a feminine touch to the garments. The silhouettes included saris, tunics, maxis, mini dresses, swimsuits, jumpsuits, crop tops with high waist pants and hippie pants. The colour palette was a tasteful mix of vibrant and vivacious beach off white, neon green, bright fuschia, sunny yellow and turquoise. "Indian fashion is known around the world for its resortwear and Indian designers are also known for their resortwear creations," the designer said. Talking about her collection, designer Nishka Lulla...

Words: 701 - Pages: 3

Premium Essay

Bra Boys Task 2

...[pic] The Bra Boys are a gang of young blokes who enjoy their surf amongst the beaches of Maroubra on New South Wales who occasionally get made out to be something they are not by the media. Main gang members Sunny and Koby Abberton have made a documentary to tell their side of the story and prove their innocence. Today I will be discussing and reviewing whether or not it is true that the "Bra Boys" are depicted by the media as being maligned. Within the Bra Boys documentary they are stating themselves not to be a gang, but a brotherhood. What kind of brotherhood walks around the streets late night getting into lights supposedly "protecting" their place in town and the beach? I personally think that the gang have done immature things in the past which media have taken too far to make them look bad but in saying that 1 also believe that they are a great bunch of blokes who deep down just want to enjoy the surf Media obligations such as a murder within the bra boys got fully blown out of proportion and the media made false accusations to the public. I am supporting the case that the bra boys are not as bad as made out to be. December 24th 2002 On this night in December an alleged brawl between the notorious surf gang the bra boys and many of the local off duty police. It started out as a normal night with a few of he boys together all having fun, having a few drinks celebrating a fellow bra boy and close friends birthday. The bra boys party consisting of approximately...

Words: 1900 - Pages: 8

Premium Essay

Comparison of Beowulf to Superman

...Heroes. From the timeless tale of Beowulf to the well-known chronicles of Superman, cultures all throughout the world have taken it upon themselves to weave a fabrication of a fantastic being, said being a hero of a sorts, that always makes it to defeat the bad guy and save the day. Even whence we as human beings always tend to have our political, social, economic and religious differences, at the end of the day we all have one thing in common that fills our dreams with hopes of the future, of safety, of a peaceful life; heroes. Helping to define who we are and what we want to be, giving us hope and inspire us to head in the right direction, showing us that good will always triumph over evil and that anything is possible if you set your mind to it, heroes give us the inspiration we need to overcome problems in our own lives. If anything, the reason one would come up with the concept of a hero in the first place would be to have a body to look up to when the time is drear and the need is great. In thus, Beowulf perfectly embodies the idea of a hero; If defeating the evil Grendel and his mother wasn't enough to set him such a title, the great hero slays the dragon and saves his people even upon his death bed. He is strong, brave, moral, inspiring; all of which are traits that someone can look up to and aspire to stand against. While his story may have been written over a thousand years ago, Beowulf’s heroism has echoed through the ages. Even today, our heroes are strong, brave...

Words: 950 - Pages: 4

Free Essay

Hot Sunny Day

...Hot Sunny Day One Sunday morning, hot, and humid sunny day. I woke up, because the sun hits my eyes, and because of that, my window shade fall off. Clearly, I could see it was on my dirty floor. There was a rat sleeping on it. I didn't plan to move the rat, because I was so tried that I couldn't move. I was sitting on the edge of my bed. I stared out at the wall for at less an hour. Then I looked down. As I'm moving down with my eyes. My eyes were so slow that I felt that I'm like a robot. When I tried to get myself up, as I moved away from the edge of the bed. My boxer was like a glue, clinching onto my bed sheet. I would had to use some muscle in order to get it off. It was tricky because my body was sweaty and sticky. I got it off, then I found out that my bed sheet has a yellow mark where I just sat on. It was yellow and it smelled bad. It smelled like a dirty swamp. I almost punk but, I held in. I got into the bathroom. The moment I opened the door, I jumped because there was a girl who was half naked with her head sticking into the toilet. The floor was covered in blood and the sink as well. I had no idea what was going on. I closed the door awkwardly and said, “Please take your...

Words: 258 - Pages: 2

Premium Essay

The Sunny Hotel Case Study

...Melissa Chicola Service Purchasing at the Sunny Hotel 11 October 2015 1. Procurement of Services may be uncertain at times. For example, when purchasing a good, a company will choose a supplier, ensure the good is what they need, and receive the good. With procurement of services, the stages may not be similar. When Sunny Hotel has an outside cleaning service, the hotel can only judge the service after it has been completed. 2. Sunny Hotel currently purchases and contracts its security, cleaning, animation, insurance, software support, staff training, and food storage and delivery services. The company could include a program for the satisfaction of customers as well as include risk management services. 3. I do believe centralized purchasing is a logical way to increase purchasing efficiencies. It works with other departments and suppliers to combine orders for products, so the companies can get the product for cheap. It also keeps the organization’s spending in one location that can be easily checked. Although it is good for the company, I do not think it is an advantage to have the purchasing department manage service purchases. It may slow down the process and prevent employees from receiving those goods on time. Departments, like employees, may be at a standstill because they do not have the goods to make the products. 4. I think some additional criteria could be support services as well as quality level. If you supply a service, you should be...

Words: 307 - Pages: 2

Free Essay

A Sunny Day in Bryant Park

...A Sunny Day in Bryant Park Today was sunny, neither cold nor hot. After lunch, I hung out to Bryant Park to relax myself. There were a large number of people at that time due to the brilliant weather, I supposed. Nearly all the positions were occupied. Some were chatting with each other during the lunch time, happily and breezily. While some young boys enjoyed themselves going skating or playing tennis. Others, especially some old men and women would rather take nap in the leisure time. Under the heavy pressure in my studies, in fact, seldom had I observed people so carefully like this. In most cases, I always passed by the park as quickly as I could to save the time. It seemed that everyone had his own story and in different moods. It interested me a lot. While I was walking with no aim and destination, a slim woman with blonde hair suddenly caught my eye. Sitting on a chair at the corner of the park with an elegant posture and wearing headphones while indulging herself in the books, she frowned suddenly just like coming across some problems. A formal suit, a pair of delicate high heels, black coat on the chair. All these indicated that she was an office lady. Drinking a cup of Starbucks while skimming through the documents, she pulled the beautiful long black hair gently from time to time. She might work in the office not far away and have some tasks to deal with, which should have been finished in the morning. In the light of the exhaustion shown on her face, I thought...

Words: 513 - Pages: 3

Premium Essay

Sunny and Sunshine Ltd

...Question 1 (A) Income Statement for the year ended 31st December 2010 Sunsine ltd |   |   | Income statement |   | Year ended 31 December 2010 |   | Sales |   |   |   | 300,000 |   | Less | | | |   |   | Cost of Goods | | | 180,000 |   | Gross Profit | | |   | 120,000 | Less Expenses | | |   |   | Selling, General and administrative expenses | 24,000 |   | Interest Expenses | | | 16,000 |   | Profit before tax | | |   | 80,000 | Income Tax Expense | | 28,000 |   | Net Profit |   |   |   | 52,000 | Statement of changes in owners’ equity Sunshine Ltd |   |   | Statement of Changes in Owners’ Equity |   | Year ended 31 December 2010 |   | O/Balance Retained Earnings |   | 43,000 |   | Share capital | | | 70,000 |   | Balance at beginning of the year |   | 113,000 | Add | | | |   |   | Net Profit | | | 52,000 |   |   | | | |   | 165,000 | Less | | | |   |   | Dividend Paid | | | 13,000 |   | Balance |   |   |   |   | 153,000 | (B) The company’s average income tax rate is 35% This is calculated by income tax expense/profit before tax*100 Calculation 28,000/80,000*100 = 35% (C) The company is charged 16% Pa on its long term borrowings This is calculated by interest Expense/Long Term borrowings...

Words: 1371 - Pages: 6

Premium Essay

Sunny Isles Beach Research Paper

...7 Attractions You Can't Miss in Sunny Isles Beach, Florida Of all the wonderful places in Florida to vacation, Miami take the cake. Sunny Isles Beach, Miami is ranked number one as a vacation destination in the U.S., and there is good reason for this. It has gorgeous white-sand beaches and a sizzling night life, and is has hotels and resorts to accommodate every budget. The off-season is during the summer until September when there are fewer tourists. Hotels such as DoubleTree have lower rates at this time. You can learn more about hotels in Sunny Isles Beach and find one that suits your vacation budget. There is a lot to do in the area, and here are seven attractions you shouldn’t miss when you visit Sunny Isles Beach. Everglades National Park A large subtropical wilderness, the Everglades...

Words: 553 - Pages: 3

Premium Essay

Jennifer L. Holm's Sunny Side Up

...I was reading Sunny Side Up,a graphic novel book by Jennifer L. Holm. Sunny Side Up has 224 pages, the pages are mostly pictures and barely any words, so you could finish it a couple days or hours or mixtures, it depends if you read fast or not. According to an Amazon customer they think this is an amazing book, “Absolutely awesome book, although my daughter and I weren't expecting it to be a comic. But I REALLY love how it has flashbacks back to her previous summer and things that happened to her brother, Dale.”I think Sunny Side Up is more for 6th grade and up, because of the Dale, and the grandpas situations and I don’t think those pictures are appropriate for little ones. The protagonist is a girl named Sunny. Sunny is a...

Words: 354 - Pages: 2

Free Essay

Harry Drinkwaters Diary

...Harry Drinkwater joined a 'Pals Battalion' when the war began in 1914. At this time he was 25 years old. By the end of the war, Harry had served on the Somme, at Ypres and in Italy, writing the experiences in a diary. He wrote about the gruesome occasions he made in war, the never-ending marches through mud, the sleepless nights and the death of his comrades. Harry survived the war and received the Military Cross for bravery. After he got demobbed, he worked as a civil servant. Unfortunately he never got married and died in the year 1978. 35 years after the death of Harry Drinkwater, his diary got released to the public. The article (http://www.dailymail.co.uk/news/article-2491760/Harry-Drinkwaters-lost-diary-Great-War.html) doesn’t represent the whole diary. What struck me first was the fact, that he went to war by choice. He wanted to serve for his country and put his life on the line for it. Overall, his diary is very interesting, because you get an insight into the everyday life of war back in this time. The thing that made me most sad was the part where he describes the death of one of his comrades. (Tuesday, June 6 1916) I think this is one of most awful experiences a soldier can make. When your companions die in front of your own eyes and you can nothing do against it. Maybe you even blame yourself for it, because you think you could have prevented it. But that is how it is in war. “I could do little else than kneel by his side. He asked me not to leave him...

Words: 981 - Pages: 4