Database Management and Design IST 215

Concepts, procedures, design, implementation and management issues of database systems, following database development life cycle. Stresses importance of needs analysis, requirements statement, and testing final product against initial requirements definition. Database management and security issues will be explored. Programming will be based on currently used business application database software, and SQL. Theory will be reinforced with projects to be completed using database software on the Manor Student Network.Prerequisites: IST 105 and IST 205.

Correlated Learning Outcomes

  • IT. 1. Carry out trouble-shooting strategies for resolving an identified end-user IT problem.
  • IT. 8. Summarize strategies to support or train users with their IT resources.
  • IT. 10. Describe the data management activities associated with the data lifecycle.
  • IT. 11. Diagram a database design based on an identified scenario.
  • IT. 12. Differentiate between public and private data.
  • IT. 13. Discuss applications of data analytics.
  • IT. 14. Discuss issues relevant to dealing with very large data sets, both structured and unstructured.
  • IT. 15. Identify database administration tasks.
  • IT. 16. Produce simple database queries.
  • IT. 17. Use data analytics to support decision making for a given scenario.
  • IT. 19. Differentiate among data types, data transfer protocols and file characteristics specific to the targeted use.
  • IT. 34. Use a programming or a scripting language to solve a problem.
  • IT. 35. Differentiate among strategies for business continuity provisioning of IT resources at the enterprise level.
  • IT. 36. Discuss data governance and its implications for users as well as IT professionals.
  • IT. 37. Identify a variety of enterprise-level digital storage technologies.
  • IT. 39. Modify a system to improve data confidentiality or regulatory compliance.
  • IT. 41. Summarize the security implications and risks for distributed IT systems.
  • IT. 43. Describe the attitudes, knowledge and abilities associated with quality customer service.
  • IT. 44. Produce technical documentation responsive to an identified computing scenario
  • IT. 45. Use documentation or a knowledge base to resolve a technical challenge in an identified computing scenario.
  • IT. 46. Discuss significant trends and emerging technologies and their impact on global society.
  • IT. 47. Demonstrate professional behavior in response to an ethically-challenging scenario in computing.
  • IT. 48. Summarize the tenets of ethics and professional behavior promoted by international computing societies.
  • IT. 50. Summarize the role of IT in supporting the mission and goals of an organization.