Let us worry about your assignment instead!

We Helped With This ACCESS Database Homework: Have A Similar One?

More InfoMicrosoft Access Help

Short Assignment Requirements

Hi I'm attaching all the files for my homework. It uses Excel and Access

Assignment Description


Assignment 3 (25 points)

Due Date: October 4, 2016 (at the beginning of the class)


You are to implement a relational database using a standard Excel file (dataset3.xlsx) available on BeachBoard.  The database is intended to support online order taking and fulfillment operations that:  

1.      Enable customers to look up product related information, create customer profiles, place orders, and make payments;

2.      Allow order & shipping confirmation emails, shipping labels, and daily/periodic reports to be generated; and

3.      Support internal operations, such as recording and tracking of products, customers, as well as payment and shipping information.


Part A. Normalization to Minimize Data Redundancy


Examine the Order worksheet and identify redundant data.  Normalize the Order worksheet by breaking it up into two smaller ones.  Specifically, you shall create a new worksheet to keep track of all orders received; on that new worksheet each order will get one and only one record. The other worksheet, to be named Order Details, shall contain attributes to keep track of the products and quantity required for each order.  


The resulting Excel file shall contain six worksheets, Product, Customer, Payment Method, Shipping Address, Order and Order Details.


Part B. Creating a Relational Database Using Microsoft Access


Use Microsoft Access to import all worksheets you come up with in Part A.  For each of the tables, be certain that you have designated a primary key (or have Access choose one for you, if applicable).  Primary key shall be indexed and unique.  To ensure data integrity, specify an appropriate data type for each of the attributes. 


Edit a relationship diagram to enforce relational integrity by linking tables together properly. 

Be sure relational integrity constraints are enforced, and where appropriate, choose the option Cascade Update Related Fields.  We typically relate two tables by linking the foreign key from one table to the primary key of the other.  However, if the two attributes (fields) are not compatible (i.e., having different data types), or if there are any existing data inconsistency, Access will not allow you to establish the relationship.  Provide a screen print of the relationship diagram showing all tables, primary keys, and non-key attributes.  


Design and print out a Relationship Report.  Note that Relationship Report is a formal report documenting the database you are implementing.  It shall have your relationship diagram on one single page, plus a report title and date.  Name it “Relationship Report for Assignment 3” and save it accordingly.  Make sure there is no truncation of tables or attribute names.  You may find landscape orientation desirable when printing out the relationship report. 


C. Inserting Records


Insert a new product record:

Product No: 600312

Product Name: PNY Elite 64GB USB 3.0 Flash Drive

Product Category: Storage

Quantity on Hand: 20000

Safety Stock: 2000

Unit Cost: $12.00

Unit Price: $19.95


Insert a new shipping address for Brad Pitt:

Shipping ID: S-619

Customer No: 1005

Recipient L_Name: Jolie

Recipient F_Name: Angelina

Shipping Street Address: 205 Broadway

Shipping City: New York

Shipping State: NY

Shipping Zip Code:10012


Insert a new customer record:

Customer No: 1018

Customer L_Name: Wang

Customer F_Name: Stan

Email: ...

Password: GoodGuy


A new customer, James Bond, just placed an order for two units of 200415 and two units of 400258. Using below data related to customer, order, payment and shipping, insert the needed records into the database to capture the transaction:

      Order No: 300-20; Order Date: 9/20/2016

      Customer No: 1020; Email: ...; Password: Bond007

      Payment No: P-422; Name on Card: James Bond; Card Type: Discover; Card No:

6011002020524567; Expiration Date: 12-19; Security Code: 888

      Shipping ID: S-620; Recipient L_Name: Wang, Recipient F_Name: Stan; Shipping Street Address: 1250 Bellflower Blvd. CBA 432; Shipping City: Long Beach; Shipping State: CA; Shipping ZIP Code: 90840


D. Deleting Records


Lionel Messi (Customer No 1013) decided to cancel the order he placed (Order No 300-17) that has not been processed. Delete the needed records so the order will not be fulfilled.  Because the payment card is not charged until the order is shipped, there is no need to process credit back to the payment card.   


Submit a hardcopy report that includes a cover page, plus the following:


1.      a screen print of the relationship diagram you come up with;

2.      Relationship Report for Assignment 3; and

3.      all database tables in datasheet view (not screen print) in the order of Product, Customer, Payment Method, Shipping Address, Order and Order Details.  Be sure there is no truncation of attribute names or data. 

Frequently Asked Questions

Is it free to get my assignment evaluated?

Yes. No hidden fees. You pay for the solution only, and all the explanations about how to run it are included in the price. It takes up to 24 hours to get a quote from an expert. In some cases, we can help you faster if an expert is available, but you should always order in advance to avoid the risks. You can place a new order here.

How much does it cost?

The cost depends on many factors: how far away the deadline is, how hard/big the task is, if it is code only or a report, etc. We try to give rough estimates here, but it is just for orientation (in USD):

Regular homework$20 - $150
Advanced homework$100 - $300
Group project or a report$200 - $500
Mid-term or final project$200 - $800
Live exam help$100 - $300
Full thesis$1000 - $3000

How do I pay?

Credit card or PayPal. You don't need to create/have a Payal account in order to pay by a credit card. Paypal offers you "buyer's protection" in case of any issues.

Why do I need to pay in advance?

We have no way to request money after we send you the solution. PayPal works as a middleman, which protects you in case of any disputes, so you should feel safe paying using PayPal.

Do you do essays?

No, unless it is a data analysis essay or report. This is because essays are very personal and it is easy to see when they are written by another person. This is not the case with math and programming.

Why there are no discounts?

It is because we don't want to lie - in such services no discount can be set in advance because we set the price knowing that there is a discount. For example, if we wanted to ask for $100, we could tell that the price is $200 and because you are special, we can do a 50% discount. It is the way all scam websites operate. We set honest prices instead, so there is no need for fake discounts.

Do you do live tutoring?

No, it is simply not how we operate. How often do you meet a great programmer who is also a great speaker? Rarely. It is why we encourage our experts to write down explanations instead of having a live call. It is often enough to get you started - analyzing and running the solutions is a big part of learning.

What happens if I am not satisfied with the solution?

Another expert will review the task, and if your claim is reasonable - we refund the payment and often block the freelancer from our platform. Because we are so harsh with our experts - the ones working with us are very trustworthy to deliver high-quality assignment solutions on time.

Customer Feedback

"Thanks for explanations after the assignment was already completed... Emily is such a nice tutor! "

Order #13073

Find Us On

soc fb soc insta

Paypal supported