ENG 121(Ash) Experience Tradition/newtonhelp.com

1
ENG 121 Experience Tradition/newtonhelp.com
2
ENG 121 Experience Tradition/newtonhelp.com

• For more course tutorials visit
• www.newtonhelp.com
• Write a 700- to 1,050-word informal paper using
  Microsoft Word in which you address the
  following
• Accurately definethe terms "database system" and
  "relational database architecture".
• In your Learning Team next week, you will have a
  defined application for a database that you will
  construct together, but this week, think about
  what you personally could use a database for in
  your personal life. Choose a subject from your
  work/home/hobby that requires the keeping of
  multiple records e.g., music collections, sales
  records, inventory. You will not be creating this
  database in this course, but will use the idea
  this week to practice

3
ENG 121 Experience Tradition/newtonhelp.com

• For more course tutorials visit
• uophelp.com is now newtonhelp.com
• www.newtonhelp.com
• DBM 380 Week 1 Individual Assignment DataBase
  Paper (New)
• DBM 380 Week 1 DQ 1 (New)
• DBM 380 Week 1 DQ 2 (New)
• DBM 380 Week 2 Team Assignment Service Request
  SR-ht-003 Change Request 2 (New)
• DBM 380 Week 2 Individual Assignment Database
  Environment Paper (New)

4
ENG 121 Experience Tradition/newtonhelp.com

• For more course tutorials visit
• uophelp.com is now newtonhelp.com
• www.newtonhelp.com
• What limitations have you or someone you know
  encountered in the past in using nonrelational
  structures (such as in a Microsoft Excel or
  Word file) to store data? What were the
  advantages?

5
ENG 121 Experience Tradition/newtonhelp.com

• For more course tutorials visit
• uophelp.com is now newtonhelp.com
• www.newtonhelp.com
• DBM 380 Week 1 ASSIGNMENT
• Individual Database Environment Proposal
• As one of the program outcomes for the Bachelor
  of Science in Information Technology program,
  students must design and develop a database using
  professional principles and standards.
• Write a 1- to 2-page memo in which you complete
  the following

6
ENG 121 Experience Tradition/newtonhelp.com

• For more course tutorials visit
• uophelp.com is now newtonhelp.com
• www.newtonhelp.com
• Write a 350- to 700-word paper in which you do
  the following
• Explain what database systems are and
  how they are used.
• Define database architecture. Consider
  Microsoft Access, Microsoft SQL Server,
  Oracle, and IBM DB2 software as possible
  examples.

7
ENG 121 Experience Tradition/newtonhelp.com

• For more course tutorials visit
• uophelp.com is now newtonhelp.com
• www.newtonhelp.com
• Think of a situation where null value should be
  allowed and a situation where it should not be
  allowed. What are the consequences of
  inappropriate null settings?

8
ENG 121 Experience Tradition/newtonhelp.com

• For more course tutorials visit
• uophelp.com is now newtonhelp.com
• www.newtonhelp.com
• Why it is necessary to choose appropriate data
  types for each data column?

9
ENG 121 Experience Tradition/newtonhelp.com

• For more course tutorials visit
• uophelp.com is now newtonhelp.com
• www.newtonhelp.com
• DBM 380 Week 2 ASSIGNMENT
• Individual Database Design and ERD Creation
• The following assignment is based on the database
  environment proposed in the Week One Individual
  Assignment.

10
ENG 121 Experience Tradition/newtonhelp.com

• For more course tutorials visit
• uophelp.com is now newtonhelp.com
• www.newtonhelp.com
• Write a 750- to 1,050-word paper in which you
  complete the following
• Choose a database environment from the
  following
• o An appropriate database environment within
  your workplace (must be approved by your
  instructor)
• o An Art Museum that needs to track the
  artwork, artists, and locations where the art is
  displayed or stored within the museum

11
ENG 121 Experience Tradition/newtonhelp.com

• For more course tutorials visit
• uophelp.com is now newtonhelp.com
• www.newtonhelp.com
•  
•  
• DBM 380 Week 2 Learning Team Sparkle Diamonds
  Project
• Start working on your Learning Team Database and
  Presentation outlined above with delivery in Week
  Four. Begin by analyzing the requirements
  provided. Identify the tables, fields, field
  attributes, and table relationships required.

12
ENG 121 Experience Tradition/newtonhelp.com

• For more course tutorials visit
• uophelp.com is now newtonhelp.com
• www.newtonhelp.com
• Begin working on Service Request SR-ht-003, due
  in Week Five, by completing Change Request 2.
• Create documentation for this project that
  summarizes the process for using the entities and
  attributes for fleet truck maintenance. The
  Entities and Attributes for Fleet Truck
  Maintenance can be found in the Huffman

13
ENG 121 Experience Tradition/newtonhelp.com

• For more course tutorials visit
• uophelp.com is now newtonhelp.com
• www.newtonhelp.com
• A motor vehicle maintenance center wants to
  improve its services by using database management
  systems (DBMS) and data mining. What tables are
  needed in such a database and how can it help
  improve their services?

14
ENG 121 Experience Tradition/newtonhelp.com

• For more course tutorials visit
• uophelp.com is now newtonhelp.com
• www.newtonhelp.com
• How do you select the primary key from the
  candidate keys? How do foreign keys relate to
  candidate keys? Provide examples from either your
  workplace or class assignments.

15
ENG 121 Experience Tradition/newtonhelp.com

• For more course tutorials visit
• uophelp.com is now newtonhelp.com
• www.newtonhelp.com
• DBM 380 Week 3 ASSIGNMENT
• Individual Database Normalization
• The following assignment is based on the database
  environment designed in the Week Two Individual
  Assignment.
• Your database project must meet the following
  assessment requirements

16
ENG 121 Experience Tradition/newtonhelp.com

• For more course tutorials visit
• uophelp.com is now newtonhelp.com
• www.newtonhelp.com
• The following assignment is based on the database
  environment chosen and discussed in the Week Two
  Individual Assignment.
• Use a Microsoft Visio diagram to create a
  detailed ERD using the data specificationsnoted
  in the Week Two Individual Assignment. Make any
  necessary changes provided in your facultys
  feedback

17
ENG 121 Experience Tradition/newtonhelp.com

• For more course tutorials visit
• uophelp.com is now newtonhelp.com
• www.newtonhelp.com
•  
•  
• DBM 380 Week 3 Learning Team Tables and Status
  Update
• Normalize your tables designed in Week Two.
• Using the MySQL Workbench, or through a script,
  construct the tables in MySQL from the logical
  database design from your normalized ERD.

18
ENG 121 Experience Tradition/newtonhelp.com

• For more course tutorials visit
• uophelp.com is now newtonhelp.com
• www.newtonhelp.com
• Continue working on Service Request SR-ht-003,
  due in Week Five, by completing Change Request 3.
• Create documentation that explains the process of
  creating the entity-relationship diagrams in the
  change request relative to this project

19
ENG 121 Experience Tradition/newtonhelp.com

• For more course tutorials visit
• uophelp.com is now newtonhelp.com
• www.newtonhelp.com
• In your own words, describe the nature and
  purpose of the normalization process. Provide
  some examples from sources other than the
  readings.

20
ENG 121 Experience Tradition/newtonhelp.com

• For more course tutorials visit
• uophelp.com is now newtonhelp.com
• www.newtonhelp.com
• In what business database environments is
  denormalization appropriate and why? What would
  denormalization specifically involve?

21
ENG 121 Experience Tradition/newtonhelp.com

• For more course tutorials visit
• uophelp.com is now newtonhelp.com
• www.newtonhelp.com
• DBM 380 Week 4 ASSIGNMENT
• Individual Database Creation
• The following assignment is based on the database
  environment designed in the Week Three Individual
  Assignment.
• Your database project must meet the following
  assessment requirements

22
ENG 121 Experience Tradition/newtonhelp.com

• For more course tutorials visit
• uophelp.com is now newtonhelp.com
• www.newtonhelp.com
• The following assignment is based on the database
  environment chosen and created in the Week Three
  Individual Assignment.
• Your database project must meet the following
  assessment requirements
• Design and develop a database using professional
  principles and standards.

23
ENG 121 Experience Tradition/newtonhelp.com

• For more course tutorials visit
• Uophelp is now newtonhelp.com
• www.newtonhelp.com
•  
• DBM 380 Week 4 Learning Team MySQL
• Complete work on your Learning Team Database.
• Execute the following queries in the Diamond
  Broker database
• ? Create an 1-page inventory list showing all the
  attributes for each diamond in inventory (both in
  stock and not in stock)

24
ENG 121 Experience Tradition/newtonhelp.com

• For more course tutorials visit
• uophelp.com is now newtonhelp.com
• www.newtonhelp.com
• Continue working on Service Request SR-ht-003,
  due in Week Five, by completing Change Requests 4
  and 5.
• Create documentation describing the principles
  and importance of normalization in relation to
  this project and the process by which this
  project was normalized.
• Format your paper consistent with APA guidelines.

25
ENG 121 Experience Tradition/newtonhelp.com

• For more course tutorials visit
• uophelp.com is now newtonhelp.com
• www.newtonhelp.com
• Describe the advantages and disadvantages of
  DBMS-provided security. Compare it to network or
  application security.

26
ENG 121 Experience Tradition/newtonhelp.com

• For more course tutorials visit
• uophelp.com is now newtonhelp.com
• www.newtonhelp.com
• Locate a hosted, distributed database service.
  Explore its features and talk about your
  experiences. In what situations would an
  organization consider using it?

27
ENG 121 Experience Tradition/newtonhelp.com

• For more course tutorials visit
• uophelp.com is now newtonhelp.com
• www.newtonhelp.com
• DBM 380 Week 5 ASSIGNMENT
• Individual SQL Queries
• The following assignment is based on the database
  environment created in the Week Four Individual
  Assignment.
• Design and develop the below queries using
  professional principles and standards

28
ENG 121 Experience Tradition/newtonhelp.com

• For more course tutorials visit
• uophelp.com is now newtonhelp.com
• www.newtonhelp.com
•  
•  
• DBM 380 Week 5 Learning Team Big Data
• The amount of data that large organizations must
  manage is vast. The concepts of managing big
  data are much different than traditional
  application databases (those similar to the
  diamond broker application, for example).
• Prepare a 5- to 6-slide Microsoft PowerPoint
  presentation with detailed speaker notes that
  answers the following
• ? How do organizations like Amazon, Facebook, or
  Google manage their big data systems?

29
ENG 121 Experience Tradition/newtonhelp.com

• For more course tutorials visit
• uophelp.com is now newtonhelp.com
• www.newtonhelp.com
• Finalize the project work for SR-ht-003 and
  Change Requests 25.
• Compile all documentation from your Change
  request from Weeks Two through Five.
• Submit your teams project work and documentation
  to your facilitator.

30
ENG 121 Experience Tradition/newtonhelp.com

• For more course tutorials visit
• uophelp.com is now newtonhelp.com
• www.newtonhelp.com
• Create a 3- to 5-slide Microsoft PowerPoint
  presentation in which you explain how the
  principles of database management and your
  recommendations were applied to the project.
• Submit your team presentation to your
  facilitator.
•  

31
ENG 121 Experience Tradition/newtonhelp.com