Design an entity relationship diagram

Assignment Help Database Management System

Reference no: EM132512500 , Length: 3 pages

Database Systems and Administration

Task 1: Design an Entity Relationship Diagram (ERD) to model the above scenario. Identify the different entities (Maximum 10 and minimum 5) and attributes for each entity. Suggest and justify the choice of relationship and cardinality of therelationship. State the assumptions (if any) made by you to develop the ERD based on your research. Provide detailed analysis and justification for the selection of entities and attributes based on your research

Task 2:
Assume that you are responsible to set up a sustainable datacenter for the above mentioned scenario of for the company. You are required to hire different types of IT professionals to manage your data center which include IT technician, network administrators, system administrators and database administrator. You are required to research the roles and responsibilities of database administrator for the datacenter. Critically analyze the roles and responsibilities based on your research to hire a database administrator.

Task 3: As a database administrator evaluate different Database Management system Software for the above scenario. You are required to prepare a technical and financial feasibility report. You are required to critically analyse each aspects and suggest the best suitable database management system software for the above scenario with appropriate justifications.

Task 4: As a database administrator identification of specific roles for application users, authentication policy, storage management and database recovery are critical. The efficiency and complexity of database administration depends on the identified strategy and tools. Propose and critically review user management, backup/recovery strategy, storage management/techniques formulated for the system discussed in Task 2-4.

Task 5: You are required to watch the Big Data Video uploaded on moodle and submit a report comprising an executive

Part B

Write a research article in IEEE Format on "research article can cover big data concepts; present trends in database management, technology enhancements regarding databases or any innovative ideas regarding database administration". The research article with 6 pages.

The research article shall cover the following aspects of research:
• Problem specification, importance of research and research questions
• Theoretical framework
• Rigor of literature review
• Methods or empirical analysis techniques
• Key findings and conclusions

Attachment:- Database Systems and Administration.rar

Reference no: EM132512500

Questions Cloud

Design your own methodology to test a developmental theory : Design your own methodology to test a developmental theory. You may test any concept related to developmental psychology using any age group.

Big data analytics : How Big Data analytics can be used with Smart Cities. This is exciting and can provide many benefits to individuals as well as organizations

What is the maximum weight in pounds : If the piston for the lifting platform has an area of 30 in2, what is the maximum weight in pounds that can be lifted by the compressor supplying 40 psi?

What role government policy play in disaster mitigation : How did women of color experience double displacement, as represented in Doubly Displaced? How are the intersections of gender, race

Design an entity relationship diagram : Design an Entity Relationship Diagram (ERD) to model the above scenario. Identify the different entities and attributes for each entity

Discuss the factors affecting the choice of investments : Discuss the factors affecting the choice of investments. What are the various types of investors? Complete the interactive investor profile questionnaire

How much work would it take to compress rod : Assuming that it remains in its elastic region, how much work would it take to compress this rod by 5.0 mm?

Magnitude force could he open the hatch if he pulled : With what magnitude force could he open the hatch if he pulled at a point that is directly opposite to the hinges and 0.90 m away from them?

Discuss the cultural changes in regard to social media : Discuss the cultural changes in regard to social media and the growing online technology that has significantly lowered face to face/ human interactions

User Account

All Pages