Dokument se učitava


School of Electrical and Computer Engineering of Applied Studies


Information Systems Design Course 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:
  1. Introduction of the Course topics
  2. Life-cycles in development of Information Systems
  3. Functional design – functional decomposition
  4. Functional design – collecting the user requirements
  5. Information design – creating the Entity - Relationship diagrams
  6. Information design – creating attributes and business rules
  7. Information design – creating relationships and referential integrity
  8. Application design – conceptual database design
  9. Application design – creating the scheme of database
  10. Application design – creating of queries
  11. Application design – creating the front end application
  12. Implementation – testing
  13. Implementation - running the IS in production environment
  14. Implementation - Maintenance
Practical instruction (Problem solving sessions/Lab work/Practical training):
  1. 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
  1. Alempije Veljovic, „Development of Information Systems and Database“, CIT, Beograd 2004.
  2. James Cadle, “Developing information systems – practical guidance for IT professionals”, 2014 BCS Learning & Development Ltd
  3. Shari Lawrence Pfleeger, Joanne M. Atlee, “Software Engineering, Theory and Practice”, 4th edition, Pearson Higher Education. Upper Saddle River, New Jersey, 2010
  4. ThomasConnolly, CarolynBegg, “Database Systems, A Practical Approach to Design,Implementation, and Management”, 4th edition, Addison Wesley, 2005
Number of active classes (weekly)
Lectures: 4
Practical classes: 3
Other types of classes: 0
Grading (maximum number of points: 100)
Pre-exam obligations
activities during lectures
activities on practial excersises
seminary work
Final exam
Written exam
Oral exam