- 6HW153: Analysis requires you to investigate the management of a patient with an undifferentiated minor illness that you have experienced in practice: Minor Il lness Theory into Practice for Emergency Practitioners Case Study, UOW, UK
- This case study documents a collaboration between the Global Fund for Community Foundations and the Coady International Institute: Public Health Case Study, QUB, UK
- Evaluate the sociological explanations related to your life chances and Explain the relationship between your health: Health and social care Case Study, UOG, UK
- 7HR02: Resourcing and talent management to sustain success Case Study, WLC, UK
- HHH3010: You have been asked by an associate mentor to assist in mentoring a student and The student is struggling to achieve: Practice Education for Paramedics Case Study, UOH, UK
- CGRM4000: You are required to write a report to a corporate board summarising your views on corporate governance sustainability: Corporate Governance Sustainability and Ethics Case Study, KBS, UK
- Singapore’s political system is a parliamentary democracy It has a very similar setup to that of the United Kingdom: Political Systems Case Study, UoWL, UK
- List your variables for the system put them into linked pairs and Please provide the list of variables and pairs: Business Studies Case Study, UOWL, UK
- Explain that normal budgeted expenditure covers 12 months of day-to-day expenditure, not long-term capital investment: MBA with a Specialism in Finance Case Study, HWU, UK
- Wildland Park is a visitor attraction in Dorset, England, on the grounds of Casterbridge Hall, a stately home near Axminster: International Marketing Case Study, LSBU, UK
- 5CO02: Your company has been invited to submit a briefing paper for a regional People Practice event that will share insights: Evidence-Based Practice Case Study, BU, UK
- CT7155: Plan, design, and implement the International Travel Agency switched network as shown in the diagram and described below: Switched Networks Case Study, LMU, UK
- Explain why you consider each example as a market anomaly/market bubble: Financial Behaviour Case Study, UOL, UK
- Advise how you would have planned the project given your choice of life cycle and methodology: Project Management Techniques Case Study, UON, UK
- 7ENT1127: Evaluate quantitative modeling concepts for problem-solving and decision-making in a logistics context: Operations Research and Logistics Case Study, UOH, UK
- Define the ones moods and concepts relating to the study of human behavior in the workplace: Managing People case Study, UOS, UK
- ADN402: Describe and analyze the long-term support needs of people living with long-term conditions: Long Term Conditions And Multi-Morbidity Case study, SU, UK
- Describe and explain the historical ideological and regional context that led to the establishment of that system: Political Systems Case study, UOS, UK
- You work in the HR Team of a medium-sized organization and are studying for your people practice qualification: Chartered Institute of Personnel and Development Case study, MUL, UK
- 5HR03: Home International is a furniture manufacturer and online retailer The organisation is a family-owned business that was started over 30 years ago: Reward for performance and contribution Case Study, UK
You are hired as a DBA for a medium size online retailer company Quick Sale The company sells several products: Advanced Database Technologies Case Study ,UOS, UK
|University||University of Southampton (UOS)|
|Subject||Advanced Database Technologies|
The implementation tasks are based the following case study and requirements
You are hired as a DBA for a medium size online retailer company “Quick Sale”. The company sells several products, such as computer hardware and software, music, clothing, and tools. The company maintains information about these products, such as product identification numbers, the category into which the product falls, orders information, the supplier, the availability status of the product, a list price, etc. Inventory information is also recorded for all products, including the warehouse where the product is available and the quantity on hand. Customer information is also tracked.
The database design is complete (see ERD below) and you will be provided with the script to upload all necessary data in your VM database. The owners of the tables are user shand user oe.
The “Quick Sale” company has number of employees working in several departments: Sales, Marketing, Inventory, Customer Service, HR, etc. They need to have different access rights to the tables in the database, based on their job description.
Your task is to implement DBA requirements specified below using your Virtual Machine provided for the module and describe your solutions for potential DBA problems as specified in the Problem-solving requirements.
- You are required to create 2 table spaces to store data needed for two different applications with different requirements:
- First table space invites, will be required to store extra inventory information. This will be for a transactional type of application where every day a large amount of data (around 10Mb) will be entered into tables stored in invites That data also will be updatable on a regular basis.
- Second table space dw_tsp will be used for a data warehousing application with a large data (120Mb) loaded at the beginning and rarely updated.
You are required to create both table spaces in your database, deciding on the best properties to be used for each tables peace. You must provide SQL command for each table space creation, a screenshot of successful execution of that SQL command and explanation on why you made those choices of table spaces properties and their values for both table spaces. What are the benefits, and drawbacks of your choices.
- You are required to create several new users with the following login requirements:
- Two users for the Customer Service department and one user for the Inventory department. Default table space for all users should be invites and temporary table space should be set to temp.
- All of the above users should have unique usernames and passwords. Password should be at least 8 characters long and users should not be allowed to have a password that is shorter than 8 characters. There shouldn’t be any other enforcement on the password.
- The users should be forced to change their passwords on their first login, then every 6 months and not allowed to reuse the same password.
- If during the login they specified their password incorrectly 3 times, the account should be locked for 30 hours.
- All new users should be allowed to leave their session without interacting Make sure you include an explanation on how these requirements are implemented, possible alternatives, their benefits and drawbacks. Please provide in your report the usernames and passwords for all users created.
- New users should have the following access rights:
- All of the above users should be able to login to the database.
- Two users for the Customer Service department should have Read/Only access to PRODUCT_INFORMATION, PRODUCT_DESCRIPTIONS, ORDERS, ORDER_ITEMS and CUSTOMERS tables, owned by user oe.
- Customer Service users should be able to easily query information about all orders for a particular customer based on the customer id. (Remember, Customer service users might not be experienced SQL developers, so they will not be able to create a complex SQL statement with joins, etc. You need to simplify this task for them).
- The user for the Inventory department should have Read/Write access to the tables: INVENTORIES and WAREHOUSES as well as Read/Only access to ORDERS, ORDER_ITEMS and CUSTOMERS tables, owned by user oe.
- The user for the Inventory department should also be allowed to create new tables and new views.
Make sure you include an explanation on how these requirements are implemented.
Problem solving requirements:
- If you accidently dropped an important schema (for example, hr)in your database, discuss the best functionality to use in order to recover it quickly and safely. Provide an explanation of the steps needed to recover data including the SQL commands for each step.
- Your users are reporting “ORA-1555: Snapshot too old” errors. What might be the cause of this? Explain what you need to do in order to solve this issue.
- Explain the difference between a hot backup and a cold backup and the benefits associated with each.
- Discuss how different database failures can impact a business, including the financial costs, and what can be done to minimize the downtime cost. To illustrate your point, find a real-life example, based on your research, of the financial costs suffered by a company due to an Oracle systems failure; what lessons were learnt and what actions were taken to prevent future problems.
- Your VM number
- Description of your implementation for each requirement: SQL commands and explanation with the rationale justifying the design decisions you have made; evaluating alternatives, potential problems, and limitations
- A brief (less than half a page) description of any special strength of your implementation or additional features that you added to the system, that you think should be taken into account in awarding a mark.
- A concise list of any bugs and/or weaknesses of your system.
- An evaluation of your system and of your learning experience. Write around 600-800 words evaluating the components that you have produced and the way you went about completing the coursework.
Try to be specific and state exactly what you learned by your own effort and from other students. Make clear what you would do differently if you were to do the coursework again. Some points that you could cover include: how you managed your time, how you found out necessary information to complete the assignment, how well designed you think your solution is, what changes would need to be made to your system before it could become a product that could be used by real users.
- A very good implementation, showing a system with all requirements (1 – 9) implemented; all components are working and provide a good result.
- A very good reportdemonstrating a good understanding of database administration and good ability to implement business requirements.
- An excellentimplementation, showing all requirements (1-9) are implemented to a higher standard. The components should be working properly and provide an excellent result.
- An excellent reportdemonstrating a thorough understanding of the database administration and showing very good ability to implement and discuss in details complex requirements.
Are You Looking for Answer of This Assignment or Essay
Academic writers of StudentsAssignmentHelp.com offer the top-rated case study help UK on Advanced Database Technologies. our case study experts have Ph.D. and master’s degrees in their subject field. Also, they always design trustworthy case study solutions on all subjects.