Home  »  Vocational School of Social Sciences »  Program of Bureau Management and Executive Assistance

COURSE UNIT TITLECOURSE UNIT CODESEMESTERTHEORY + PRACTICE (Hour)ECTS
DATABASE MANAGEMENT BYYA257 - 3 + 0 5

TYPE OF COURSE UNITElective Course
LEVEL OF COURSE UNITAssociate Degree
YEAR OF STUDY-
SEMESTER-
NUMBER OF ECTS CREDITS ALLOCATED5
NAME OF LECTURER(S)-
LEARNING OUTCOMES OF THE COURSE UNIT At the end of this course, the students;
1) To develop database MS Access database management application database,
2) To explain basic concepts of database,
3) To develop tables using MS Access, perform relations with developed tables,
4) To perform queries using MS Access,
5) To explain data types, creates database, table using SQL commands,
6) To perform basic queries with records using SQL commands,
7) To perform form pages to enter data to the tables, to update tables and to delete tables.
MODE OF DELIVERYFace to face
PRE-REQUISITES OF THE COURSENo
RECOMMENDED OPTIONAL PROGRAMME COMPONENTNone
COURSE DEFINITIONUnderstanding development of database and its basic concepts, database design using database management systems (DBMS) visual interface and create database using SQL, having data processing and query ability.
COURSE CONTENTS
WEEKTOPICS
1st Week General information about the course and the evaluation methods
2nd Week Purpose of accounting, Generally Accepted Accounting Principles. Financial Statements; Balance Sheet. Effects of business transactions upon the Balance Sheet.
3rd Week Concept of Account. Assets, Liabilities and Owner's Equity.
4th Week Preparing Balance Sheet, Journal, Debit and Credit Entries, Double-Entry Accounting,Recording transactions to Jornal, The use of Ledger Accounts,
5th Week Adjusting entries, Preparing monthly and adjusted Trial Balance,
6th Week End of year balance sheet and income statement. Closing and re-opening the accounts
7th Week Tangible assets, cash and bank transactions.
8th Week Midterm exam
9th Week Checking accounts, recording the outstanding checks
10th Week Accounts Recaivable, Notes Receivable.
11th Week Inventories, and Cost of Goods Sold, Periodic and Perpetual Inventory Methods. Value Added Tax (KDV) Account
12th Week Intangible accounts, Plant and Equipment
13th Week Depreciation and Amortization.
14th Week Accounts payable and notes payable
RECOMENDED OR REQUIRED READING- Özseven, T. Veritabanı Yönetim Sistemleri I
PLANNED LEARNING ACTIVITIES AND TEACHING METHODSLecture,Practice
ASSESSMENT METHODS AND CRITERIA
 QuantityPercentage(%)
Mid-term130
Practice120
Other110
Total(%)60
Contribution of In-term Studies to Overall Grade(%)60
Contribution of Final Examination to Overall Grade(%)40
Total(%)100
ECTS WORKLOAD
Activities Number Hours Workload
Midterm exam111
Preparation for Quiz
Individual or group work14228
Preparation for Final exam13030
Course hours
Preparation for Midterm exam12020
Laboratory (including preparation)14342
Final exam111
Homework7535
Total Workload157
Total Workload / 305,23
ECTS Credits of the Course5
LANGUAGE OF INSTRUCTIONTurkish
WORK PLACEMENT(S)No
  

KEY LEARNING OUTCOMES (KLO) / MATRIX OF LEARNING OUTCOMES (LO)
LO1LO2LO3LO4LO5LO6LO7
K1             
K2             
K3             
K4  X   X   X   X   X   X   X
K5             
K6             
K7             
K8             
K9  X   X   X   X   X   X   X
K10             
K11