Information Systems DesignCourse code: 190108 | 8 ECTS credits
Basic information
Level of Studies:Specialized applied studies
Year of Study:1
Semester:1
Requirements:Database
Goal:Students will acquire knowledge of conventional models and approaches for analysis, logical and physical design of Information Systems and Databases
Outcome:Students will be able to perform analysis and design of business processes and Entity - Relationship diagram of Database of Information System by using appropriate tools for Design of Information Systems
Contents of the course
Theoretical instruction:
Introduction of the Course topics
Life-cycles in development of Information Systems
Functional design – functional decomposition
Functional design – collecting the user requirements
Information design – creating the Entity - Relationship diagrams
Information design – creating attributes and business rules
Information design – creating relationships and referential integrity
Application design – conceptual database design
Application design – creating the scheme of database
Application design – creating of queries
Application design – creating the front end application
Implementation – testing
Implementation - running the IS in production environment
Using the CASE tools BPWin and ERWin students will perform lab exercises of functional decomposition, setting the business rules over entities and attributes, logical and physical design of database scheme, and exporting database scheme to a real RDBMS.
Textbooks and References
Alempije Veljovic, „Development of Information Systems and Database“, CIT, Beograd 2004.
James Cadle, “Developing information systems – practical guidance for IT professionals”, 2014 BCS Learning & Development Ltd
Shari Lawrence Pfleeger, Joanne M. Atlee, “Software Engineering, Theory and Practice”, 4th edition, Pearson Higher Education. Upper Saddle River, New Jersey, 2010
ThomasConnolly, CarolynBegg, “Database Systems, A Practical Approach to Design,Implementation, and Management”, 4th edition, Addison Wesley, 2005