Case Study: Database Development

ORDER THIS PAPER NOW

Read the following articles available in the ACM Digital Library:
 
Note: The ACM Digital Library is a Library database. 
 
  • Dual Assessment of Data Quality in Customer Databases, Journal of Data and Information Quality (JDIQ), Volume 1 Issue 3, December 2009, Adir Even, G. Shankaranarayanan.
  •  
  • Process-centered review of object oriented software development methodologies, ACM Computing Surveys (CSUR), Volume 40 Issue 1, February 2008, Raman Ramsin, and Richard F. Paige.
 
Write a 700 Words paper in which you:
 
1. Recommend at least three (3) specific tasks that could be performed to improve the quality of datasets, using the Software Development Life Cycle (SDLC) methodology. Include a thorough description of each activity per each phase.
 
2. Recommend the actions that should be performed in order to optimize record selections and to improve database performance from a quantitative data quality assessment.
 
3. Suggest three (3) maintenance plans and three (3) activities that could be performed in order to improve data quality.
 
4. From the software development methodologies described in the article titled, “Process-centered Review of Object Oriented Software Development Methodologies,” complete the following.
 
   a. Evaluate which method would be efficient for planning proactive concurrency control methods and lock granularities. Assess how your selected method can be used to minimize the database security risks that may occur within a multiuser environment. 
   b. .Analyze how the verify method can be used to plan out system effectively and ensure that the number of transactions do not produce record-level locking while the database is in operation.

Tour Operator Agency Database

ORDER THIS PAPER NOW

The Oracle Server may be used to test and compile the SQL Queries developed for this assignment.
A multinational tour operator agency has gained new business growth in the North American market through the use of social media. Its operation has expanded by 50% within six months and the agency requires an enhanced data management strategy to sustain their business operations. Their existing data repository for its reservation processing system is limited in business intelligence and reporting functionalities. The tour operator seeks a database management specialist to assist them in leveraging their data sources to enable them to forecast and project tour sales appropriately.
Imagine that you have been hired to fulfill their need of enhancing the data repository for their current reservation processing system. Upon reviewing the system, you find that the data structure holds redundant data and that this structure lacks normalization. The database has the following characteristics:
  • A table that stores all the salespersons. The table holds their employee id, first name, last name and “Tours sold” field. The “Tours sold” field is updated manually.
  • A table that stores tour customer data and tours sold. The table holds customer name, address, city, state, zip code, tour(s) selected, number of persons in tour, and total amount paid. The current structure will show the customer more than once, if the customer books multiple tours.
  • A tour table that is used as a tour rate sheet which holds the tours offered and the cost per person. Tour rates vary every three (3) months depending on the tourist season.

Technical Paper: Database Administrator for Department Store

ORDER THIS PAPER NOW

The Oracle Server may be used to test and compile the SQL Queries developed for this assignment.
Imagine that you have been hired as the database administrator for a local department store. The department store has recently expanded by opening five (5) stores within your local region. They have also launched a series of marketing campaigns to attract new customers and increase sales. For your hired role, you will be responsible for creating and maintaining an enterprise-wide database system that will hold the sales and inventory data for the organization. The designed database will help operations in supporting its new business marketing strategy. Using the concepts presented throughout the course, you will develop a plan to create this database and establish a design that aligns with the product sales initiatives of the organization.

Continue reading

Network Consultation Proposal (Microsoft Word)

ORDER THIS PAPER NOW

Create a cost analysis, and develop a proposal for the company.

1. Write an 1500 words proposal in which you:

a. Recommend one (1) suitable network design.

b. Suggest one (1) network architecture.

c. Suggest LAN and Wireless LAN (WLAN) wiring considerations.

d. Recommend hardware options and costs.

e. Suggest security considerations for:

i. Firewall

ii. Antivirus software

f. Recommend software options and costs.

g. Outline the labor costs, equipment costs, and service costs for your suggested design in table format.

h. Identify the single point of failure, and recommend potential mitigation strategies.

i. Use at least three (3) quality resources in this assignment. Note: Wikipedia and similar Websites do not qualify as quality resources.

Section 1 of 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.

ORDER THIS PAPER NOW

ORDER THIS PAPER NOW

This assignment contains two (2) Sections: Network Consultation Proposal and Network

Consultation Presentation. You must submit both sections as separate files in order to complete this assignment.

The owners of DesignIT, who recently purchased 56’x36′ space for their expanding business, have asked you to place a bid on a consulting job. DesignIT is a graphic arts company that, up until now, had contracted work out to temporary design services. The new space will allow them to hire two (2) full time designers and a receptionist.

Description of space purchased:

  • 4 Cubicles
  • 1 Office
  • 1 Server room
  • 1 Reception desk
  • 1 Conference room

Using the building layout, your role is to provide DesignIT with a network design that interconnects the following considerations:

DesignIT plans to relocate three (3) servers already configured as follows:

  • 1 Web Server – Microsoft IIS Server
  • 1 File Server – Microsoft Server 2008
  • 1 Server – Server 2008 Small Business Server

DesignIT has requested that the design include the following:

  • High speed Internet access
  • Firewall
  • Antivirus / malware protection
  • Six (6) computers
  • Three (3) color laser printers
  • Wireless access for portable devices

DesignIT has requested the consideration of all interconnected devices and wiring, along with speeds, for best performance.

ORDER THIS PAPER NOW