Question

Project 2 (Clothing Rental) Fashion Rental is a rental company located in Manhattan, New York, specializing in rental of high end wome en clothing for the fashion industry. Over the past 12 months, her business has experienced tremendous growth due to a boom in the fashion Industry. The business has kept the daily service records in a workbook format and now needs to expand its reporting capabilities to develop a relatio nal database to effect a more functional structure. Fashion Rental needs help developing a database, specifically: Create a customer table Create an employee table Create a clothing table Create a rental table Create a rentalDetail table Create a category table Create various queries Produce a daily invoice report The entities and primary keys for the database have been identified in figure 1. The list of records have been identified in fig 2. You may ma diagram. ke and list any assumptions to simplify your entity-relationship The following business rules have been identified: 1. A customer can rent on e or more clothing but must rent at least one 2. A clothing can be rented to one and only one customer An employee can process one or more rental but 4. A rental must be processed by one and only one employee 5. An clothing can be rented by the day and must not be rented for more than 10 days 3. must process at least one Project Focus Your job is to complete the following tasks: 1. Develop and describe the entity-relationship diagram 2. Use normalization to assure the correctness of the tables (relations) 3. Create the database using a personal DBMS package (MS Access) 4. Create data to populate your tables as per the guidelines in figure 2 5. Create a query to show the total amount of clothing rented by category 6. Create a query to show the employee that processed the least rentals 7. Create a query to show a listing of the total rentals and cost per customer 8. 9. Create a report to show the total rental revenue generated by each employee. Create a report that shows the daily invoice (rental details) for each customer Employee Employeeld Clothingld RentalNumber RentalNumber, LineNumber Clothing RentalDetail Category Categoryld Fig 2: Entity Customer Employee Clothing 20 10 20 (with at least 10 rentals per month for a 2 month period At least 60 (with at least 5 rentals with more than one item per month) e.g. In the month of say January, you would have at least 5 rentals that have more than one items, the other rentals in Jan could have only one item At least 5 Rental RentalDetail Category Fig 1 Help: 1. All tables must contain a primary key (see Fig 1.) 2. All tables are related via relationships. For a one to many relationship, the primary key of the one table must be duplicated in the many table. 3. Choose the appropriate data type and field size for each field in each table based on the data for that table. 1. Customer Table: Only nine fields needed (Customerld, Firstname, LastName, Address, City, State, Zip, Phone, Email). 2. Employee Table: Same as Customer Table 3. Clothing Table: Use fields that are related to the table. Do not create more than 6 fields for this table (including any foreign key). Must contain a CostPerDay field which will contain the 4. Rental Table: Only six fields needed (Rentalld, StartDate, Enddate, TotalDue)-you figure 5. RentalDetail Table: Only four fields needed. (Rentalld, LineNumber, Cost)-you figure out 6. Category Table: Only two fields needed (Categoryld and Description). daily rental cost for the tool. out the other two. the other.

Answer 1

When we open Access, Backstage view displays the New tab. The New tab provides several ways that we can create a new database:

• A blank database We can start from scratch if we want. This is a good option if we have very specific design requirements or have existing data.

• A template that is installed with Access    Consider using a template if starting a new project. Access has several templates installed by default.

This shows the database

Database1:Database (Access 2007 Micrasaft Access Hame Create Exal Data Datahasp Toals Datashept se Data Tye AutcNrber Delete Format: - Addie isting co umn Tă Rtramel View Releticnships Object %,n*A Field Field Fields Coumrn Rame Fields & Column Data Type &Fermanting Categery tableRemaDeaiatletal TbenableTble Customer Table All Tables Table1 Taible1:Table Table2 Rertal Tabic Emplayec Table Fields Add New Fiek customerid irstName Lastame Address city Now) Email Ta2: Tablc Tale Table Table5 Table: Table Table6 TakG: Table Category tabic Category tabi: Tab Rental Table Rental Table Table Clothing Table Cicthing Tabe:Table Employee Table Fmplayep Table:Table Customer Table Customer sle Isble Activate Windows Go to a Settings to activate Windows Reccrc: 1 of 1 &No Fikr earch O Type here to search ENG 11-04-2019 ^