For my final project, I created a database as if I was a wedding planner. I thought this idea would be useful to me because I enjoy going to weddings and organizing. Also, one day I could use the database I created to help me with my own wedding planning.
Tables
In my database, I created five tables. The first is labeled Bride and Groom and this is simply the bride’s name, the groom’s name, and their wedding date to help me know which couple the database is for. The second table is a categories table which helps categorize the different aspects the couple wants in the wedding and helps create relationships between the other tables. The third table is an estimated costs table. The estimated costs table keeps track of the costs of everything in the categories table such as the bridesmaid dresses, and flowers. This table also lets the couple and I know if the costs are fixed costs or costs per person and if they are a part of the final budget. I also added a notes section in case the couple or I have any questions along the way. The fourth table is a guest list to keep track of guest names, addresses, and phone numbers to send invitations, send thank you notes, etc. The fifth table is a task table based on the categories so I can keep track of what tasks have been completed, are in progress, or not started, and the …show more content…
The first report was the total estimated costs. This report was created so the bride and groom would know how much the wedding is going to cost and how much of their budget has been used up throughout the planning process. I also added a report from the estimated costs greater than $1000 query so the couple would know the total of those items and they could determine if they could remove any items from that list. The couple had a budget of $15,000 so it was important for me to discuss the totals on how much they were spending throughout their wedding planning
Tables
In my database, I created five tables. The first is labeled Bride and Groom and this is simply the bride’s name, the groom’s name, and their wedding date to help me know which couple the database is for. The second table is a categories table which helps categorize the different aspects the couple wants in the wedding and helps create relationships between the other tables. The third table is an estimated costs table. The estimated costs table keeps track of the costs of everything in the categories table such as the bridesmaid dresses, and flowers. This table also lets the couple and I know if the costs are fixed costs or costs per person and if they are a part of the final budget. I also added a notes section in case the couple or I have any questions along the way. The fourth table is a guest list to keep track of guest names, addresses, and phone numbers to send invitations, send thank you notes, etc. The fifth table is a task table based on the categories so I can keep track of what tasks have been completed, are in progress, or not started, and the …show more content…
The first report was the total estimated costs. This report was created so the bride and groom would know how much the wedding is going to cost and how much of their budget has been used up throughout the planning process. I also added a report from the estimated costs greater than $1000 query so the couple would know the total of those items and they could determine if they could remove any items from that list. The couple had a budget of $15,000 so it was important for me to discuss the totals on how much they were spending throughout their wedding planning