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

17/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:

Top Essay Tutor
University Coursework Help
Academic Mentor
Writer Writer Name Offer Chat
Top Essay Tutor

ONLINE

Top Essay Tutor

I have more than 12 years of experience in managing online classes, exams, and quizzes on different websites like; Connect, McGraw-Hill, and Blackboard. I always provide a guarantee to my clients for their grades.

$65 Chat With Writer
University Coursework Help

ONLINE

University Coursework Help

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

$62 Chat With Writer
Academic Mentor

ONLINE

Academic Mentor

Hey, I have gone through your job posting and become very much interested in working with you.I can deliver professional content as per your requirements. I am a multi-skilled person with sound proficiency in the English language for being a native writer who worked on several similar projects of content writing and can deliver quality content to tight deadlines. I am available for both online and offline writing jobs with the promise of offering an incredibly responsive and supreme level of customer service. Thanks!

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

German hyperinflation of 1923 - What is a pre assessment in a lesson plan - When was the fall of the house of usher written - Why do cells need water - Eclipse calculator code - Energizer compact charger 12h - Lms motorsports grants pass oregon - Buffalo wild wings strengths and weaknesses - Amazon prime video case study - Cap coast netball association - Geologia / Geology - Does technology make us more alone persuasive essay - LeaderAsChangeAgent_Assessment2 - Considering Custom Shopify Development for Your E-Commerce Store? - What is a conflicting viewpoint - Canberra theatre centre jobs - Classifying systems of equations without graphing - How to calculate the field of view in a microscope - Carbon dioxide and limewater - Engenius durafon not ringing - L oreal in china marketing strategy - Current healthcare delivery models and practice settings - Turn turn turn ecclesiastes chapter 3 - Name five numbers between 0 and 1 - Abercrombie and fitch diversity issues - Southwestern university traffic problems case study solution - What you pawn i will redeem discussion questions - CSIA 300 Week 4 discussion - Bsbdiv501a assessment - Manchester university alumni association - Consistent and inconsistent systems calculator - Barracania - The dark child chapter 1 summary - Bmw s1000rr service intervals - Tuesdays with morrie table of contents - 3 page paper on a criminal case - Pdp samples for teachers - Statistics hypothosis paper APA - Ag144ut 001 a4 compressor - Corporate finance cases and solutions - Mystic monk coffee vision and mission - Casa form 61 9r - Human resource planning reference books - Community teaching work plan proposal - Fundamentals of supply chain management dr dawei lu - Global supply chain management simulation cell phone tips - 25 ways to lower inventory costs - Cloud Computing - Hypervisors - Nonpf core competencies apa citation - #{91 =9876751387}{ Kala jadu specialist baba ji in Australia - Short answer - Can Someone Do My Dissertation For Me In UK? - Network diagram critical path questions - Ca skill assessment application form - T rowe price 401k aldi - Bus times perth to bridge of earn - Copy an angle construction worksheet - Acids and bases worksheet - Knowledge base psychology definition - Journal - Recommendation for ed - Laminex honey elm riven - Week 9 assisg - A silver wire 2.6 mm in diameter - Why doesn't atticus help carry out maudie's furniture - Mulga tree adaptations to the desert - Distinctive qualities of a text - What is not a function of the skeletal system - Ben and jerry's logo - Academic vs technical writing - Covey time management matrix - 3. identify three structures which provide support and protection in a eukaryotic cell. - Direct and indirect proportion - Technology - Vouch recorded sales invoices to supporting shipping documents - Week 5 Assignment - Root cause analysis for patient falls - Cbus member log in - Answer to essay-200 words minimum. YRP - Me-7 - Marriage in the 16th century - The greatest journey pdf - Melting point of urea and cinnamic acid - Index of project blue book - Isosceles right triangle reflection to prove asa congruence - The ugly american summary - Holy cross catholic church burnaby - Logan labs soil test - Antibiotic resistance can we ever win answers - St lucia land registry - Mtv the wellness movement and watergate affected which generation - Is lpg denser than air - 10 minute micro teach ideas - Regent sports and social club - Value proposition canvas strategyzer pdf - Gorilla playing drums cadbury advert - How to unlock macbook pro 4 digit pin - The western jeans company purchases denim from cumberland textile mills - Southwest airlines case study stanford graduate school business - River community hospital case study solution