Technical Paper: Database Analysis

1602 Words7 Pages
CIS 515 Week 10 Technical Paper: Database Administrator for Department Store Click Link Below To Buy: http://hwcampus.com/shop/cis-515-week-10-technical-paper-database-administrator-for-department-store/ Or Visit www.hwcampus.com The Strayer Oracle Server may be used to test and compile the SQL Queries developed for this assignment. Your instructor will provide you with login credentials to a Strayer University maintained Oracle server. 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…show more content…
o Analyze security considerations and pricing of the different cloud implementation types. o Rank the cloud services options of Software as a Service, Platform as a Service and Infrastructure as a Service in terms of functionality, mobility, and ability to provide distributed transaction concurrency. Compare how these cloud-based services fit within an environment where users are mobile. Determine the technical provisions that would be required to ensure data integrity. • Evaluate whether the use of a distributed DBMS structure is appropriate and identify the optimization techniques that should be factored in to enhance the operations of the database in your design. • Provide at least two (2) examples of how lost updates and uncommitted data may occur, keeping in mind that five (5) stores will be generating transactions. • Determine the concurrency control factors that can be used to ensure valid execution of transactions within the current multiuser environment. • Research the Internet for backup and restoration recovery solutions and database security threats that could be applicable to the department store. Upon your research, complete the…show more content…
Design a data model that will conform to the following criteria: 1. Propose an efficient data structure that may hold the tour operator’s data using a normalization process. Describe each step of the process that will enable you to have a 2nd Normal Form data structure. 2. Create naming conventions for each entity and attributes. 3. Conclude your data model design with an Entity Relationship Model (ERM) that will visually represent the relationships between the tables. You may make use of graphical tools in Microsoft Word or Visio, or an open source alternative such as Dia. Note: The graphically depicted solution is not included in the required page length. 2. Construct a query that can be used on a report for determining how many days the customer’s invoice will require payment if total amount due is within 45 days. Provide a copy of your working code as part of the paper. 3. Using the salesperson table described in the summary above, complete the following: 1. Construct a trigger that will increase the field that holds the total number of tours sold per salesperson by an increment of one

More about Technical Paper: Database Analysis

Open Document