T.E.I. of WESTERN GREECE

BUSINESS ADMINISTRATION, PATRAS

Module Management Information Systems courses - 5th Semester

No MODULE «MANAGEMENT INFORMATION SYSTEMS» COURSES - 5th SEMESTER COURSE CATEGORY THEORY (h/week) LAB (h/week) WORKLOAD ECDS
501_3 Business Computer Networks SBC 3 2 150,0 6,0
502_3 Information Systems and Software Engineering SC 3 2 150,0 6,0
503_3 Advanced Database Management Systems SC 3 2 150,0 6,0
  TOTAL / WEEK   9 6 450,0 30,0

 

Business Computer Networks

Basic concepts of networks, their development, their role in business. Transmission media. Types of networks, local, wide area, metropolitan. Equipment lines and network devices. Network Operating Systems. Telematics, telematics services in business, file transfer, electronic mail, remote login, new telematics services. Public networks in Greece, key features, services. Internet, historical development, the Web. Connecting P.C.’s, key functions to local networks, management of local networks and users. The web, browsers. E-mail services, ftp, telnet.

 

Information Systems and Software Engineering

Structured analysis and design software: introductory concepts. Flowcharts. Symbols of flowcharts. Features of flowcharts. Types of flowcharts. Data flow diagrams. Components. Edition. Common mistakes. Multilevel analysis. Workflow. Diagrams award procedures. Components. Object-oriented analysis and design. Class and inheritance. Purpose and snapshot. Unified Modelling Language (UML). Types of diagrams. Charts classes. Classes relations. Graphs use cases. Relations. Sequence diagrams, state diagrams. Activity diagrams. Design of interactive applications based on their usage scenarios : methodology ICONIX. Structure of the methodology. Requirement analysis. Initial design. System design. Application.

 

Advanced Database Management Systems

Database Design (normalization). Entities correlation model to relational model. Views, constraints, transactions, stored procedures, Triggers. Role and tasks of Database Manager. Safety and jurisdiction in Databases. Back up and recovery of database. Concurrency in environments with many users. Query optimization. Distributed database. Newsreel topics of database (multimedia databases, databases on the internet, security of databases, knowledge management and bases of data and knowledge, XML, OLAP, Data Warehouse, etc.). Oracle technology (PL/SQL, triggers, stored procedures, etc.). Open source database management systems. Development of applications over standard communication interfaces to databases (ODBC, JDBC), distributed databases, architectures client-server, three-tier architecture, databases and internet.