Overview
Lecturer
Manuella Kadar
Seminar tutor
Maria Loredana Oroian Boca
Type of course
Compulsory
Language of instruction
Romanian
Erasmus language
English
Domain
Accounting
Field of study
Accounting and Management Information Systems
Form of education
Full-time
Form of instruction
Class
Credit awarded by
Grade
Teaching methods
Lecture, conversation, exemplification.
Entry requirements
-
Aims
• Knowledge and principles, concepts elementary processing of data or form, structure and content.
• Knowledge of advanced concepts about the media and systems used to manage data and familiarity with the specific modalities of representation, transfer and access to information
-Collection, storage and processing information using specialized software;
-Security compliance, ergonomics and work ethic based on information and communication technology
-The use of computer tools in an interdisciplinary context
Course contents
1. Concept database. The fundamental objectives of a database (BD). Bases Management System (DBMS)
2. The relational model. Relational Algebra. relational scheme
3. The physical model of the data. Methods of accessing data
4. Normalization of relations. The advantages of the relational model
5. Design Methods BD. Design relational model through normalization
6. Matrix functional dependencies. Establishment dictionary of attributes and determine the functional dependence.
7. Implementing the relational model.
8. The main features of the DBMS sites (examples ACCESS, Oracle, Visual Fox Pro). Creating tables. Defining the primary key and indexes
9. Define relationships between tables. Restrictions referential integrity. BD query. Types of queries
10. calculated fields in queries selection. Parameterization queries. Synthesizing data queries. Cross-analysis queries. Queries type action.
11. The language SQL (Structured Query Language) General characteristics. Data Definition Language SQL - LDD
12. Instructions for updating the database. Management view sites. Achieving using SQL relational operators
13. variables. Operators and functions. Implementation of fundamental control structures in VBA. procedures
14. Operation BD. Developing models for the Internet.
Learning outcomes
- Acquiring knowledge on the management of databases, data representation models , query and update databases ;
- The acquisition of practical skills for developing computer applications with databases in financial accounting and management.
Assessment
Written exam – 50%; verification during semester – 50%.
Recommended reading
• http://www.easybib.com/reference/guide/mla/database
Site Internet
Prentice Hall, Internet, 2018 · 8
Database Systems: A Practical Approach to Design, Implementation, and Management (6th Edition)
Thomas Connelly şi Carolyn Begg
Pearson, Paisley., 2014 · 1440
Dezvoltarea aplicatiilor cu Visual Studio . NET
Richard Grimes
TEORA, Bucuresti, 2002 · 652
Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design
Michael J. Hernandez
Addison-Wesley Professional, New York, 2013 · 672
Hands-On Database
Steve Conger
Pearson, New York, 2013 · 224