Global Car Club (GCC) is a small individually owned club which loans cars to its members. GCC first formed in 2009; has over more than 100 good mixes of members and counting. The club organizes frequent drivers and social events throughout the year for members to get together to enjoy their passion. The company has been already introduced to you during the lab sessions.
What to do
We are aiming to build an electronic database management system for GCC. As a member of the software development team, your responsibility is to create and populate the database system using SQL Server (Microsoft SQL Server is a relational database management system developed by Microsoft).
What is required
The database is designed specifically for GCC, and stores the following information:
- Members, past and present
- Vehicles, current ownership and previous club-member owners
- Committee Members
- Assets owned by the club
- Events held by the club, including attendance records
- Day Book entries, recording of non-club use of club-plated vehicles
Additionally, GCC provides easy to use communication channels to ensure your members are kept up-to-date with Club news. You are expected to work through a series of activities or tasks that have a lot of scope for variation in the approaches taken. We will introduce some additional scenario information as we progress through these activities, and will give some direction about how the GCC wishes to
consider the data and aspects of their business operation. In most of the activities there will not be a single answer to the questions we pose-so our comments will be in the form of discussion points that you should be considering regarding the solutions you suggest.
Attachment:- 326333_1_Data-Analysis--Design-Unit33-May13.pdf