Identify entity and relationships that implied by geocaching

Assignment Help Database Management System

Reference no: EM13934768

Assignment: Database Design

This assignment is to be done by students in groups of 1, 2 or 3.

The assessment items have been designed to allow you to acquire and use the concepts in the unit as a way to better understand your world - with an emphasis on the quality of design.

The Task

Geocaching is a popular global pastime. Your task is to identify the entities and relationships that are implied by the geocaching cache page (see below). In effect, you will be analysing the structure of the database that supports the site.

It is preferable that you investigate this domain by logging on to geocaching.com (it's free) and having a good look around (why not go find a cache?). If you have any qualms about setting up a login, just use the screenshots below.

As with assignment 1, model the domain, create an E-R diagram & data dictionary, build a prototype database by creating the tables and populating them with at least 3 rows of dummy data, take screenshots and compile a data dictionary then show how your database would meet the requirements for displaying the cache page and statistics pages (see below).

Team Work

Design is usually best done in teams. This is because ideas are generated and tested in a (generally) supportive environment and several minds are much better than one. In other units you will learn about team work, but that's not part of the curriculum of database design, so you have options:

1. If you want to do the assignment yourself, you may (a team of 1).

2. If you want to work with others in your tute, firstly get together and talk about it... start with

https://www.mycollegesuccessstory.com/academic-success-tools/student-team-tips.html

then ... play nice...

Beware of one thing - your assignment must either be identical to others named as being in your team, or quite different from any others.

What to Submit

Each student submits a Word document at the assignment 2 dropbox.

All students in a team submit the same document.

As with Assignment 1, your document should contain:

Identifying information - especially the ids of your team members

A brief introduction to your assignment saying what's in it

An ER Diagram (screenshot from your DBMS relationship view)

Assumptions or business rules noted to explain your interpretation of geocaching

Data dictionary (screenshots of design view of tables with description of each field)

Dummy data (data sheet view of tables)

Description of how the cache and statistics can be created from your database

Queries needed to generate the pages at least 3 queries in native SQL (ie. not SQL view of the Access query creator)

Optional: Any comments you would like to make about your team members contributions.

Geocaching.com

Below are screenshots of (1) A Cache page and (2) A Statistics Page which together provide the scope of your analysis. You do not need to include the maps or the download files (LOC waypoints, etc) (unless you want to!).

(1) A Cache page

2) A Statistics Page.

Reference no: EM13934768

Questions Cloud

Find the future value of the annuities : If you deposit $10,000 in a bank account that pays 10% interest annually, how much will be in your account after 5 years? 4-2 What is the present value of a security that will pay $5,000 in 20 years if securities of equal risk pay 7% annually? 4-12 F..

Discount factors-spot interest rates-forward interest rates : Take the bond price data given on 50 bonds. Each bond has a face value of $100 and pays the given coupon semi-annually starting at the next coupon payment dates as given. Follow the steps discussed in class to estimate the term structures of discount..

Two argument integers and returns the operation : The over all program should ask user for two integer numbers (a, b) and target arithmetic operation (+,-,*./) and will print the result of the operation with a comment if the result produced is correct or not.

Providing a historical context and legal framework : Select and discuss 3 landmark legal cases (from the list above) that involve Asian Pacific Americans between 1885- 1990. Discuss each one, providing a historical context and legal framework from which to understand these cases impact on Asian Pac..

Identify entity and relationships that implied by geocaching : Your task is to identify the entities and relationships that are implied by the geocaching cache page (see below). In effect, you will be analysing the structure of the database that supports the site.

Using datagrid in an application : Update the field named fldQuestionDescription.

Sum-of-products representation : Run the program using step mode. Put the code inrto the online assignment area. Also indicate the new contents of the register affected by each instruction. For this you need to use the step mode.

Describe arbitration and discuss advantages to litigation : Describe mediation and discuss its advantages to litigation. Describe two other forms of alternate dispute resolution and discuss their advantages to litigation.

Why would you inherit from a string class : How would you use Integers and Strings in an application?

User Account

All Pages