Due Week 3 and worth 120 points A prestigious university has recently implemented a consolidation strategy that will require it to centralize their student records. In order to move forward, the local university will need to develop a data model that will retain student records and perform various data extract transform and load (ETL) processes. Imagine that you have been hired as a database consultant to assist in the development of a data design strategy for the student records. You met with various university subject matter experts and have determined the following after performing various business analysis processes: Using these findings, write a three to four (3-4) page paper in which you: Your assignment must follow these formatting requirements: The specific course learning outcomes associated with this assignment are: Due Week 4 and worth 120 points Imagine that you work for a consulting firm that offers information technology and database services. Part of its core services is to optimize and offer streamline solutions for efficiency. In this scenario, your firm has been awarded a contract to implement a new personnel system for a government agency. This government agency has requested an optimized data repository for its system which will enable the management staff to perform essential human resources (HR) duties along with the capability to produce ad hoc reporting features for various departments. They look forward to holding data that will allow them to perform HR core functions such as hiring, promotions, policy enforcement, benefits management, and training. Using this scenario, write a three to four (3-4) page paper in which you: Â The graphically depicted solution is not included in the required page length. Your assignment must follow these formatting requirements: The specific course learning outcomes associated with this assignment are: Due Week 6 and worth 90 points 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. 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: Write a three to four (3-4) page paper in which you propose an enhanced database management strategy. Your proposal should in
clude the following: Your assignment must follow these formatting requirements: The specific course learning outcomes associated with this assignment are: Due Week 7 and worth 120 points 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 work for a finance industry-based organization. Your organization is looking to submit its database design documentation to an evaluation team in order to meet Sarbanes-Oxley (SOX) compliance. You have been assigned to assist in preparing the documentation of the organization’s sales database. You are asked to propose a data dictionary that can be used to document the following: Write a three to four (3-4) page paper in which you: An example is shown in Table 7.3 in chapter 7 of the textbook. Your assignment must follow these formatting requirements: The specific course learning outcomes associated with this assignment are: Case Study Due Week 8 and worth 50 points Read the following articles available in the ACM Digital Library: The ACM Digital Library is a Strayer Library database located in iCampus > Campus & Library > Learning Resource Center > Databases. Go to https://research.strayer.edu to access A-Z Databases > ACM Digital Library or use the direct link to the database: . Write a two to three (2-3) page paper in which you: Your assignment must follow these formatting requirements: The specific course learning outcomes associated with this assignment are: Due Week 10 and worth 200 points 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 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. Write a twelve to fifteen (12-15) page paper in which you: Your assignment must follow these formatting requirements: The specific course learning outcomes associated with this assignment are: Purchase the answer to view it Purchase the answer to view it Purchase the answer to view it Purchase the answer to view it Purchase the answer to view it Purchase the answer to view it Purchase the answer to view it Purchase the answer to view it Purchase the answer to view it Purchase the answer to view it Purchase the answer to view it Purchase the answer to view it