Course Project Scenario

Exotic Cars Inc. (ECI) is a company specializing in sales and maintenance of the exotic (hence the name) cars.

The cars that ECI sells come from multiple sources: some are shipped directly from the factories, other purchased from the private collectors, and yet some other cars are traded-in by the customers of ECI.

ECI also provides a regular maintenance service of the exotic cars, such as engine tune-up, tire rotation, oil change, etc. You do not have to buy a car from ECI to use its maintenance service; consequently, some owners of the exotic cars purchased elsewhere also use ECI maintenance service.

ECI appreciates continuing business of its patrons; consequently, the company wants to maintain as much information about each valuable customer as it possibly can.

As a result, ECI diligently records how much money each customer spends on buying cars (more than a half have purchased two cars and about third bought three or more), on maintenance service (how much customer spends overall, and per car), and whether or not a customer ever traded a car in.

Course Project Description

Your goal is to develop a database that shall allow ECI to keep track of its business and provide the management with the following information regarding the performance of the business:

HR Management

Complete information about ECI employees, especially salesmen and technicians

Inventory Management

Complete information on the number and types of the cars currently kept in stock

Complete information on the number and types of the cars obtained from each source (factory, private collector, trade-in, etc.)

Maintenance Service Management

Complete information on the number and types of the cars that were serviced.

Complete information on maintenance record of each serviced car (car information, type of problem, owner, mechanic who performed the maintenance, and cost of maintenance)

Customer Service Management

Complete information on every customer including information regarding their:

• Total spending on cars
• Total spending on service maintenance

Accounting

Complete information on spending of every customer

Complete information regarding what was paid to each vendor

Complete information regarding what was received by ECI from the sales of cars

Complete information regarding what was received by ECI from the maintenance service

NOTE: You don’t have to implement all of the required functionality- use the description above to determine entities and attributes that you data model must include.

Submission of the Project

You are going to submit the Course Project over the following sequence of steps (a single deliverable per step):

1. Course Project: ERD
2. Course Project: SQL code used to create your DB Schema and populate your DB Tables
3. Course Project: Reports

Course Project Grading Guidelines

Students, your project is worth 100 points total, with the following allocation of points:

NOTE Regarding the format of your submissions:

The complete package that you will need to submit must include the following:

1. Copy of your database created using SQL Server
2. A Word document/PDF file including the following parts:
1. ERD of your database
2. SQL code that you used to create your schema (copy & paste from SQL Server)
3. SQL code that you used to populate your tables (copy & paste from SQL Server)
4. Description of your reports- you must clearly explain what information each of your reports allows you to obtain (you will need to have 10 descriptions)
5. SQL code that you used to create the queries that run your reports (you will need to have 10 SQL queries)

75 words

The two tourist attractions that are next to my house is the Navy Pier and the Chicago Bears stadium. They have a great effect on the local economy because of the businesses that dirtying both places. With the Navy Pier it draws tourist their because of the scenery its located on Lake Michigan, the shopping in Navy Pier, the night attractions on the ships like the Spirt of Chicago and the many other festivities that you can do their.the Navy Pier bring in a lot of revenue because of this.
The Chicago Bears stadium is also a great asset for the local community because of the games and the number of football legions that have played and became hall of fame inductees. Thousands of tourist add locals attend the games every year.
I live close to downtown and because of those two attractions and many more the neighborhood is well protected and kept clean, also more money comes on the area for the many small businesses that are in the area as well. Its always something to do and the night clubs are really nice and respectable. The economy is in a good place because more people can afford to visit and enjoy themselves without the worry of not bring able to afford the entrainment.

————————————————————–

75 words

My husband was born and raised in Chicago so I have been there a couple of times.  I enjoy visiting and there are still several attractions that I want to visit the next time I come. I am surprised that you did not mention the Taste of Chicago. I have not had the opportunity to attend one but I do know that people travel from all around the country to visit for that weekend. I have been in Chicago during the Taste and it is ridiculous the number of tourists that are there. Another location that I would think would draw a big crowd now is Hyde Park. I personally made it my business to visit there after the 2008 election. I spent maybe about $700 that weekend (the restaurants are awesome and I lived in the gourmet popcorn  shop). I even toured the city comparing the best italian combos (an idea I got from the Ultimate Food Wars show on the travel channel). I have not been to a Bears, Sox, Cubs, or Bulls game yet but I have been to the Navy Pier and I really enjoyed it. You are lucky to live in a city with so many attractions and things to do.

——————————————————-

75 words

I didn’t mention the taste of Chicago because out has changed so much and this year not that many people attended like in the past. The Mayotte is charging for the concerts and they deleted some of the food that made the taste.
Hyde Park is cool to visit because that’s where the president its from, Chicago has so much to do and even of you don’t have money their is a lot of free thing to do s well.

——————————————————————

75 words

I live in Augusta, Georgia and there are very few tourist attractions here.  We are located on the Georgia/South Carolina border with Atlanta being 130 miles west and Columbia being 75 miles east. These two locations draw most of the tourism. We do have the Masters Golf Tournament in April. This year’s Masters has had a lingering affect on the economy.  Having had dignitaries here for the Masters, The leadership at Starbucks has decided to open its first GA manufacturing plant in Augusta which will add 140 jobs and $172 million  to the local economy.

—————————————————-

75 words

I visited Atlanta before,I go to the hair show that is held every and the attractions their are amazing, the downtown area draws alot of money and with the special events, like the hair show it generates more money for the salons and hotels. February is the only time that I have visited Atlanta and from the looks of it the city brings in a lot of money.

—————————————————————-

75 words

    The first tourist attraction is right in my hometown Oshkosh, WI.  It is the Experimental Aircraft Association (EAA) AirVenture.  The EAA AirVenture has planes such as Warbirds, Tomahawks, and the Invaders.  The planes fly over all today and into the evening and they fly in formation.  The EAA AirVenture is great for the local economy, hotels are packed, bars run specials and restaurants are open early just for EAA customers.  The EAA directors even hirer people to help run stands, clean up the grounds, and show people around. 

————————————

75 words

In Augusta, the unfavorable effects of tourism are petty crimes such as fights and shoplifting, and traffic which is the worst. There is really only one way in and out of Augusta, highway I-20. Since the airports are in Atlanta and Charlotte, patrons of the Masters tournament have to drive in from these cities thus practically crippling travel into and out of Augusta. the traffic is so bad that even residential streets are open to Masters traffic. This is why the schools are closed during the Masters and most residents leave town.

—————————————-

75 words

   I have to agree with the textbook that the favorable noneconomic effects is local pride.  I live in Oshkosh, WI and every year over the 4th of July we have what is called, Sawdust Days.  Sawdust Days has the normal things like rides, food stands, beer tents, and music.  But there is also culture, Buckskinnner Traders & History Camp.  Buckshinner camp started in 1840’s with muzzleloaders, bow and arrows, and tomahawks.  Now there is so much more hand made tents, cloths, purses, wallets, and rugs that are all made by the Indians.   

5 pages paper base on globalization and its desanvantage in a developing country ( China, India or another)

Due Sunday Night

Question (2)  for Jan V Only.