ICT 1407 Database Systems

Hello everyone.

I would like to welcome you to the database systems

Cause Which is called it.

As I see the 1407 a mission to have a

lecturer in charge for the schools and I said he

won 407 cause uh today in this video I'm going

to give you a brief introduction for the cause and

what are we going to do and what are the

evaluations and the course, contents and the learning outcomes of

discourse. As you know, I see the 14070s uh 4

credit course which can which will contain a practical part

as well.

So we'll go into the course learning outcomes.

So once you're done with this cause we hope that

you will be able to design a relational database using

entity relationship diagrams.

We call er diagrams and Yeah and you should be

able to apply normalization principles that you heard that you

will be learning uh in this cause and ah we'll

use and you should be able to use the data

management system to implement and manage a database.

And ah of course you should be able to use

structured good language to construct.

Mhm SQL statements that will be uh then you can

use those SQL statements to retrieve data from the database

is as well.

And uh again when it comes to the normalization, you

should know what is it, what are the functional dependence

is software uh of a system and uh how we

are going to normalize your database according to them.

And uh we expect you to be familiar with the

database storage structures uh and this uh such as uh

indexing and the B.

Tree and hashing and so on.

There's a few uh data based stories structures that we

are going to discuss in this course.

And uh also we are going to discuss about some

advanced topics uh Uh huh recent development of database systems

so that uh we expect you to have a certain

knowledge on the recent developments of the Little Bit systems

as well.

Mm And of course you're going to have a project

during this course.

And in that of course we expect you to uh

work as a member of a team.

So you have to get together into a team and

you have to work on project.

So you will be learning how to be a member

in the team.

Mm Next we are going to uh we will go

through the course content.

Um in the introduction part of course we will be

discussing several topics.

The basics like what what is financially why we need

the database systems and what is the important where we're

going to use databases and where we are not going

to use databases and and so on and some definitions

and then we will be discussing the relational model and

then that of course we we will discuss the structure

of relational database and the relational algebra as well.

And the next main topic will be year diagrams and

the er diagrams or he entered the relationship models and

that E N T.

In hell and has also extended entity relationship models.

Yeah. So then we will be discussing about the normalization

and relational database design and the overall system structures.

And the you will be given your you expect to

have an awareness of top at once topics or the

recent developments of the database systems.

So that's the course content and the most important part

will be the evaluation.

You you must be curious so how we are going

to be evaluated according to the pandemic to we still

don't know what the country uh what what type of

examination you're going to have uh Anyway.

Uh huh hoping that you're hoping that you might get

an online examination.

I have given this evaluation.

This evaluation might be changed if it's going to change

I will inform you And um so this is the

evaluation cri even these are devolution criterias like assignments and

quizzes. It will take up to 20 and we will

be getting a project I'll be discussing I've been describing

about IT project and ah That project will contain about

40 of your mark and mark and the in some

mistakes. Some nations will take up to four departments or

together it will Count up to 100%.

Yes. So that will be the uh huh.

No that will be the basic I the idea that

you should have about the cause.

I myself want to have a rat monkey.

And you can reach me any time.

My contact data will be available in the Olympus so

you can contact me and there will be a support

stuff and you can reach them as well uh in

many keys.

Then the other thing that I want to let you

know is that the way that we're going to conduct

the lectures?

You you will be up and I will be uploading

videos for each and every topic so you have to

go through it and uh does uh lecture videos so

you can have a good idea about this topic.

Uh And now following I will be uploading assignment.

Homeworks and places you have to attend them after going

after ah going through this uh after you have gone

through this uh materials if and the reference book.

Well I'm not I'm not pretty sure that you're going

to have you're going to from the exact same thing

in the Uh huh uh in the internet.

But Uh huh.

Try my best to find out a good copy of

the reference.

Uh huh That reference book, I'll be uploaded uh in

the olympics as well.

And uh uh I will open up a forum, so

if you have any sort of a question regarding these

lectures regarding the topic that we are discussing on that

on that day, so you can post your question in

the forum.

Right? So that Uh huh I'll arrange a small meeting.

Okay, So it is not a mandatory for all the

students to parts of it, but I will approach the

link to the dilemma.

So you if you if you are if you want

to no.

What are what are we discussing In their two meetings?

You can join it.

Right. What I will be doing is I will answer

your questions.

Mhm. So if you have any sort of questions, if

you want to clarify anything, I'll be arranging to meetings.

Yeah. So that is how we're going to conduct this

lecture series.

And I hope uh you all are staying will.

And good luck with this course.

Thank you very much.

ICT 1407 Database Systems

Chapters

Audio TranscriptAuto-generated