ISM530 Table creation data insertion and query

ISM530 Table creation data insertion and query

ISM530 – Task 4

Create these tables, insert data and make query based on the followings, please include screenshots for table creation, data insertion and query to retrieve the data:

Here is what I would like to have for our data warehouse. Following up on our GIS theme, our datawarehouse is to be used to trace contacts that a person had with others, for use with tracking folks who have a contagious disease.

For our database, we will model a small piece of a small town.

The town will have people, so we need a table for person, we can call it person. The table needs to have a primary key (int), firstname, lastname, vaccination date, gender, birthday, street number, street ID, business ID, school ID. This gives us a person table with lots of links to other tables.

We need a business table, That will have a business ID, business name, street number, street ID, owner ID (which is a link to person table).

We need a home table. That will have a home ID, street number, street ID, square footage. (extra fields could be added here but probably not needed)

We need a school table. That will have a school ID, street number, street ID, name, lower grade, upper grade, number of classrooms

We need a street table. That will have a street ID, direction north/south or east/west, starting number, ending number, number of lanes

Once we have the tables made and populated, we will want to find all the people who live at an address, all the people who work at a business, all the people who attend a school. Now folks could work at a school or attend a school.

The fields above that I called ID are just the primary key. Most databases will allow for an autonumber, which ensures that the records have a unique primary key.

For our prototype, we need to put in some number of records and setup the relationships for those to show for example that a person works at a certain business and lives at a certain house. These keys for person should be done after the other tables are built, because person really holds the whole schema together via the primary/foreign keys.

Right now, I figure we need at least 15 homes, 25 people, 10 businesses, 3 schools, and 10 roads.

Work on the design right now, and we will work on populating the tables once you have the design put together.

(See if your database will support import from an excel file or other comma delimited file to make life easier.)

Rubrics:

Prototype of the Warehouse: Presents a functional prototype of the warehouse with data, sample queries, and documentation on requirements. The prototype while functional for testing is not a final model that has been programmed but is ready for programming in SQL. Includes results of collection of feedback from stakeholders on prototype.

Data Warehouse Test Plan and Results Document: Describes the test plan to validate the data model with the customer and determining if the model works as expected, and if it comprises all of the required data. Includes details of the plan along with the results documentation for testing of the prototype with stakeholders. An analysis of the results is included along with recommendations for changes.

Resources:

https://www.linkedin.com/learning/learning-microsoft-business-intelligence-stack/welcome?u=56747577

http://prx-stratford.lirn.net/login?qurl=http://library.books24x7.com/library.asp%3f^B%26bookid=53708

 

Place your order
(550 words)

Approximate price: $22

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more
Open chat
1
You can contact our live agent via WhatsApp! Via + 1 (409) 205-8984

Feel free to ask questions, clarifications, or discounts available when placing an order.

Order your essay today and save 30% with the discount code GURUH