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

Vince's vinyl database

02/11/2020 Client: papadok01 Deadline: 3 days

PT2520

Project

1

PROJECT DESCRIPTION

Project Introduction:

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. His shop sells 45s, LPs and old 76 RPM records. Most of

his stock is used. He buys used vinyl from customers or finds them at yard sales and discount stores. He

does sell some new albums that are released on vinyl. So far, he has kept most of his inventory either in his

head or in a spiral notebook he keeps behind the sale counter. But his inventory and his business have grown

to where that is far from sufficient.

In this project, you will review the information given in the scenario and based on that information, create the

following documents pertaining to the scenario:

Statement of Work (SOW)

Business requirements and rules

ERD

Security plan for the database

Course Objectives Tested:

1. Define a relational database.

2. Gather database requirements.

3. Define business rules for a database.

4. Create an entity design for a database using MS Visio.

8. Define the security context of a database and its users in MS SQL Server.

PROJECT SUBMISSION PLAN

Description/Requirements of Project Evaluation Criteria

Title: Compile a Database

Project Details: Click here to review the Vince’s Vinyl database

scenario. Based on your review of the scenario, complete the following

tasks:

Create a Statement of Work (SOW). Include a brief history, a

statement of scope, objectives, and a preliminary timeline. You

should aim to complete this database in one month’s time. Click

Did you create a SOW that

includes history, scope,

objectives, and timeline

with deliverables?

Did you create a

comprehensive list of well-

defined requirements

grouped by different

http://www.content.distance-education.itt-tech.edu/cliksdmrroot/content_directory/mount1/507393/PT2520/pt2520_vince_vinyl_scenario.docx
PT2520

Project

2

Description/Requirements of Project Evaluation Criteria

here for SOW format.

Make a list of four to five issues with the current system in

Vince’s shop. Make a list that shows the database requirements

for each stakeholder involved in the database.

Create a set of four to five business rules for the database.

Review the requirements and rules that you have gathered after

reviewing Vince’s records scenario. Based on this review,

define your entities and attributes and the relations that exist

between them.

Download Visio on your local PC. This software title is available

for download from ITT Technical Institute's DreamSpark

software download site. For more information, please review the

DreamSpark Implementation Guide, available at the ITT

Technical Institute Student Portal > Resources > Download

Center.

Create a logical Entity Relationship Diagram (ERD) using crow’s

feet notation in Visio. Review and normalize your ERD.

Evaluate all entities against the first three normal forms.

Create a security plan that includes authentication and

authorization and general policies and procedures. Use roles,

stored procedures, views, and other tools in your security plan.

Create a preliminary threat analysis for each user of the

database. Describe threats posed by each user to the proposed

database.

Make a preliminary disaster management plan. The plan does

not have to be full or elaborate, but should include some

policies about backup, access, and data recovery. It should

include some procedural lists for one or two of the tasks in the

stakeholders?

Did you build a

comprehensive list of valid

business rules?

Does your normalized

ERD contain all the

domain entities and all

attributes?

Did you create an

authentication and

authorization plan for each

user based on the user

needs of the database?

Did you create a threat

analysis plan identifying

potential threats from each

user?

Did you create a disaster

management plan for the

proposed database?

http://www.content.distance-education.itt-tech.edu/cliksdmrroot/content_directory/mount1/507393/PT2520/pt2520_sow.docx
PT2520

Project

3

Description/Requirements of Project Evaluation Criteria

disaster plan.

Submission Requirements:

Submit a SOW in a one- to two-page Word document.

Submit current issues, database requirements, and business

rules in a two- to three-page Word document.

Paste a copy of your normalized ERDs from Visio into a Word

document. Submit the Word document for grading.

Submit your authentication plan for each user of the database,

authorization plan, threat analysis identifying potential threats

from each user of the database, and preliminary disaster

management plan in a three- to four-page Word document for

grading.

Due: Week 6

Grading Weight: 15%

End of Project Description

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:

Online Assignment Help
Essay Writing Help
Quality Homework Helper
Top Writing Guru
Buy Coursework Help
Top Grade Essay
Writer Writer Name Offer Chat
Online Assignment Help

ONLINE

Online Assignment Help

Hi dear, I am ready to do your homework in a reasonable price.

$55 Chat With Writer
Essay Writing Help

ONLINE

Essay Writing Help

I am a qualified and experienced Writer, Researcher, Tutor, analyst and Consultant. I hold MBA (Strategic Management) (Finance and Marketing) & CPA.K (Accounting and Finance.)

$62 Chat With Writer
Quality Homework Helper

ONLINE

Quality Homework Helper

Hi dear, I am ready to do your homework in a reasonable price.

$62 Chat With Writer
Top Writing Guru

ONLINE

Top Writing Guru

I am an Academic writer with 10 years of experience. As an Academic writer, my aim is to generate unique content without Plagiarism as per the client’s requirements.

$60 Chat With Writer
Buy Coursework Help

ONLINE

Buy Coursework Help

Hi dear, I am ready to do your homework in a reasonable price.

$62 Chat With Writer
Top Grade Essay

ONLINE

Top Grade Essay

Working on this platform from a couple of time with exposure of dynamic writing skills gathered with years experience on different other websites.

$62 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

IWCAS1 - Unisa census date 2021 - Organ Leader & Decision Making - Hsc physics data sheet - L uomo universale definition - Http www apa org topics kids media food aspx - Eating disorder plan medicare template - Tyler is a very competitive and impatient stockbroker - Jim kawashima walgreens - Adding and subtracting integers test - Discussion Board - Methods of observation? - OMM622 WEEK 3 ASSIGNMENT - Co 3 electron configuration - The case for the contingent exclusionary rule - Tim o brien the things they carried essay - How sdn and ibn are related - BHD421 Module 2 Case - The lorelei poem by heinrich heine - Life cycle of snow leopard - Singapore airlines cover letter sample - Does sophanes deserve citizenship - Assignment 1 - Analytical procedures are required as a part of the - Social control theory - Burnley gov uk recyclenow - Abb sace s6 breaker manual - 100 Positive reply with 3 references due tomorrow - Module 4 Discussion-Obesity - Feldman's three-phase model of socialization and the six socialization tactics - What is kier spates net worth - Qperational. discuss 1 - Applying classical conditioning worksheet answers - Completing the Job Announcement - Quantitative reasoning ii project final presentation - Figurative language stories the dainty dragon answers - Samuel by grace paley thesis - You can create a single comprehensive issp document covering all information security issues. - Queen elizabeth i's speech to the troops at tilbury 1588 - Essay paragraph structure teel - Focused cough assessment shadow health - Rosebank retirement village sebastopol - Lesson Plan - Into the wild phrases - 4060 crystal oscillator circuit - Alice in wonderland fat twins - Difference between positive and negative feedback homeostasis - WEEK10-ResearchPaper-Enterprise Risk Management - Psychology - The Effects of Modern Development on the Health of the Population Overview week 10 hsa551 - Wishaw general hospital consultants - A diversified company has a parenting advantage when it - St andrews recycling points - Jesus said come forth - Importance of purchase management - Vicente y francisco jugar al vóleibol los domingos - How does sun microsystems make money - Introduction to moodle ppt - 3 what is the cannon bard theory of emotion - Razor over comb definition - Vincent owners club uk - Sir roden cutler vc memorial interchange - Is baristaing a word - Henoch schonlein purpura rch - IDM W 5 D - Journal of Criminal Justice. - World cultures and geography western hemisphere and europe - Air university style and author guide - Hess law of constant heat summation - Assignment 11 (use above videos and docs to complete Assignment) - How to build bottle up carnival game - Zappos ceo tony hsieh leadership style - Microbiology lab questions and answers - Media ethics issues and cases 9th edition pdf free - Balgowlah north public school band - Data structures and abstractions with java solutions - Infants and children prenatal through middle childhood edition - Max oxidation state of mn - 2012 exam 2 methods - Andrew sarris says that the crucial element in most films is - Cherry pink and apple blossom white musical ideas - Academic transcript la trobe - Lbs indos cell contact number - Bubaran kembang pacar - Polypropylene in automotive applications - Lesson 13: Percents Unit Test - Midterm reflection - How are standard costs developed - Boiler flue gas recirculation - Explain how the flexpath program aligns with your career goals - To find the distance across a pond - Harley-davidson marketing strategy case study - Co2 volume at stp - Type: Individual Project Unit: Role of Leadership - Advantages of a multicultural society and labor force - The nature of things season 59 episode 7 - Amenhotep ii and moses - Intrinsic and extrinsic motivation questionnaire for students - Gas in a closed container - Assignment Instructions: Write a 3-5 page (750-1250 words) essay, answering the following question: