A database to keep track of information for her


Eugenia, owner of Eugenia's Parties, wants a database to keep track of information for her business. She wants to keep a list of all the clients who do business with her. She wants to track the name, address, and phone number of each client. For each party, she needs to know the date and the cost of the party. Eugenia has a list of potential locations for parties that she can recommend to her clients. She would like the database to store the name, address, phone number, cost, and name of manager at each location she uses. When a party is set up, she would like to know which location was used for that party - a party occurs at only one location. In addition to setting up the location, Eugenia also sets up the entertainment. She wants to maintain a list of bands and DJs that can be used. For each band or DJ, she needs a name, address, phone number, and normal fee. Each party uses only one band or DJ. Finallly, Eugenia has a group of employees who work parties. She need to know which employees have worked at which parties, and for how long they worked at a given party. An employee can work many parties, and a party typically needs several employees. For each employee, she needs to store their ssn, name, address, phone number, and hourly pay rate.

Request for Solution File

Ask an Expert for Answer!!
Database Management System: A database to keep track of information for her
Reference No:- TGS0767020

Expected delivery within 24 Hours