Create a spatial database containing typical business

Assignment Help Database Management System
Reference no: EM131431740


Create a spatial database (in an Excel spreadsheet) containing typical business information. The first row of the file must be a header row with descriptive titles. The source of this file can be anything that is real. For example, use a list of government offices (e.g., office for tourism, military recruiters, or the IRS) for cities or counties.

Or use locations of fast food restaurants, U.S. post offices, retail stores, or malls. It is highly recommended that you do not target an area larger than a county for your database entries. For example, your database could contain all of the fast food restaurants in Adams County, North Dakota.

Mix up the type of entities to be included. For example, if the file will be a list of fast food restaurants, include in the list several competing brands. If retail stores are chosen, use several different store chains. If government offices are to be used, use several types of government offices, such as tourism offices, post offices, jails, or municipal yards.
Include the following fields or columns of data

ID = A unique line number or identifier for each line entry. This is required by some software.

Name = First name, last name, or business name. This may be used as a label on a map to identify an entity.

Address = A real street address is required

City = Use the real city name.

State = Use the state name

ZIP Code = Use the five-digit ZIP code, not the Plus 4. Leading zeros may be dropped. For example, 02148 can be shown as 2148

Latitude = Use decimal location (e.g., 40.67)

Longitude = Use decimal location (e.g., 30.32)

Type = A unique code for the type of business. For example, Sears stores can be represented by S, Macy's can be represented by M, and JCPenney can be represented by P.

Reference no: EM131431740

1nf figure converted to 2nf figure

1NF figure converted to 2NF figure with a explanation of the steps taken. Once in 2NF, it needs to be converted to 3NF, and explanation of steps taken is needed as well.

Create a good project based on online diary and event manage

Create a good project based on online diary and event management. users can register and create daily/weekly/yearly events,create contacts,upload media and sent messages to th

Creates a database named personnel

Write an application that creates a database named Personnel. The database should have a table named Employee, with columns for employee ID, named position, and hourly pay r

Find the sids of suppliers who supply every part

Find the sids of suppliers who supply every part. Find the sids of suppliers who supply every red part. Find the sids of suppliers who supply every red or green part.

Security plan for the database

This project will help you apply all the concepts covered in this course for a given scenario. Vince Roberts runs a vintage record shop in the University district. Security

Create a second normal form logical database model

You are then to create a second normal form logical database model and explain why you made the changes from the first normal form database using the second normal form rule

Interaction in a tic-tac-toe game

Write a PhoneContact class that gets initialized with a phone number and a label. The phone number should follow one of the formats of the Phone class from the previous assi

How virtual applications and desktops or both will delivered

Regional Gardens Ltd is a company that runs number related gardening enterprises. It has a large display garden that it opens for public inspection a number of times in a ye


Write a Review

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd