Schedule Week Assignment Textbooks Quiz Previous Next
Database Systems - This week's Highlights
Database Systems: This weeks topic is Database Design, Modelling and Implementation. We will use erwin Data Modeler for Datbase Design and Modelling. Then we will implement our database model in SQL Server.
You need to know about the following (known from previous courses):
Database Modeling (ERwin), SQL Server and Database Communication with C# (using ADO.NET) should be known from previous course. Basic knowlede of the Structured Query Language (SQL) is necessary knowlede for this project. See also SQL Server and ADO.NET.
Software: Make sure to install both erwin Data Modeler and SQL Server in advance, otherwise you cannot start on the Week Assignment! You need to apply for erwin Data Modeler - so it may take 2-5 days before you are able to use it!
For more details, see the Week Assignment.
2-3h. Main focus: Prepare to participate in class activities. It is important that you are prepared when you come to class.
Database Systems - This week's Highlights
You need the following Software (make sure to install them before you come to class!):
(You will need more software later)
Note! In class we will need to use the software mentioned above. Installing software is time consuming! Don't waste your, the group or the teachers time in class. Make sure to install it before class. If you don't have the software ready for class, you cannot keep up with the practical exercises and project work that you should do in class.
Please go through the resources below before you meet in class.
Database Systems
Video: Introduction to Database Systems:
Database Modelling
Video: Database Modelling with erwin Data Modeler:
SQL Server
Video: SQL Server:
Structured Query Language (SQL)
Do you need to refresh your skills in SQL? Here are some good resources:
SQL Tutorial - Basic SQL Training from w3schools.com
ASP.NET Core
Video: ASP.NET Core - Database Communication:
This video is also available on my Youtube Channel (Industrial IT and Automation).
Click here in order to see more ASP.NET Core Videos and Download Examples.
The theory part of this course is "reading material" (it's like reading a novel), so be sure to take a look at some of the textbook resources below, and especially the Sommerville book. The main concept in this course is to read the theory at home and then apply the theory concepts on the project.
Software Development Literature
Read the following chapters in one ore more of the following Textbooks below before you meet in class:
| Textbook | Syllabus |
|---|---|
| Software Development - A Practical Approach |
|
| Software Engineering (I. Sommerville) |
|
| Essentials of Software Engineering (Frank Tsu et al.) |
|
| Software Engineering (Saikat Dutt, et al.) |
|
6h. Main focus: Practice applying key concepts with feedback. Execution and review of the week assignments will be the main focus in the scheduled class activities.
Review: Upload the Software Requirements and Design (SRD) document to Microsoft Teams. Each Team should give a short overview of the SRD. Class discussions and feedback. You should have started to use Azure DevOps in your project. Make also sure that you have given access to HPH.
It is important that you do what's in the weekly assignments. The weekly assignments guides you through the course with a red line with a primary focus on important topics in software engineering and practical implementation of these topics through a large project. The contents of the week assignments are important criteria when it comes to censorship and grading in this course.
Main Tasks in Week Assignment this week:
Quiz:
Quiz - Can you relax this weekend? - or do you need to take an extra look at some of the available resources? In order to Pass this Quiz, you need to get a Score >= 70%. You should answer the questions without any aids!
6-7h. Main focus: Finish Week Assignment. Check your understanding and extend your learning. Go through the following resources in order to review and get a deeper understanding of what you should learn in this topic. You may also need these resources in order to solve the week assignment.
It is recommended that you read the following documents:
It is recommended that you watch the following videos:
Video: Database Views and Stored Procedures:
Video: Database Development:
Download Database Script Generator used in the Video. You need LabVIEW or LabVIEW Run-Time Engine (free)
Video: ASP.NET Core - Database CRUD Application:
This video is also available on my Youtube Channel (Industrial IT and Automation).
Click here in order to see more ASP.NET Core Videos and Download Examples.
Video: Azure DevOps - Source Code Control:
This video is also available on my Youtube Channel (Industrial IT and Automation).
Below you find some additional resources for deeper understanding and reflection:
Database Design Best Practices
Ten Common Database Design Mistakes
Review Questions - Note! This is mandatory! In order to Pass this Quiz, you need to get a Score >= 50%.
In order to get best outcome, you should answer the questions without any aids! You should also write your answers in your own words using Norwegian language. Don't just copy the text directly from the PowerPoints or the Textbooks, in that way you dont learn anything! When answering the Questions, pretend you are sit down taking the final written Exam. This means you should watch Videos, read the Textbooks, PowerPoints and oher Resources in advance before you start answering the Review Questions.