Electronic databases online holiday program

本站添加: 2026-05-12

[00:02:11]Okay, we want to welcome everyone. I am sharing the YouTube link in the chat for people that may not be able to join us via Zoom.

[00:02:22]Mr. President, a good evening.

[00:02:26]I think we can be good to start. We are streaming live. I've shared the link.

[00:02:30]When it is five, you'll take over 7.

[00:02:54]>> Okay.

[00:03:15]Okay.

[00:05:59]Yes, it is the time we agreed to start at exactly 5. We are starting. I would like to welcome you all. First of all, good evening to everyone.

[00:06:18]Uh, briefly, I want us to have an opening prayer. I'm seeing my students are also here. I'm happy that they have joined us. We can start that others will join us on the way.

[00:06:37]Uh who is giving us an opening prayer?

[00:06:48]Christian Kantas Kantas, are you are you there?

[00:07:01]>> Yes, teach there. I'm there.

[00:07:03]>> Yes. Give give us a an opening prayer.

[00:07:10]Lord Father, we thank you for this lesson that you've provided done for us.

[00:07:16]Thank you that it's going to be a success and we are going to understand everything.

[00:07:22]Jesus's name we have prayed.

[00:07:26]>> Okay. Thank you so much. I don't know whether Mr. Sam you have anything to say or you come at the end.

[00:07:35]>> Yes. I think later on seven.

[00:07:38]>> Okay. Okay. Okay. So, we can start. We have time is limited and I want us to use the the limited time efficiently. That's why we are starting immediately in time. Uh we need to understand today the issue of databases.

[00:07:57]uh today we are having the introductory part and we are we are concentrating more on the theoretical part of it then somewhere somehow at the end I will take you through the practical part then those who have laptops you'll have time to do that number shared in the WhatsApp group and please whenever you find problems keep the group is there please keep on asking for support.

[00:08:27]Yes. Uh uh I I thank so much my students for also coming to this presentation. So today we are having electronic databases and the the reason is to empower students uh with electronic database skills for the digital uh for the digital for the digital world. So uh although I know some of you are meeting or we are meeting for the first time virtually we have never met physically but my name is Ron Chams I'm a teacher of ICT and uh the chairperson of the IC charge association of Uganda.

[00:09:18]Uh this lesson is completely free of charge and it has been sponsored by my friend Tossmik and another one for CR7 gadgets. So I'll talk about the sponsors at the end the numbers are there and my number is there in the group. So one before we start our lesson today uh I want us to look at the competency.

[00:09:46]Now as a learner and you must know what you are required when you hear that you are going for the UN question or UN paper always take note each and every application there's something we are we want you to do so and this is the competency so by the end of these sessions I don't know whether by Friday we shall be done we shall have to ask ourselves these too and the competence are the skills they want you. Now if you are in senior 4 at the end they are going to assess you whether you can use a database management system program to manage data that that is the task you have in senior 4. A candidate is required to use a database management system.

[00:10:43]That is what you are required to do. So when we end these sessions and you cannot use a database management system program to manage data, then you'll have wasted your time. Then when we cross to a level, it is more than just using a database to manage data. The learner must learn how to create and manage electronic databases and this is intended to ensure efficient data organization, storage and retrieval. So senior 4 you see the task you have and senior six the task we have. So if you are in senior 4 our scope will be on only learning how to use a database management system to manage data. Then in Senior 6, you don't stop at learning how to use the program, but you must also learn how to create and manage electronic databases. And this is intended to ensure data organization, storage, and retrieval. So these are the two competences we have. So I'm combining both learners.

[00:12:00]So the reason why I'm showing you this is to know the objective of why we are here. So at the end we must ask ourselves can I use if I'm in senior 4 can I use now a database management system and if you in senior 60 the question you must ask can I create and manage electronic databases. So the two competences are different and you can you should take note of them. So this is our content outline.

[00:12:32]This is our content outline.

[00:12:34]I'll try to break down to summarize what we have. If you have a pen, you can be noting some of these things. Uh one today we shall look at introduction to electronic databases.

[00:12:50]Then we shall also look at understanding databases, database tables.

[00:12:57]Then when we meet again uh time may not allow us. We shall look at how to manage the properties.

[00:13:05]Then the fourth one we shall also look at database forms. Then database queries then database reports relational databases and exporting and importing data in databases. That will be our last part. So this is the content outline.

[00:13:28]I'm very sure when you by the time you complete all this you must be able to answer any question about databases and you must be able to use databases as we have seen in our competence. First of all what is a database? What are databases?

[00:13:50]Know what that is. What is a database?

[00:13:53]When you hear a data, it consists of two words.

[00:13:58]Two words, there are two words. Sorry for that error.

[00:14:06]Two words make data and base. You know you have ever seen a base for we have fire base, we have for military men, they have bases. So that base is full of soldiers.

[00:14:21]So base and data.

[00:14:24]So it is two words which are combined to make one word called database. So whenever you hear database is a collection of related information information related or stored in a way that makes it easy to access, manage, update and retrieve.

[00:14:44]So that is what we call a database. uh in the two levels senior four and senior six really don't struggle with I cannot define a database there is no any paper you end and they ask you what is a database this one stops here so there is no any lesson no any exam where they are going to please what is a database no so just know that a database is a collection of related information data because in competence we need to learn how to use it but I'm giving a background to a database then there is another second word which we have called a database management system when we say a database management system is a software a database is a collection an organized collection of related information then a database management system is a software This is a software program you can use to create, store, organize, manage, retrive data from a database. So a database management system act acts as a bridge. It connects the user and the database. It is the software that connects you to a database. There's no way you can manage, you can access, you can update, you can retrive when you don't have a database management system.

[00:16:16]So in all the two levels you are going to meet questions. These can be in form of scenarios where you are faced with problems where maybe the school are organizing records uh in a manual way.

[00:16:38]or the business organizes stock in a manual way then they asking for your advice. So one of the ICT tool you can give is a database management system software because it can be used to create store organize manager need drive from a database. So when it comes to organizing data, a database management system is the most appropriate ICT tool we can use. Databases are used in our daily life. And we have sample examples of databases. Yes, me when I'm teaching I always reminders they can be struggling so much to and in this level whether it is senior 4 whether it is in senior six there is no question which will ask identify examples of databases no but we must know what are some of the examples the national voters register is one of them the school record system hospital patient records, bank customer accounts, library management system, class teachers, register, they are all storing data.

[00:18:03]They are all storing data and that's why we are calling them databases. These are just examples. Then we have the software.

[00:18:13]The software, the data, the database management system software. These are the software we can use to create, manage, organize, control databases. A good example is Microsoft access which is used in senior 6 and senior 4. If you are in senior 4, if you are in senior 6 then this is bad. That's why we have seen in the other competences we have it is bad. So Microsoft Access is the one and in all our lessons it is the one we shall be using. Then we have Oracle. We have Microsoft SQL. Whenever you see that word SQL it stands for structured query language.

[00:19:02]SQ light postgress and others. So those are examples of databases. So the next session that was the introduction the next session is going to be about understanding databases. I've shared a database table and I would like to share it.

[00:19:26]Let me share this one again. This is a database table. A sample database table.

[00:19:34]You can have a look at and I've shared another one.

[00:19:38]I've shared another one in the WhatsApp group and that is one we can start with that is a sample database. This is a school database we can look at and it is the one we are going to use in our discussions a sample database. So look at it. I've shared the file. Now when we go to the exercise I've shared I've shared an exercise there. Let me see. Yes, database learning exercise one.

[00:20:20]You are required to create a database management system.

[00:20:26]you you are required to create a new database and you are going to use a database management system. So let me first attempt this one and show you how do we come up with the database management system. So on your computer just anywhere just anywhere let me hope you can see then I'm going to create a folder I'm making it let us say I call it my name Kapur Benad I'm in S4 East I'm going to open now when you open the folder you go to New and new you are going to see two Microsoft Access database. They are going to be two. They are going to be Microsoft Access database one and Microsoft Access. Then they are going to be two files. Now choose one with A.

[00:21:29]That one. Choose the one with A.

[00:21:34]There's another one with a key in the symbol and there's another one with a and what you do choose the one with a then select the one with a give it a name in the question here they are telling us the name of the database is school database school database that is the name each and every database must have a name each and every database service. You can see here the database you are creating you are saving it as what new. Hope you are noting.

[00:22:13]So that is how we create a database and on your computer please take note that when you right click you are going to see two types. There is a database with a key there's a database with A. We use that one with A. Now you are going to open that database by right clicking on it and say open. So when you open it's going to be empty like this.

[00:22:38]When you are those who have ever used the spreadsheets when you open any spreadsheet it will be having the spreadsheet will be having uh rows and columns but the database will be empty will be empty like that one. You don't find a table already created for you but with sheets you find the table already there. the rows and columns will be there. Now that is an empty database.

[00:23:07]Creating a database I've demonstrated.

[00:23:09]You just right click anywhere on your computer. Then after right clicking where do you go? Selecting Microsoft Access database. The one with a. So that is our database we have created. And now I want us to turn the second session called understanding database tables.

[00:23:31]First of all, each and every database data is stored using tables. And when you hear a database table is a collection of data in rows and columns in a database.

[00:23:48]A database table is a collection of data in rows and columns in a database. And all the data is stored in a table. So a table is the primary source of data in a database. All the data you are using when when you go to the supermarket there and you see they are extracting some information that information is there but it is stored in a table. When you visit any site and they tell you please register just know that the information you are providing is being stored in a table and that's what we are going to look at. So data is stored using tables in databases and the table is the primary source of data like the one we have seen. Now what makes a complete table? When you look at this table this one that table it has four.

[00:24:49]If you're going to create a table in database a table must have these four futures.

[00:24:57]A table must have these four features.

[00:25:00]One are the fields.

[00:25:07]Fields.

[00:25:09]A table must have fields. Where are the fields?

[00:25:13]All the columns you see there, they are called fields in databases. All the columns you are seeing there, they are called fields. Then records. records are the rows white and that light blue there. Those rows you see there are called records. Then another thing on a table is is the table name. A table must have a name.

[00:25:43]Like in this case, let us say what is the name of our table here? Design an appropriate.

[00:25:52]You see here save the table as student is table. Now this one is the name of our table. A table must have a name. Then lastly a table must have a primary key. If you can identify these four features then you can make a very good database table.

[00:26:11]If you can identify. So if you are going to make a database, please make sure that you first identify these four futures. One, the fields, the records, the table name, and the primary key.

[00:26:26]What is a field?

[00:26:29]Whenever you hear the word a field, a field is a field is a column in a database table.

[00:26:40]A column each and every column you see here is called a field.

[00:26:47]So the columns you see there they are called fields.

[00:26:55]Then what makes a complete field? A field must have a name. It must have a data type and it must have a field description.

[00:27:07]Take note of that.

[00:27:11]Mr. Can you mute that sha if a a field now when when I've told I've told you that whenever I talk whenever I talk about a field I'm meaning a column each and every column must have a name must have a data type and must have a field description this is how a field must be in design you are going to see how to design fields It must have a field name. It must have a data type. And it must have a field description. So it must have a field name. It must have a data type. And it must have a field description. There we try to break in in detail what we mean.

[00:28:00]What is a name? A name is the label. A field name is the label attached to the column header. How do you know the name of the field? you just look at it on its column header. Then the data type specifies the kind of data a spec a specific field must hold and the access supports different types of data each with a specific data each with a specific purpose or function. Now a description I've closed that at our level we shall concentrate more on field name and data type field description explains in detail the content in the field. This is less relevant.

[00:28:50]So all good database administrators may ignore this one and for our case we shall also ignore the field description.

[00:29:00]So we shall concentrate on the field name and the data type. So how do you know the field name? You just look at the table you have. This is my table.

[00:29:13]The column headers. This one. This one is now a field. Even this one, even this one, even this one, this one. So these are the names of this field. Meaning that this column is called reg number.

[00:29:26]This one is called student is in name.

[00:29:28]This one is called sex. This one is called date of birth. And this one is called contact. And this one is called district. And this one's called stream.

[00:29:39]So here we can continue.

[00:29:43]You can see the different field names in our table that the first field is called rag number.

[00:29:52]In full maybe it is registration number.

[00:29:55]Then the next one is student is name. We have sex, date of birth, contact, district, stream and fees paid.

[00:30:10]So that's how we identify the few names in a database.

[00:30:14]Then what is a data type? Now if you want to understand databases even if you have not been following so well this one please pay attention because database databases is about principles and data types are very very important.

[00:30:39]So what is a data type? A data type determines the kind of the values that users can store in any given column.

[00:30:49]The type of data that users can store in any given column.

[00:30:56]Data type is very very important when it comes to databases and you must know how to assign appropriate data types. Otherwise if you assign a wrong data type it makes the entire database wrong.

[00:31:13]So you must know how to assign appropriate data types.

[00:31:21]So here whenever here data type is what a field can store and each field can store a data consisting of only one data type.

[00:31:33]So if you want to store a data in any field then you must specify the type of data. So the first one is text as you hear text or short text.

[00:31:56]This whenever this is the default data type in all databases and it is used when you want to store text and also when you store a combination of text and numbers alpha numeric from the word alphabets and numerals and also numbers that do not require calculations like phone numbers.

[00:32:24]However, the field should not exceed 255 characters.

[00:32:33]255 characters.

[00:32:40]255 characters. So there are three ways circumstances under which we can use text.

[00:32:53]Take note your your software may be saying short short text that one has no effect. It is in some software it's called text. In other software earlier versions it is text. Latest versions they can say shorty text. Don't worry about that when you open your computer.

[00:33:14]So what do I mean here? Down for example in a field it contains a name like har and those are alphabets.

[00:33:24]So we are going to use text whenever you see alphabets. Then I have M 001 that is there is letters and numbers we call that alpha numeric.

[00:33:38]Then we have 0 7 81. Those are contacts. Those are numbers but they cannot be used in calculations. So we also use text. Those are the three circumstances under which this data type can be used. Then another data type is called memo. Then latest versions call it long text. Other versions call it large text. So don't struggle, don't complain. It is still memo or long text.

[00:34:10]Memo is similar.

[00:34:12]It is used in the same circumstances we use in the other previous data type text. But the only difference is when the the the text you are entering in the field exceeds 255 characters. A good example if the field contains comments, the field contains remarks, the field contains paragraphs, the field contains sentences, that is when we can use memory.

[00:34:48]So throughout most of your lessons uh this is one of the fields we don't usually use in databases because we rarely get data which contains a lot of which is beyond which cannot fit in the field of text. Then another one is number. So far this is the third data type. I'm showing you this these data types because you must understand data types.

[00:35:19]So they are very very important if you are going to store a data in a database. The second one is what we the the third one I mean is number as you hear number number is used to store ma numbers that can be used in mathematical calculations.

[00:35:41]Any number you can use in mathematical calculations is called what is the data type is numbers take note we have seen earlier that contacts they are numbers but they cannot be used in mathematical calculations so I don't expect someone who has been following from the start to assign number contact then another data type is date stroke time When do we use date stock time?

[00:36:14]We use date stock time when you want to store a date and time values. This one can be for the years 100 to 9999 can be 100 to 99.

[00:36:30]So that is when you can use date and time. So when a field contains date time so we use that one. Then another data type is called currency.

[00:36:43]Currency as you hear that is money.

[00:36:46]Whenever field contains money, the data type that must be assigned is currency.

[00:36:53]Whenever a field contains money, the data type must be currency. Then auto number.

[00:37:01]Auto number is a very special a very special data type.

[00:37:09]This is a unique number which is always incremented.

[00:37:14]They add there one number or random number assigned by Microsoft access and it is assigned whenever a new record is added to table. So every time you add a new record on the table they will assign they will add there one one. But when you say when you assign when you assign number auto number as the data type on your field you cannot add you cannot use that field for data entry. So when do we use auto number? Whenever you see numbers are following a special a special pattern like there's an increment of one one let us say 1 2 3 4 5 like that format then the data type is must be auto number but when you assign auto number it means you are not going to use that field for what you are not going to use that field for data entry so a field where you have assigned auto number you not enter any data in that field Then another one is called yes or no.

[00:38:32]Please understand these data types not them. You will need them. Yes or no. Yes or no is for storing what we call boolean data.

[00:38:46]It is for yes and no values and fields that contain one only one of the two values can be a yes or no. Can be a true or false on and off. Why? I see a food containing data set. Let us say uhhuh payment status paid or not paid. Yes, paid. So there the data type must be yes or no. So it is in what we call boolean of two values only. Yes or no. Then attachment.

[00:39:19]Attachment is for is used when you are going to attach the GT photos. So throughout my teaching career I've never seen any field. So some of these data types are not so common and but we need to understand them because at university many of you are going to find them and you find challenges if you don't didn't understand these data types. So they may bring a field which contains let us say passport photo. They write the name of the student, the class, the stream, the age and whatever. Then at the end they put their passport photo. So that means you are going to put there attachment.

[00:40:00]When you are entering that will be attaching the passport photo. The passport photo for that student. Then O O is also called object linking and embedding. This is not a very common data type.

[00:40:20]And we rarely use such data type but it is for stoing bigger files like pictures, audio, video and other binary large objects. You can be dealing with a database for musicians or artists in Uganda and somewhere somehow there is a field that where you have to attach the hit song of that specific artist. Then the data type you have to assign will be then hyperlink.

[00:40:53]Hyperlink is for text or combinations of text and numbers stored as a text and used as a hyperlink address. I'll give an example of a database for secondary schools. You have the school name and somewhere some of the school they put there school email address then they put there school website where you have to put the website of the school such that the one who is looking at the database you just click into that website. So the data type that should be assigned to that field must be hyper link. Then we have what we call lookup wizard.

[00:41:37]This is not a data type. Lookup wizard is not a data type. But it is a tool that helps users create a lookup field in a table.

[00:41:49]It is a tool that helps users to create a lookup field in a table. What does the lookup wizard do? A lookup wizard is not a data type, but it is one of the tools we use.

[00:42:01]So it helps users to select values from another table or a predefined list rather than entering them manually. So this is the second field we saw earlier a field called where you have attached auto number.

[00:42:21]When you attach auto number you cannot use that field for data entry.

[00:42:27]Then even when you say look up wizard you will not be typing there. But you'll be selecting from a predefined list. Now when you look at our database table I've shared it has the field called sex.

[00:42:43]Basically in Uganda those are the two types of data we can store when it is for sex it is as a male or female. So that data can be predefined such that I don't type that data when I'm entering data in the table. I just select. So the tool I'm going to use is what we call a lookup wizard. Then even stream when you look at the table I shared in the group it has a field called stream.

[00:43:14]And in that stream there is east, west, north and meaning there are only four streams in this school. So I don't want to keep on typing them. I just predefined them before such that I select out.

[00:43:30]So lastly is what we call calculated.

[00:43:34]You can create an expression that uses data from one or more fields and this expression can result can make calculations or can make automatic calculations on that table. What do I mean here?

[00:43:55]What do I mean here? A good example here in the table you can see this one medical. What if the you have to find medical fee and they say medical fee is 25 25% of fees paid. What does this mean on my table here?

[00:44:18]I am stopping at what fees paid and I have to add I have to add another field code medical fee. Let me come here and add. Let me come here and I add. So I have to add another fee called medical fee in the database.

[00:44:41]So after the data type to use here will be calculated. So I'll just say medical fee then I select we shall see this one in the next this session maybe tomorrow.

[00:44:55]How do you controlling those fields?

[00:45:00]So the last data type is called calculated and it is you can create an expression or for performing automatic calculations on an already existing fields.

[00:45:17]So those are the data types. Take note of them because we are going to need them when we are creating a table. Now look at another thing that is very very important is a primary key. In database a table must have a primary key and a primary key is a field or there can be fields. There can be more than one fields one field. So a primary key is a field.

[00:45:47]Whenever whenever I say field I mean a column. And these are columns that contain values.

[00:45:54]These values they are the only values that you can use to uniquely identify each row in a table.

[00:46:05]So a primary there is no database table without a primary key.

[00:46:11]And how do you know that this field is the primary key?

[00:46:17]How do you know? First of all, the field should not allow should should not allow duplication of data.

[00:46:26]Should not allow sharing of data. And we know contacts cannot be shared. You cannot have the same contact. But contacts cannot be used. Those are the three rules. But when you look at the first one and the second, they are the same. It is allowed. Duplication and sharing, they are the same. So it is only two rules. How do you know that this field is the primary key? That field should not allow duplicate it. If I have it, no one else should have it.

[00:46:58]Sharing, it should not be shared. If I have it, no one should have it. But where you have a table which has contacts, you cannot use a telephone contact.

[00:47:11]You cannot use a telephone contact as the primary key.

[00:47:16]So here I'm going to take you back to our table. This is our table. Let us go to the exercise we have.

[00:47:28]Let us go to the exercise.

[00:47:31]So we are supposed one to design an appropriate table with the above information.

[00:47:40]Save the table as student table. We must also apply appropriate data types. We must select an appropriate primary key and we must use a lookup wizard on the fields that is gender and stream.

[00:48:01]We must apply an appropriate data type data types. We must select an appropriate primary key and we must use look up wizard on the stream sex and so I'm going to come up with a table here for you. You don't need to do to know to do this when you are doing the question.

[00:48:24]So but I'm doing this such that you can understand very well. I'm going to draw.

[00:48:30]So we go back, fill the name, data, data type, then fill the description for you. You not draw. You don't need to open the word processor and do this. No.

[00:49:00]When you see the database, you must be knowing what you what you are supposed to do. So I'm going to open.

[00:49:12]So the field here moving everyone you can see where try to make it big.

[00:49:24]We have the field name. So I go back to the table. I've already shared this table. The first field is called reg number.

[00:49:36]The first field is called reg number.

[00:49:40]Oh, sorry for that technical glitch.

[00:50:07]I'm having a technical glitch.

[00:50:21]So, I can close this one.

[00:50:29]And this one is not opening.

[00:50:45]Sorry for the technical glitch. Let me close these programs.

[00:50:57]Sorry, sorry for the technical glitch.

[00:51:01]What do we have?

[00:51:15]I was using what?

[00:51:23]Sorry.

[00:51:26]Okay. I was trying to show you the issue table.

[00:51:32]It had the field name.

[00:51:37]It had the data type for you don't need this word. You don't know when you get the table. When you get that database, you just know what you are supposed to do. But I'm trying to make to to make it more simpler. Then fill the description before we go to the practical part. Then fill the description.

[00:52:00]Description.

[00:52:02]Feel the description.

[00:52:06]Uhhuh.

[00:52:08]I'm going to maximize this.

[00:52:20]can see there.

[00:52:23]This is a sample field in design.

[00:52:32]So the first field was a rag.

[00:52:44]was rag rank n o >> yes the time we have reached >> student name >> we are studying I would like to welcome you both student is name uh briefly I want us to have an opening >> student is name also have text let me open the table for you s that you know you may ask where do you get this where are you getting that I'm getting it from here we have the reg number student's name X.

[00:53:37]Then next we also have date of birth.

[00:53:43]We al also have contact.

[00:53:51]We also have district.

[00:53:59]District.

[00:54:04]I can add there one. We have stream and we also have the fees pay. And when you look at here now the fees are over.

[00:54:17]The fees are over. The so fees paid. You have reg number, students name, sex.

[00:54:23]Those are the columns. Date of birth, contact district and fees paid. So now the next one is to attach data types. How do you attach data types? Come and look at the data.

[00:54:39]Now when you look at this data on the first field is there's reg numbers but in the format of 1 2 3 4 there's an increment of one. And whenever you have an increment of one, what do we do? We assign auto number.

[00:55:04]Then we go to the second one which is the second one is students name. These are alphabets. Sono, Bridget, Brenda.

[00:55:19]The names are written using alphabets.

[00:55:21]And whenever you have alphabets the data type is text. Then we go to sex.

[00:55:30]Sex it is alphabets. But look at the format. It is either male or female.

[00:55:36]Meaning that this data can be predefined. And whenever we have data we can which can be predefined what do we do? We say we can use text as the data type and we can also use a look up wizard.

[00:55:54]Then date of birth.

[00:55:57]Remember whenever we are dealing with date and time values don't waste time.

[00:56:02]If you are dealing with date and date time values you use date stock time.

[00:56:09]Then you go to contact. What is there on contact? contact. These are numbers but numbers which cannot be used in calculations and whenever you have numbers which cannot be used in calculation the data type is text. Then this week, this week look at it. These are letters.

[00:56:30]These are letters.

[00:56:33]The letters ginger, mala, whatever.

[00:56:38]Then they are written using alphabets.

[00:56:40]That is the text. Then we also have stream. The stream is predefined. You can see that there are four there are only four streams. East, south, east, north. There are four streams and whenever you have such data you can use text stop or you can use a look up wizard then fees paid fees paid I'm seeing we have money here and whenever we are dealing with money the data type must be currency then after assigning data type you must get one field to work as a primary key. So look at this. Go and go and test field per field.

[00:57:33]You are supposed to test field per field and see whether it qualifies to work as a primary key.

[00:57:42]What do I mean here? A good example I will start with this field. So in a school students can pay the same amount of fees. When you pay the same amount of fees we cannot use the school fees to identify you personally because when you are in senior four let us say you realize they there can be another student who is paying the same amount.

[00:58:08]So meaning that this field cannot work as our primary key. Then when you go to stream stream or because a primary key should not allow duplication of data.

[00:58:23]We cannot use a stream to work as a primary key because you can be more than one person who are coming from the same stream. If you share a stream and the field they have told us that a primary key is that field that should not allow sharing of data. Since you share the same stream. So it is very difficult to use stream as the primary key then this one means no it will not work as our primary key. Then we go to the district and ask ourselves can people be identified by their district? Because when I ask who are any of you is coming from Wakiso we shall have more than you cannot be only one person who is coming from one district that one cannot exist.

[00:59:14]You will find that there are even other people who come from the same district meaning that this cannot be used. So if you are remember the second rule or the third rule was that contacts cannot be shared. You cannot have the same contact but a contact cannot work as a primary key. So here we just put no it is a no contact cannot be used as a primary key.

[00:59:41]That one is out already. Then date of birth in your stream or in your class do you share dates of birth with other people? Is it possible? Then if you are asking yes or no, we have twins and they always share the same dates of birth. So date of birth, you can celebrate three people on the same day the date of birth and that is already sharing. Then when you say sex, you cannot say I'm the only male. There are other males in the class. Then you go to them. Look at the name. Do you share? Is there anyone who has your name in the class or in the school? Yes or no?

[01:00:24]Automatically, if I'm Ronard, there are also other lonards.

[01:00:29]When you say I want, I want Stefan. I want this one. People will have to ask Stefan who. And the moment that one comes Stefan who, it means there is any other person who has the same name. So, no. But at your school, you are always assigned a social number. And I'm very sure this registration number. Have you ever had have you ever shared the registration number? The question is yes or no. To me, I've never seen students in a school who have the same registration number. It will always be different. So meaning that this field will work as our primary.

[01:01:10]So when we go to the practical, we are going to go down to the practical part.

[01:01:16]This is our database we have already created.

[01:01:20]I'm going to open this database and demonstrate how to create a table in this database.

[01:01:29]So from where we started and where we are now, I'm going to just demonstrate to show you how to create a table and how to create a a a table in database. So this is now when the database open is empty. So the first step was creating the database. Those who joined late I demonstrated this.

[01:01:59]Then the next step you go there is file there is home there is create there is external data database tool and others.

[01:02:07]You go to create you go to create.

[01:02:18]You go to create then you will see table. you will see design table and share points. We click in the word design table.

[01:02:30]So when you open this is what I was demonstrating using with so you can see that there is a field name data type and description optional you can always ignore the description.

[01:02:43]So the first one is rean number there is a point that point there this point you should always ignore that point don't type it a point is an acceptable character if you you you put it there you not continue the the database will keep on bringing this error that error you are seeing so for you when you are typing The few names please ignore. Then another one is student is name. Then this one is sex. This one is date of birth. Then this one is after date of birth. What we have? We have contact.

[01:03:31]We have contact.

[01:03:34]We have contact. We also have district. We also have stream. We also have fees paid. So look here all the all the fields are being assigned with short text or text because it is the default. So it is upon you to come and change. We have agreed that fees paid is money. So we shall put the occurrence. Stream is text but we can use a look up wizard. How do you use a look up wizard? the select look up wizard. So when this one comes they will say I want the lookup field to get the values select. I'll type in the values that I want. Next then I'll say east I'll type in the streams.

[01:04:28]West I'll type in north I'll type in south.

[01:04:38]Finish then this short text because the lookup wizard is not a field that's why it is being left as what text this contact remember date of birth is date stock time then sex we can also use a look up wizard go to look up wizard say I'll type in by default it will be selecting I want say I'll type in then type in that we have male and we also have female Then finish. Then student name.

[01:05:11]Then registration number. We agreed it will be auto number. Then after assigning appropriate data types. Select an appropriate primary key. We have already seen why we are using this one.

[01:05:25]Put the cursor inside that field. Go design. You will see the word primary key. And when you say primary key, they will assign there. They put there a key on that field. They put there a key on that field. So here next is Ctrl S to save the table. The table was student table.

[01:05:53]So then I can take you back briefly on how to view how to view your data.

[01:06:02]These are the two views we have.

[01:06:07]There is design view and table view.

[01:06:11]Designing view is for modifying and managing records. Managing fields sorry.

[01:06:17]So if you want to manage fields then you use design view. If you want to manage records you use database. You use table or data sheet view. So if you want to enter records in your table, so you are going to come here and say view. So you can now start entering the information from the table.

[01:06:45]Uhhuh. The information from the table we have it here is the first student you are going to look at there. Registration number you skip. Then the second one.

[01:07:02]Then sex is a female. The date of birth is given here as 12th of October 2012 12.

[01:07:18]What is the year is 1999.

[01:07:24]19 99 the contact is given here.

[01:07:33]Just copy this contact and paste it there because even the time is almost then the district is ginger.

[01:07:45]Type here ginger.

[01:07:48]So this one you see this is the role of a lookup wizard.

[01:07:52]Then the stream I'll also select is from east. This guy never pay. Then you got the second one. So I'm going to repeat once the I'm going to repeat once.

[01:08:05]I'm going to repeat once uh as I end the session. So this is our database.

[01:08:13]You start with right clicking. Go to new. Access the one with the letter A.

[01:08:19]Then the database name is school database. Take note there are two files.

[01:08:27]There is one that comes and there's also another one. There's one with a key and there's one with a there's one with a key and there's also one which doesn't have a key. So for you select the one which which has letter A.

[01:08:48]That is the database we are going to be using.

[01:08:54]Yeah. Why my database is stoing? So when you open it, you go to create just right click then table design.

[01:09:05]Enter the fields. Reg number ignore the point ignore. Don't put it there.

[01:09:13]Student is name and sex. Then what else? Date of birth.

[01:09:22]Then what else?

[01:09:24]We also have contact.

[01:09:27]We also have district and we also have uh stream stream. And lastly fe page. So here come and say this is current stream is a look up wizard. I say I'll type in the values that I want. I have a stream called east.

[01:09:55]Another one is called north.

[01:09:57]Another one is called west.

[01:10:01]Another one is called south.

[01:10:06]Next finish. Then this week contact leaving date of birth is date stock time sex is I'll type in the values that I want mail finish.

[01:10:25]Then this one should be auto number.

[01:10:29]Select a primary key which is registration number. Ctrl S to save as a student is able.

[01:10:41]Yes. Then from there switch switch the views.

[01:10:49]Switch the views like design view because you have assigned auto number to J social number. Don't type there and start entering the student's name. The records are entered in the table view then select fe of birth was 11 10 then 1999 type the contact there the district put it there. So that comes to the end what you have to do those who have laptops is to go and try out creating that table. If you create that step and complete it very well, please send it to my mail.

[01:11:36]Send it to my mail. My mail is here.

[01:11:41]Send it there. Uh attach your name and school.

[01:11:47]But for my students, this is especially my students, you know.

[01:11:57]and your group you know what you are supposed to do what I want that when you do the work you send it to the email they know they made so that one comes to the end of our first session today all what I want is to hear from you what are some of the questions you're having before we end yes >> some people don't know your email >> some people don't know my Actually those who have been following can share if you you were student then you send this one take note the name is written like that I've seen many people comp the name is like that if you make that table put your name there and send it to that mail.

[01:12:58]I'll be Yes. Yes. Yes. Yes. Yes. Take a note. There is no U. There is no Z I. It is like that. That is my M. That is my M. Take note of it. There's no Z I.

[01:13:23]There's no so any other question I'm receiving questions now when we meet we shall look at ways database forms and how to manage I think that is tomorrow we shall look at how to manage fields how to answer some of those questions there and database forms.

[01:13:55]So any question Mr. Are you still there or you left?

[01:14:03]>> I can't leave. I'm seeing a hand from Patrick. Maybe he can unmute.

[01:14:07]>> Is a student or is a teacher?

[01:14:10]>> He will explain.

[01:14:13]>> Okay.

[01:14:16]Yes, Patrick.

[01:14:20]Assume he didn't put up the hand by mistake.

[01:14:28]Okay. I think now that he's not saying anything, I can give my >> Okay. Hello.

[01:14:35]>> Okay. Okay. Yes. Good evening.

[01:14:40]Um I'm really so grateful for this opportunity and I'm having a concern in two areas. one uh before I move further I'm a local patri an IC teacher I'm this part of upper country in a motor district so I'm taking our concerns in in two ways once maybe after this after this section like if we are to get done with the seasons I don't know whether we're going to get the certificate of attendy that's once secondly I don't know whether maybe during the seasons we can get some like the reg forms and we feel since otherwise the season has been so perfect for me. I've been following from the start up to up to now so I'm much excited with the move or we ready to move with the digital world. Thank you so much.

[01:15:35]>> Wow, that is good. He's asking about whether there can be somewhere where you can write. Yes, I've screenshotted all the participants.

[01:15:46]Yes, I've screenshotted the participants.

[01:15:51]I've been screenshotting them. Let me screenshot them again.

[01:15:57]Yes, I'll be at the end I we shall give us we shall give se of coffee certificates. I think Mr. That is okay.

[01:16:08]It is okay.

[01:16:11]to those who attend up to the end. What do you suggest?

[01:16:14]>> Yes, exactly. Because if we are having more than one day, somebody attending one day and expects to get the same certificate.

[01:16:21]>> No, the certificates we shall give them to the end and I will not tell the day we shall edending.

[01:16:31]>> Yes, >> there's another hand.

[01:16:34]>> Yes. Okay.

[01:16:36]>> Yes. A man.

[01:16:37]>> Yes, sir. Thank you, sir. And I'm I'm asking to know if I can the channel where I can get this YouTube video.

[01:16:48]>> Uh Mr. Am I still sharing?

[01:16:52]>> Yes, please. And the link was shared in the chat.

[01:16:55]>> How did this one join? See, you see here >> channel where I can get this YouTube.

[01:17:04]>> That is the channel.

[01:17:06]The channel was also shared in the WhatsApp group. So in the WhatsApp group, you're going to remove most of the redundant members. I I will make sure that you take a screenshot of attendance because I'm going to remove those who are just idle there who are not doing anything. And if you're on YouTube and you have attended, take a screenshot that shows that you have attended. The next session will be only for those who are interested. We don't want a big number when people are not following.

[01:17:37]So any other question? This is the channel. This the IC association of Uganda. Any other question?

[01:17:47]>> Any other question? Having any other maybe I also need to update Mr. We've had over 30 people on the YouTube channel.

[01:17:59]So probably like you guided they can take the screenshot for matters of accountability and evidence since we are unable to get their correct names through attendance.

[01:18:09]>> Yes. The truth is that on each and every day you you attend take a screenshot because you the certificate will only be given to people who have attended the session without missing.

[01:18:22]Yes. And I will talk to your teachers that this guy when you are teaching database attended and I would we shall send the soft copy certificate to those of my students. I will bring a hard copy certificate.

[01:18:37]So any other question?

[01:18:41]>> I think we are good. I'm only seeing somebody asking from the comment section. Is it possible to access the notes? When does it begin?

[01:18:51]that that one asked we we always start at 5:00 p.m. 5:00 p.m. it is 1 hour session 5:00 p.m. up to 6 p.m. is a one today it was the start that's why we are heading but it is a 1 hour session the presentation will not be shared if you have been attending I was I was very slow and I was telling you please take note the presentation will not be shared if you have attended there's no need for the presentation and if you have understood everything that's why we are doing this session of asking why have you not understood then we repeat then the presentation will not be shared.

[01:19:35]There's no need for sharing presentation.

[01:19:37]>> I think we are good to go. Mr. Luchi, I only just want to pass on communication.

[01:19:41]>> If you want to Yes. Okay. I'm seeing so many.

[01:19:45]>> Yes. First of all, for people that are on the call, both teachers and students, we have website competitions that are coming up on 9th of June. That is going to be heroes day. So please get in touch with the social media handles of the IC teachers association of Uganda. But dear teachers also take note of whatever is normally advertised in our WhatsApp groups. Communication is always there but you find that you are posting something then somebody comes to ask the same question over what you just done.

[01:20:16]That is one. Number two, we have our each one teach one sessions tomorrow at night and we shall be getting guidance on how to how to submit projects that can compete. Then lastly, um dear students, we have a number of seminars coming up soon and please if your teacher is not encouraged to go and you feel you can attend any of the seminars because passing is mainly individual based. So in a situation where you are seeing a seminar for ICT and you can attend it is very okay and we want you to also take part. Thank you very much.

[01:20:55]I hope I've discussed about everything maybe to also encourage students and teachers. You are not only going to visit the YouTube channel of the IC association of Uganda for database but there's a lot of information most of the things that challenge you including web design what Excel we have videos there that can guide you so well. So I wish to end there but please encourage other fellow students of yours to join.

[01:21:21]Database is a topic that challenges many of you and yet this is a session where we can be helped. So tomorrow we expect a bigger number. Keep sharing with people that are in candidate classes both senior four and senior six. That is it for now. Mr. over to you for closing remarks and we close. Actually I would like to thank people who have turned up especially my students the likes of Kaya uh and the katas those are my students see actually I came up with this because of my students and I'm so disappointed that they're not attending do we have any member from M college in C as H and G.

[01:22:16]Now this is because in second term we may not have time to cover this. So if you are in those streams if you from please please say something apart from those I've mentioned one is Caya was following and kandas others please unmute and say something I want to hear from you because yes Daniel I've seen you thank you 6C.

[01:22:52]Yes, Liian that is so cool and good.

[01:22:56]Yes, this is one of the topics we are supposed to cover in second term but second time there are a lot of activities and you may not have time to complete specifically I came up with this idea to help you complete. So school students from other swims from other schools it is okay. Uh we we meet tomorrow. Tomorrow is a public holiday but we meet we meet tomorrow we shall look at how to manage. So those who are who have got that file I shared in the WhatsApp group please try out in your free time try to create that table create that table that table has a lot of marks senior fan senior six there is a lot of marks awarded the if you can create that table it shows the examiner that you can use a database and that's what they mark so much and yours would be uh look at that joking what time we meet it is always 5:00 p.m. tomorrow. So I always try to take your time go through where I find the challenge please ask me I'm always online 24/7 I'm always online uh someone asking for the the registration form it's going to be shared in the the next session we shall share a registration form uh I will share uh but I don't want people who have not attended Oh Nahab from GBBSS.

[01:24:37]Oh thank you. So thank you so much. Thank you Mr. Eric Tom. You have not talked about your what you do and specifically I wanted you to be one of the sponsors.

[01:24:50]Maybe some of these students and teachers may want your services. Please talk about them briefly.

[01:24:56]>> Thank you very much. Uh Mr. was my president tomic events comes on board as a sponsor for sessions of this kind. Mainly we are dealing in event management and hire of event equipment from doing very stunning lighting and setups to hiring of screens, sound, DJ services among others. So anything to do with the function, it could be a corporate gig, it could be a private party, but where you need an event manager, you need lights for hire, you need sound, you need very good DJs and very organized people, we can always reach out to me. I am directly in charge of tomic events.

[01:25:38]You can as well check out our website that is tomicvents.com and we shall be fully in touch. We'll be sharing more with time. Thank you very much.

[01:25:47]>> Okay.

[01:25:50]I'm about to end but I have other schools where I teach. Where are you guys?

[01:25:56]Do you have anyone from Samiga?

[01:26:01]Okay. They are not there. Wouldn't expect them.

[01:26:06]Yes. So another sponsor is uh I know many of you may want smartphones.

[01:26:19]If you need any smartphone uh this is a friend of mine, it's called Michael. You just go to Titanic Plaza shop TC12 Word. The numbers are there.

[01:26:36]If you need a smartphone, you may be having the one and you want to upgrade. This one accepts topups and is the one who always gives me the gadgets. The smartphones is a very good guy. He's called Michael.

[01:26:52]When you reach there, I say I want Michael. Go with that old phone you are having. We'll give you another new one.

[01:26:58]He's the one of the sponsors of this uh session. Go with that old one. Tell him I want to upgrade. Just tell him this is Mr. Chs who sent me here and he will treat you very well. Anything wrong just call me back that the guy has treated me has treated me badly. But what I know is the best I know because I've never sent some anyone there and the person complains and two you may be having less money less money. This one is only available when you have told him that it is this one who has sent me. You you may be having that money and you need a certain phone. You tell a percentage to pay then you give you that phone and you pay only when you have told him that it is this one who sent me. I know many of you need smartones want to upgrade and whatever please go that guy is called Michael. You ask if he's not there then then just move away or call me. He's the only person to work upon you. The numbers are there. I've shared. Yes, he's a very good guy there at Titanic Plaza shop 12 level two. So I think seam we can come to the end of this workshop uh of this I'm calling it a workshop of this presentation.

[01:28:24]>> Okay. Thank you very much Mr. Luchi. I want to just give an opportunity to one student to lead us maybe in the closing prayer and then we can be fully able to close. So just unmute any student who is ready unmute and then >> that one is saying Mr. Tom I don't think know about this. It seems that you have not covered this.

[01:28:48]>> I think the challenge we have here is that people don't use their real names.

[01:28:53]I wish I could get to know the person that >> they don't use students don't prefer using their real names.

[01:28:59]>> Yes. But um if the issue is about students from smack on not knowing we are lucky that you are here. Please >> tell them.

[01:29:08]>> Tell them that is why you actually came.

[01:29:11]Thank you very much.

[01:29:13]>> Because now how did you know when others don't know? That is the issue.

[01:29:16]>> Please tell them. But either way, please read us in the closing prayer.

[01:29:24]>> Wow. We meet tomorrow at 7 p.m. Patrick, what are you saying?

[01:29:28]>> 5 p.m.

[01:29:32]>> Yes.

[01:29:33]up the end today has been shared. I would really appreciate I've like presentations her presentations in that PowerPoint if it will be said it is so nice. Thank you >> Patrick. Are you a teacher? Are you a student?

[01:30:01]>> Yeah, I do. I I do I do teach. I'm a teacher.

[01:30:05]>> Okay. Okay. Come to my >> Thank you.

[01:30:10]Okay. It's okay.

[01:30:14]>> Yes. Kay, are you still there?

[01:30:22]>> Yes.

[01:30:23]What do you have to say? Where are the teacher? around >> teacher. There are some there's you >> Oh, that's good.

[01:30:42]>> The truth is that we may not have time in second term to do this and please please tell them to join next time.

[01:30:53]>> Yes. Make a formal announcement today night.

[01:30:56]>> Okay. Okay. and share this video so that they find us from where we stopped from.

[01:31:03]>> Yes. The administration is not planning for many lessons in second term.

[01:31:11]>> Okay. Okay. Who Mr. Seam over to you me have concluded.

[01:31:16]>> Okay. And since the blessing will always come from God.

[01:31:20]I normally see people fearing to lead closing prayers.

[01:31:25]>> Yes. And therefore we can h ourselves.

[01:31:26]Dear Lord we thank you for this session.

[01:31:28]We pray that the fruits of sessions of this kind can yield a lot for the teachers who giving their time sacrifice time of this kind to become better. But also to our dear students who forgo all what they have to do in holiday and then be able to get to sessions of this kind.

[01:31:45]May they all perform well. May the knowledge they are getting from here be able to transform their lives. In the name of the mighty Lord we pray. Amen.

[01:31:52]Now you only need to just say amen and we call it a day. See you tomorrow same time 5 p.m. Keep time. Thank you.

[01:32:05]>> Nice nice nice Oh, I'm a person.