This course aims to provide students with the basics of system analysis and design of information systems in business organizations.

After completing this course, the student will be able to:

1. Identify system requirements.
2. Translate the requirements into an information system model.
3. Use analysis tools and design information systems.
4. Apply the business data management concepts, both theoretical and practical, using ERD Modeling.
5. Create effective and optimized methods for building databases in business.
6. Use the corresponding software systems and computer resources to build databases.

1. Systems development environment and life cycle (Waterfall and Spiral)
2. Activation of each SDLC (Phase) planning analysis phase and requirements.
3. Developing and building information systems using CASE tools
4. The mechanism of data flow diagrams
5. Building the baseline project structuring system and process requirements
6. Data flow diagramming mechanics and examples (Decision tables • Data dictionary UMl introduction)
7. Traditional processing systems
8. The database environment
9. Database management system (DBMS)
10. Data duplication and data program dependence
11. Entity relationship diagram
12. Transforming EER to relations
13. Normalization
14. Defining a database in SQL environment
15. Processing and requests on single tables
16. Natural, outer and union joins.

Hoffer, J. A., George, J. F. and Valacich, J. S. (2016). Modern Systems Analysis and Design. 8^th Edition, Global Edition. USA.

• Hoffer, J. A., Venkataraman, R., and Topi, H. 2015. Modern Database Management, London: Pearson Education.
• Pratt, P. J. and Adamsky, J. J. (2014). Concepts of Database Management. 7^th Edition. Boston, Massachusetts, Cengage Learning publisher.