SYK2900 Folkehelse i et globalt perspektiv Emneplan

After completing the course, the student is expected to have achieved the following learning outcomes defined in terms of knowledge, skills and general competence:

Knowledge

The student is capable of:

• explaining what a database system is and what it consists of
• explaining what XML is and how it is used
• explaining what transactions are and how they are carried out
• explaining the use of indices and different ways of storing the files physically
• explaining what a data warehouse is and how it differs from a database system
• explaining how the combination of ER modelling and normal forms provides well-structured relational databases

Skills

The student is capable of:

• designing databases with the help of ER modelling
• creating databases and using them with the help of the SQL language
• drawing ER models and generating database scripts with the help of software

General competence

The student is capable of:

• explaining the documentation and design of databases with ER models

The following coursework is compulsory and must be approved before the student can sit the exam:

• 2 individual assignments

Individual written exam, 3 hours

The exam result can be appealed.

In the event of resit and rescheduled exams, another exam form may also be used or a new assignment given with a new deadline. If oral exams are used, the result cannot be appealed.

None.

Grade scale A-F.

One internal examiner. External examiners are used regularly.

Alle hjelpemidler er tillatt så lenge regler for kildehenvisning følges.

Bestått-Ikke bestått.

Alle besvarelser vurderes av to sensorer. Ekstern sensor benyttes regelmessig, og minimum ved hver tredje gjennomføring av emnet. Ved uttrekk av besvarelser til ekstern sensur skal uttrekket omfatte minimum 10 prosent av besvarelsene, men uansett ikke færre enn 5 besvarelser. Ved uttrekk skal ekstern sensors vurdering komme alle studentene til gode.

• 20 studiepoeng overlapp med SYKK/SYKP2200 Folkehelsearbeid, 20 stp.
• Overlapp med undervisningsopplegget INTER1200