Project Deliverable 3: Database and Programming Design

Aug 7th, 2015
SKTFaker
Category:
Computer Science
Price: $100 USD

Question description

The company that you work for is a document processing company, which offers a subscription service to clients. The company scans websites for relevant information and then provides a report based on customer's needs. The company collects the data and then analyzes the data.  

 Pied Piper is slowly becoming one of the most recognized 

names in open source data analysis for law enforcement, law firms, and the government. I am 

excited about the road ahead and the new challenges that we will face as we grow. Currently 

Pied Piper consists of ten employees with revenues of five million dollars a year. Those numbers 

are expected to grow to thirty employees with revenue of thirty million dollars over the next two 

years. As we are a start-up company, we do not have a building or technology infrastructure to 

support the business.

Write a five to ten (5-10) page design document in which you:

a. Create a database schema that supports the company’s business and processes.

b. Explain and support the database schema with relevant arguments that support the rationale for the structure. Note: The minimum requirement for the schema should entail the tables, fields, relationships, views, and indexes.

c. Create database tables with appropriate field-naming conventions. Then, identify primary keys and foreign keys, and explain how referential integrity will be achieved.

d. Normalize the database tables to third normal form (3NF).

e. Create an Entity-Relationship (E-R) Diagram through the use of graphical tools in Microsoft Visio or an open source alternative such as Dia. Note: The graphically depicted solution is not included in the required page length but must be included in the design document appendix.

f. Explain your rationale behind the design of your E-R Diagram.

g. Create a Data Flow Diagram (DFD) through the use of graphical tools in Microsoft Visio or an open source alternative such as Dia. Note: The graphically depicted solution is not included in the required page length but must be included in the design document appendix.

h. Explain your rationale behind the design of your DFD.

i. Create at least two (2) sample queries that will support the organizational reporting needs.

j. Create at least two (2) screen layouts that illustrate the interface that organizational users will utilize.


Your assignment must follow these formatting requirements:

  • Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.
  • Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length.
  • Include charts or diagrams created in MS Visio or Dia as an appendix of the design document. All references to these diagrams must be included in the body of the design document.



Tutor Answer

(Top Tutor) Daniel C.
(997)
School: Cornell University
PREMIUM TUTOR

Studypool has helped 1,244,100 students

7 Reviews


Summary
Quality
Communication
On Time
Value
kpcutie
Dec 5th, 2016
" Excellent job "
Hemapathy
Nov 22nd, 2016
" all I can say is wow very fast work, great work thanks "
BlueOcean
Nov 8th, 2016
" Awesome! Exactly what I wanted. "
kevin12622
Oct 30th, 2016
" Goes above and beyond expectations ! "
ashleyisgod
Oct 17th, 2016
" Top quality work from this guy! I'll be back! "
likeplum4
Oct 8th, 2016
" Excellent work as usual "
Molly_Moon
Sep 24th, 2016
" AMAZING as always! "
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1829 tutors are online

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors