Basics of Databases (4cr)
Code: LT00DB37-3001
General information
- Enrollment
- 22.04.2024 - 04.09.2024
- Registration for the implementation has ended.
- Timing
- 02.09.2024 - 13.10.2024
- Implementation has ended.
- Number of ECTS credits allocated
- 4 cr
- Local portion
- 4 cr
- Mode of delivery
- Contact learning
- Unit
- SeAMK Business Management and SME Business Management
- Campus
- SeAMK Seinäjoki, Frami
- Teaching languages
- Finnish
- Degree programmes
- Bachelor of Business Administration, Business Management
- Teachers
- Mikko Kulmala
- Scheduling groups
- Avoin AMK (Ei koske tutkinto-opiskelijaa) (Size: 10 . Open UAS : 10.)
- Small groups
- Open UAS (Doesn't apply to degree student)
- Course
- LT00DB37
Evaluation scale
1-5
Objective
The student knows the basic concepts related to databases, the basics of data management, the relational model, and the data design process in accordance with the steps of data analysis. The student knows the basics of the query language.
Content
- the basics of the relational model
- relational database
- conceptual modeling
- ER diagram
- key commands in the query language
- basics of NoSQL databases.
Materials
Opettajan materiaalit ja verkkolähteet
Teaching methods
Teoriaopetus ja käytännön työpajat
Completion alternatives
Opintojakson voi suorittaa myös täysin itsenäisesti.
Student workload
Luennot 27h, itsenäinen työskentely 81h.
Assessment criteria, satisfactory (1)
The student knows how to design a database structure. The student knows the basics of the query language and is able to perform addition, deletion, update, and search operations on the database.
Assessment criteria, good (3)
The student is able to design and build a database. The student is able to use the survey language effectively.
Assessment criteria, excellent (5)
The student is able to design and build a database according to good practices. The student is able to use the query language effectively and in a versatile way. The student has a broad understanding of the aspects related to databases, for example in connection with information security and optimization.
Qualifications
Information and Communication Technology