Course 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 Entry Requirements:

-

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.

Teaching methods:

Lecture, conversation, exemplification.

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.

Learning outcomes verification and assessment criteria:

Written exam – 50%; verification during semester – 50%.

Recommended reading:

Site Internet, • http://www.easybib.com/reference/guide/mla/database, Prentice Hall, Internet, 2018, 8.
Thomas Connelly şi Carolyn Begg, Database Systems: A Practical Approach to Design, Implementation, and Management (6th Edition), Pearson, Paisley., 2014, 1440.
Richard Grimes, Dezvoltarea aplicatiilor cu Visual Studio . NET, TEORA, Bucuresti, 2002, 652.
Michael J. Hernandez, Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design, Addison-Wesley Professional, New York, 2013, 672.
Steve Conger, Hands-On Database, Pearson, New York, 2013, 224.