Babeș-Bolyai University



DETAILED SYLLABUS

Databases in Economy

1. Information about the program

|1.1 University |„Babeş-Bolyai” University Cluj-Napoca |

|1.2 Faculty |Faculty of Economics and Business Administration |

|1.3 Department |Business Information Systems |

|1.4 Field of study |Finance |

|1.5 Program level (bachelor or master) |Bachelor |

|1.6 Study program / Qualification |Finance and Banking |

2. Information about the subject

|2.1 Subject title |Databases in Economy | | | |

|Discipline code |ELE0086 | | | |

|2.2 Course activities professor |Assoc. Prof. | | | |

| |Dan Andrei SITAR TĂUT, PhD. | | | |

|2.3 Seminar activities professor |Assoc. Prof. | | | |

| |Dan Andrei SITAR TĂUT, PhD. | | | |

|2.4 Year of study |III |

|Study based on textbook, course support, references and notes |14 |

|Additional documentation in the library, through specialized databases and field activities |22 |

|Preparing seminars/laboratories, essays, portfolios and reports |14 |

|Tutoring |2 |

|Assessment (examinations) |6 |

|Others activities ................................... |0 |

|3.7 Total hours for individual study |58 | |

|3.8 Total hours per semester |100 | |

|3.9 Number of credits |4 | |

4. Preconditions (if necessary)

|4.1 Curriculum |Databases and Programming (ELE0016) |

|4.2 Skills |Skills derived from 4.1 |

5. Conditions (if necessary)

|5.1. For course development |• The course is scheduled every week, the laboratory is scheduled every second week and the attendance of |

| |students to these is not mandatory but recommended. |

| |• Students will be evaluated continuously, they will have 1-2 quizzes (5% from the theory’s grade) during |

| |lectures |

| |• For lectures following are needed: notebook / desktop computer, projector, screen |

| |• Students will be presented in lectures, seminars/laboratories with / mobile or other electronic devices |

| |switched off. |

| |• No student will be accepted late course and seminar / laboratory. |

|5.2. For seminar / laboratory |• Required installed software: updated browser, Flash player, and JRE in compatibile versions |

|development |• The term of teaching seminar is determined by the laboratory holder in agreement with the students. |

| |• No acceptation applications for deferral will be only on objective reasons. |

| |• For late delivery of work workshop / laboratory, students will be 2 points/week downgraded. |

6. Acquired specific competences

|Professional |Conception, design and use of databases in Finance and Banking |

|competences |Develop the use of software components using databases, especially relational ones; |

| |Making applications mainly related to banking and finance fields by using databases, properly designed and implemented. |

|Transversal |Applying principles of professional ethics norms and values ​​within their strategies for rigorous, efficient and |

|competences |accountable; |

| |Identify training opportunities and efficient use of resources and learning techniques for their development; |

| |Applying principles of multidisciplinarity and interdisciplinarity in economics by combining the disciplines related |

| |with the databases of finance and banking. |

7. Subject objectives (arising from the acquired specific competences)

|7.1 Subject’s general objective |• Familiarize students with the elements relating to conception, design and use of database |

| |by managers in the banking field. |

|7.2 Specific objectives |Familiarity with basic theoretical concepts on database; |

| |Familiarity with levels of conceptual, logical and physical database; |

| |Study of factors related to database design; |

| |Familiarity with security issues database; |

| |Develop skills to design and use transactional systems. |

8. Contents

|8.1 Course |Teaching methods |Observations |

|Fundamental concepts related to databases, taxonomies of databases and their evolution |Lecture, interactive | 1 course |

| |teaching and | |

| |continuous feedback | |

|Architecture of a database, DBMS - a tool for implementing computer information systems, |Lecture, interactive | 1 course |

|conceptual scheme - entity-relationship model, the global model standard ANSI / SPARC |teaching and | |

| |continuous feedback | |

|Systems architecture relational database architectures machines |Lecture, interactive | 1 course, case |

| |teaching and |studies |

| |continuous feedback | |

|Database design, general considerations, conceptual data representation scheme, properties of |Lecture, interactive | 2 courses |

|relations, developing conceptual models, translating conceptual scheme flowchart global |teaching and | |

|relational model |continuous feedback | |

|Relational database normalization, general considerations and preliminary definitions, the first|Lecture, interactive | 2 courses, case |

|normal form theorem of decomposition, second normal form, the 3rd normal form (3NF) and |teaching and |studies |

|variants (3 ½) NF data retention and dependencies |continuous feedback | |

|Relational algebra, SQL - chronological perspective, data types in SQL, SQL key, create a table,|Lecture, interactive | 1 course, case |

|query BD |teaching and |studies |

| |continuous feedback | |

|The tuple relational calculus, language Quel, the domain relational calculus, the language QBE |Lecture, interactive | 1 course, case |

|QUERY versions of Visual FoxPro and Access. |teaching and |studies |

| |continuous feedback | |

|Concurrent access control, data integrity, database transaction context, the issues of |Lecture, interactive |2 courses, case |

|competition, conflict-free execution characteristics - basic concepts, serializable execution, |teaching and |studies |

|precedence graphs |continuous feedback | |

|Prevent deadlock: the original ordering algorithm (total) - trading stamps (stamps temporal) |Lecture, interactive |2 courses, case |

|ordering algorithm for partial algorithm partial ordering multiple versions, two-phase locking |teaching and |studies |

|algorithm, deadlock problem / blockage of death |continuous feedback | |

|Deadlock detection: graph of waiting and its relationship with the precedence graph, the graph |Lecture, interactive |1 course, case |

|of allocation; resistance feathers |teaching and |studies |

| |continuous feedback | |

|Bibliography: |

|Connolly, T., Begg, C., Strachan, A., Database Systems – A Practical Approach to Design, Implementation and Management, Addison Wesley |

|Longman Limited 2001 |

|Date C.J., An Introduction to Database Systems, vol I şi II, Addison-Wesley, 2004/Teora, 2005 E+ |

|Fotache M. şi alţii, SQL Dialecte DB2, Oracle, Visual FoxPro, Ed. Polirom, Bucureşti, 2001. |

|Lungu I. & DBASEIG Group, Baze de date, Fundamente teoretice şi practice, Infomega, 2002. |

|Niţchi et al., Elemente de baze de date şi programare aplicate în economie, Risoprint Publishing House, Cluj-Napoca, 2009, available in |

|Faculty’s library |

|Oracle Academy iLearnig platform: Oracle Academy Database Design and Programming with SQL 2012-2013 |

|Popescu I., Modelarea bazelor de date, Editura Tehnică, 2002. |

|Sabău G. şi alţii, Baze de date, Matrix, Bucureşti, 2008. |

|Sitar-Tăut D.A., Databases in the Real Life Economy, Risoprint Publishing House, Cluj-Napoca, 2009, available in Faculty’s library |

|Sitar-Tăut, D. Baze de date distribuite, Risoprint, ISBN 973-651-038-0, 2005 |

|8. 2 Seminar/laboratory |Teaching methods |Observations |

|Introduction to database design. ERD diagram. Relations between entities | Practical exercises |1 laboratory |

| |and problems |meeting |

|Supertypes and subtypes. Business rules. Unique identifiers and relational database |Practical exercises |1 laboratory |

|normalization. |and problems |meeting |

|Modeling through arc relationships. Hierarchies and recursive relationships. Modeling historical|Practical exercises |1 laboratory |

|data and changes. |and problems |meeting |

|The ERD drawing conventions and best practices. Transforming the conceptual model into physical |Practical exercises |1 laboratory |

|model |and problems |meeting |

|Introduction to SQL standards. SELECT and WHERE clauses. Functions (Number, character and date |Practical exercises |1 laboratory |

|functions. Aggregate functions) |and problems |meeting |

|JOIN operations. Group functions |Practical exercises |1 laboratory |

| |and problems |meeting |

|Complex queries. Sub-queries. Other SQL commands: DML, DDL, DCL. Constraint management. Views. |Practical exercises |1 laboratory |

|Sequences |and problems |meeting |

|References: | |

|Oracle Academy iLearnig platform: Oracle Academy Database Design and Programming with SQL 2013-2014 | |

9. Corroboration / validation of the subject’s content in relation to the expectations coming from representatives of the epistemic community, of the professional associations and of the representative employers in the program’s field.

|From a theoretical perspective for this course is similar courses taught at all universities in the faculties of Finance and banks in the |

|world and content required for a good job in finance and banking specialist with a background in database |

|Laboratory material is Curriculum Oracle database design and SQL programming, recognized worldwide. Students who complete the reading |

|material, online tests give specific lessons (quizzes) and promotes interim or final exams platform will receive a certificate of |

|completion signed by an instructor certified Oracle Academy. However, this material is the same used in international certifications |

|Oracle universally recognized and provide better labor market integration in areas related databases. |

10. Assessment (examination)

|Type of activity |10.1 Assessment criteria |10.2 Assessment methods |10.3 Weight in the |

| | | |final grade |

|10.4 Course |• Theoretical knowledge about databases and their |Theory exam | 50% |

| |design | | |

| |• Knowledge of theoretical and practical aspects |Written interim examination – 20% | |

| |related to security databases and transactional | | |

| |systems |Written examination during exams session | |

| |• Identify and expand knowledge of databases studied|– 20% | |

| |in year 2 |(The passing grade is 5) | |

| |• Active participation in the course, with additions| | |

| |based on case studies and references |Quizzes – 10% | |

| | |(at least 2 quizzes) | |

| | | | |

| | | | |

| | | | |

| | | | |

| | | | |

|10.5 Seminar/laboratory |Knowledge of theoretical concepts related to |Practical exam |50% |

| |database design and SQL programming |Laboratory project – 25% | |

| |• Ability to perform orthogonal database design. |(The passing grade is 5) | |

| |Conduct and interpretation of ERD diagrams | | |

| |• Create simple and advanced SELECT statements |Oracle Academy online final test – 25% | |

| |• Familiarity with other types of SQL statements |(The passing grade is 5) | |

| |(DML, DDL and DCL) | | |

| |• Use of Oracle database objects such as views, | | |

| |sequences | | |

| | | | |

| | | | |

| | | | |

|10.6 Minimum standard of performance |

|Students must be able to conceive, design and carry out a proper database, provide a database management and transaction system and |

|implement an information system in banking field with databases. |

|In this context, it must be able to identify typical relations existing in real life (1:1, 1: N, M: N) and interpret a diagram ERD. |

|They must be highly specific to database concepts (entity, relationship, ID, relational keys, relational operators) and be able to |

|translate a conceptual model (in which we have relations 1:1, 1: N) in relational tables. |

|Students must have the necessary knowledge to create tables, their individual query and extract data from multiple tables. |

Date of filling Signature of the course professor Signature of the seminar professor 13/01/2015 Assoc. Prof. Assoc. Prof.

Dan Andrei SITAR TĂUT, PhD. Dan Andrei SITAR TĂUT, PhD.

Date of approval by the department Head of department’s signature

Prof. Gheorghe Cosmin Silaghi, PhD. habil.

28/01/2015

-----------------------

[pic]

Facultatea de Științe Economice și Gestiunea Afacerilor

Str. Teodor Mihali nr. 58-60

Cluj-Napoca, 풰풷풸풿퓀퓅퓇퓐퓑퓠퓫퓷픓픸픹픺핔핕핚한핝핡핢핦핧핪햐햑햙햚햦햧햳햴햾햿헊헋헑헒헚헤헮헯헹헺헽헾혉혊혐협혡ퟱ퟉ힿힿힿힿힰힰꆰힰ銰銅銅銅銅銅銅銅銅銅銅銅銅ᔘ୨ᘀ譨堈䌀ᑊ洀ै猀ैᔜ୨ᘀ譨堈　ṊRO-400951

Tel.: 0264-41.86.52-5

Fax: 0264-41.25.70

econ@econ.ubbcluj.ro

econ.ubbcluj.ro

Facultatea de Științe Economice și Gestiunea Afacerilor

Str. Teodor Mihali nr. 58-60

Cluj-Napoca, RO-400951

Tel.: 0264-41.86.52-5

Fax: 0264-41.25.70

econ@econ.ubbcluj.ro

econ.ubbcluj.ro

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download