Question: PLEASE HELP ME. DO IT ASAP PLZ. Project Focus Your job is to complete the following tasks: 1. Develop and describe the entry-relationship diagram 2.

PLEASE HELP ME. DO IT ASAP PLZ.

Project Focus

Your job is to complete the following tasks:

1. Develop and describe the entry-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 DVD 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. Create a report to show the total rental revenue generated by each employee.

9. Create a report that show the daily invoice (rental details) for each customer

All Access UpieCts CustomerldFirstName Address Sabrina 167 w 160th 2376 parkterrace ave 114 E 35th st 620 west 42nd st 90 W 125th 134 e 25th st 2816 parkview ter 2089 grandconcourse 2121 morrirs ave 102 E 31st 2020 jermone ave 511 Madison ave 1234 Morton St 645 east 43th st 2815 parkview ter 123 west end ave 80 west 125th st 89 E 4th 2347 Sedgwick a 113 E 34th st New York Bronx Brooklyn New York NY 10036 2127490213 Gilbert485@yahoo.com New York Brooklyn NY11213 9174895500 damon90@hotmail.com Bronx Bronx Bronx Brooklyn NY 11214 9178902345 norman65@yahoo.com NY 10045 6465879254 sbaez1@aol.com NY 10468 34754?8697 shaylam.98@gmail.com NY 11214 9178630089 penaj02_1@hotmail.com Tables Martin Category Customer DVD C11 osuha Gilbert Ward Berenal Salvatore C13 C14 C15 C16 ?C17 C18 C19 Elena Damon Stefan essica Norma Norman Robert NY 10384 2128904577 elena45@aol.com Employee NY 10468 ?465378989 stefanvamp@hotmail.com NY 10467 3478569081 bates101j@aol.com NY 10456 7185469823 pimentel07?@gmail.com Rental RentalDetail Pimentel NY 10467 ?468763241 robertrob@hotmail.com NY 10024 2124257896 santana30@gmail.com NY 67530 ?207924303J.Maler@yahoo.com NY 10068 2126748374 santana30@gmail.com NY 10468 3476453839 ashash02@yahoo.com New York Brooklyn New York Bronx New York NY 10012 2126669876 jones123@aol.com New York NY 10013 ?463754339 hernandez-01@gmail.com New York NY 10046 2128764352 jayjay67@gmail.com Bronx Brooklyn C20 Johanna Maler Junior Ashley Stephanie Hernandez Jairel Ericka NY 10468 7186905323 erickagarcia2@gmail.com Thompson NY 11214 ?467869504 thompsonb05@aol.com

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Project 2 (Furniture Rental) Comfort Rental is a rental company located in Brooklyn, New York, specializing in rental of furniture for the home industry. Over the past 9 months, her business has...

please develop a spreadsheet to solve the companys issues Billing Data On-The-Level Construction Company is a Denver-based construction company that specializes in subcontracting the development of...

In this part of the assignment, you will leam to create an Entity Relationship Diagram (ERD) for a construction company using the data provided. On-The-Level Construction Company is a Denver-based...

EXAMPLE OF WHAT IT WILL LOOK LIKE FIGURE AYK.5 On-The-Level-Construction Detail Report Source: Microsoft PROJECT EMPLOYEE JOB ON-THE-LEVEL CONSTRUCTION PROJECT DETAIL ASSIGNMENT PROJECT NAME ASSIGN...

SIT103 Data and Information Management T2, 2023 Summative assessment task-2: A real-world database design and implementation project Due dates: Part-1: Project proposal, due date: Wednesday 10th May...

PROJ ECT/ASSIG N M ENT ACTIVITY Instructions for; Assessor The Learner must demonstrate the ability to complete the tasks outlined in the elements, performance criteria and foundation skills of this...

please answer the task 10 of part 4 cost and quality management as per the following requirements please give the correct answer ASAP IT project management IT project management subject it an health...

please help I need this by tonight ASAP. if you solve this i will give you the BEST RATING. ALL I NEED IS THE FULL DETAILED CODE FOR THE MULTITASKING COMMANDER. other commanders are finished. I...

Overview - case based assessment This assessment is weighted at 40% of the final mark for this course. Observing and studying the leadership behaviourof someone in a leadershiprole can be helpful in...

Recall we define SXT = {(s, t): sS and t T}. For each of the following, prove it if it is always true, else give a counterexample. SXT=TXS SXT = 0 if and only if S = 0 or T = 0 Sx (TxR) = (SxT) XR...

You own a four-unit apartment building that generates $3,500 per unit in rent each month. Each unit is 3,000 sq. ft. in size and all units are occupied by long-term tenants. You want to redevelop the...

The bond angles in C O 3 2 - are expected to be a little less than 1 2 0 . a little more than 1 2 0 . a little less than 1 0 9 . 5 . 1 2 0 . 1 0 9 . 5 .

8:37 * N. 80% i ... OBJECTIVES: Create relationships Create a Pivot Table from Related Tables Create a PivotChart Modify the PivotChart The major section in this chapter :ontinuation is: Data...

=+example, is the piece effective? Audiencecentered? Ethical? Using whatever medium your instructor requests, write a brief analysis of the piece (no more than one page), citing specific elements...

=+Locate an example of professional communication from a reputable online source. It can reflect any aspect of business communication, from an advertisement or a press release to a company blog or...

=+next two to three months. You have to decide whether to tell them now so they can look for new jobs as soon as possible, even though youre not yet that sure layoffs will be necessary, or wait until...