Siirry suoraan sisältöön

Databases (3 op)

Toteutuksen tunnus: AE00CM69-3001

Toteutuksen perustiedot


Ilmoittautumisaika

16.04.2022 - 12.10.2022

Ajoitus

24.10.2022 - 18.12.2022

Laajuus

3 op

Yksikkö

SeAMK Automaatio- ja tietotekniikka

Toimipiste

SeAMK Seinäjoki, Frami

Opetuskielet

  • Englanti

Tutkinto-ohjelma

  • Bachelor of Engineering, Automation Engineering

Opettaja

  • Marko Hietamäki

Opiskelijaryhmät

  • AE21
    Bachelor of Engineering, Automation Engineering

Tavoitteet

The student understands the concept of database and database management system. Student knows how database is designed and how information is analyzed and modeled. Student can transform entity-relationship model to a relational model, and the to relation database. Student knows the SQL programming language and can make queries and other operations to database, also from other programs. Student knows the basics of NoSQL databases.

Sisältö

- Concepts of databases and database management systems
- Relational databases
- Conceptual modelling
- ER (Entity-Relationship) modelling
- SQL (Structured Query Language)
- Basics of NoSQL databases

Oppimateriaalit

Luentomonisteet, Tukimateriaalit:
Hovi, Huotari, Lahdenmäki. Tietokantojen suunnittelu ja indeksointi, Docendo
Connolly Thomas - Begg Carolyn: Database Systems, Addison Wesley

Opetusmenetelmät

Luennot, harjoitukset ja itsenäinen opiskelu

Opiskelijan ajankäyttö ja kuormitus

lähiopetusta 50% ja itseopiskelua 50%

Arviointiasteikko

1-5

Arviointikriteerit, tyydyttävä (1)

The student understands the concept of database. Student knows how database is designed and how information is modeled. Student knows the basics of SQL programming language and can make queries and other operations to database.

Arviointikriteerit, hyvä (3)

The student understands the concept of database and database management system. Student knows how database is designed and how information is analyzed and modeled. Student can transform entity-relationship model to a relational model, and the to relation database. Student knows the SQL programming language and can make queries and other operations to database. Student knows the basics of NoSQL databases.

Arviointikriteerit, kiitettävä (5)

The student understands the concept of database and database management system. Student knows how database is designed and how information is analyzed and modeled. Student can transform entity-relationship model to a relational model, and the to relation database. Student masters the SQL programming language and can make queries and other operations to database, also from other programs. Student can develop applications, which use NoSQL databases.

Arviointimenetelmät ja arvioinnin perusteet

Tuntitehtävät ja tentti

Esitietovaatimukset

- Basics of programming