Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

1105 shackleton road apex nc 27502

29/10/2021 Client: muhammad11 Deadline: 2 Day

Computer Assignment!

Summer 2013

Project 3. Design and Implement a Database for The Trailhead using Access 2010

Worth: 81 points

Due: Tuesday, June 25 th

@ 11pm

Read all descriptions and instructions carefully and pay attention to detail.

Imagine that you are newly hired at The Trailhead store (http://www.trailheadmontana.net/) in downtown

Missoula to design and implement a new database system. First become familiar with this store, the gear and

products they sell, and the services they provide (like rentals). You will design and implement part of a database

for this single store only, and are not to consider any potential branch locations.

Follow each of the steps outlined below to complete this project:

1. Design your database (30 pts). Before you implement a database, it’s critical to think through the design thoroughly first. The first step of your assignment does not involve using Access.

On paper, either hand-drawn or using a software program like Word, do the following:

a. Identify and show at least 5 tables that would be relevant for your database. Note that I don’t want

you to use any tables that maintain Customer data, like name, address, etc.

b. For each of the tables you list in step 1a, show the data that each will contain. You should have

somewhere between 4-8 fields per table. Remember to store data in its smallest parts as described in

your text.

c. For each piece of data in all of your tables, choose a meaningful name to describe the data. List the

appropriate data type for each field of data, and be sure to incorporate a good sampling of different

data types throughout.

d. Establish and identify the primary key of each table. Establish and identify foreign keys in tables,

and show via links what tables they connect (e.g., see Figure 2.2 in your text).

e. Based on your design thus far, come up with 5 different queries that users of your database would

likely want to run. At least two of these queries should involve multiple tables (the other three can

use one table only). Give each of these queries a short but meaningful name, and write them out in

your design document. Note which tables are used in each query.

For example, a possible query that the Trailhead store manager might want to know is: “How much

profit did my store make from kayak rentals in the month of June?” A good name for this query

might be June profit. Note that this query is just an example and may not be supported by the tables

you chose to design. You have to determine what does make sense for your database.

f. Save your design document, put your name and a Heading on it, scan it in if necessary, and call the

file p3trailhead_design_LastnameFirstname

2. Implement your database (25 pts). Using your database design from Step 1 and Access 2010, implement your database by doing the following:

a. Create a new database in Access 2010 and name it p3trailhead_LastnameFirstname

b. Create tables based on your design document. Include all field names, data types, primary keys and

foreign keys.

c. Create relationships between tables based on your primary and foreign keys as shown in your design

document. Make sure to enforce referential integrity when you create these relationships, and choose

Cascade Update for related fields.

d. Enter sample data into each of your tables. There should be 5-10 rows of data per table. Do not use

any real names or other potentially sensitive data in your database.

3. Create queries (20 pts).

a. In your Access database, create each of the 5 queries you indentified in Step 1 of this project. Run

them and save them using meaningful/descriptive names. Remember, at least two of these queries

should be multi-table queries.

4. Finalize and Submit (6 pts). Compact and repair the database. Make a backup copy. Submit both the design document and your database to finish this project.

If you have questions, email me at reimer@cs.umt.edu

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Essay & Assignment Help
Phd Writer
Finance Homework Help
A Grade Exams
Maths Master
Calculation Guru
Writer Writer Name Offer Chat
Essay & Assignment Help

ONLINE

Essay & Assignment Help

I reckon that I can perfectly carry this project for you! I am a research writer and have been writing academic papers, business reports, plans, literature review, reports and others for the past 1 decade.

$29 Chat With Writer
Phd Writer

ONLINE

Phd Writer

I will provide you with the well organized and well research papers from different primary and secondary sources will write the content that will support your points.

$17 Chat With Writer
Finance Homework Help

ONLINE

Finance Homework Help

This project is my strength and I can fulfill your requirements properly within your given deadline. I always give plagiarism-free work to my clients at very competitive prices.

$23 Chat With Writer
A Grade Exams

ONLINE

A Grade Exams

I have read your project details and I can provide you QUALITY WORK within your given timeline and budget.

$41 Chat With Writer
Maths Master

ONLINE

Maths Master

I reckon that I can perfectly carry this project for you! I am a research writer and have been writing academic papers, business reports, plans, literature review, reports and others for the past 1 decade.

$24 Chat With Writer
Calculation Guru

ONLINE

Calculation Guru

I have done dissertations, thesis, reports related to these topics, and I cover all the CHAPTERS accordingly and provide proper updates on the project.

$33 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

All american boys chapter summary - Heart of darkness heads on sticks - Part of a tree - Johnson and johnson tylenol crisis management - Macquarie group capital notes - Mulberry ward barnet hospital - Hydrolysis of t butyl chloride lab report - Https writingcenter unc edu tips and tools literature reviews - Blue cloud gets agile case study - Tricon restaurants international globalization reexamined - Medallion signature guarantee australia - Cvp analysis exercises answers - Schatz hollywood genres - How to use a circle map - Module 4 Writing work - Capacity planning in operations management ppt - 801/489 hunter street newcastle - Capacitor filter in rectifier - Honey spot play script - Unraveled marc dreier watch online - Assignment on e commerce pdf - When were motte and bailey castles built - Limitations of the behavioural approach - NUR601- MODULE 5 ASSIGMENT - Lane bryant mail order catalog - Biome map coloring worksheet ask a biologist - Mariana canta en el coro choir de la universidad - 5 pages of CONTEXT HRM report. Details provided in attachments. - Vedas vs quran vs bible - The lb crate is supported by cables - Joan didion analysis - English sba reflection 2 - Summery - Hey buddy can you spare a dime worksheet answers - Math - Finance - Five key management theory principle milestones over time - What is the bus in a computer - The body shop income statement - Meaning behind drink a beer by luke bryan - G1 2 thread drill size - Starting out with visual basic 2012 pdf - CHRISTIAN SERVANT LEADERS - Johns hopkins nursing evidence based practice rating scale - 10 Minute Pitch - Netscaler policy cannot be bound to specified policy label - Activities for Writing Assignment - In calculating gdp transfer payments are - Click and learn virus explorer answers - List of hcpcs level ii modifiers - Racv emergency home assist contact number - Organizational communication 3 - Curtin university exam results - Williams refrigeration spare parts - Dot and cross diagram for hf - Jorgensen lighting inc manufactures heavy duty street - Culinary arts association of south africa - Walmart global ethics online complaint form - Preparation of cinnamic acid from benzaldehyde - Health Organization Evaluation - Sales cloud consultant dumps - Cba 2018 annual report - Need Help - Classical conditioning in advertising coca cola - Unit 12 internet marketing m1 - Business - Case Study - An electronic component for a medical x ray - Scholarly leadership theory wgu - Security Architecture and Design - What type of company would use a process costing system - Betasustainability etf units - Complementary and Alternative therapies - Cisco business edition 7000 ordering guide - History Essay three pages double spaced - What does sg & a stand for - Shop direct finance company very - General mills vision statement - Discussion - Daca essay thesis statement - Anz eftpos rolls order online - La ensalada el camarero nos la sirvió - Acids and bases quiz - Excel 2019 In Practice - Ch 7 Independent Project 7-6 - Find the exact value of sin - Dissertation Topics , Due date 26th September - Mindful reflection as a process for developing culturally responsive practices - Topics - Dictionary dig task cards - Cpl e learning answers - Edcc.instructure - Hurlcon gas heater f2 error - Managerial Accounting - We lived like birds of passage - Short phys quiz - Practical connection assignment - Shanghai jiao tong university summer chinese language program - Tv antenna tower collapse case study - Fin 534 homework set 1 - Managerial finance discussion