Database+System+-+Unit+16



=Unit 16=

This unit is all about the fundmentals of computing, dtatbases are everywhere and take many forms, we will be creating basic nonrelational databases for the criteria but will also look at how relational databases are created.

The criteria is as follows


 * ** Database Systems – Unit 16 ** || PLTS || Credit 10 ||
 * P1 || explain the principles of database systems ||  || voice recorder and power point: the power point document is explaining the principle of database system and explains why we use database, how we use database and the databse structure.click on the power point document below to see and hear the voice recored document.

|| to see my databsae click on ( Barham Marzani.7z)on above of this table to see the whole database tables. || database system || CT1; CT2 || the five record in the database with address and date of births and pictures....etc. || database system ||   || in the databse form || || Use for text or combinations of text and numbers, such as addresses, or for numbers that do not require calculations, such as phone numbers, house numbers, or postal codes. || report in microsoft access is used for reporting something at the end of something, it is like the report of students in schools at the end of every year or report about someone at work or wherever. besically report is the proper information for speical purpose. we use reports in access at the end of finishing our datbases and we choose these information that we want them to have in our report.when we want to create a report, we are allowed to choose these information that we want to have in our report, for instance we would like to have someoene's address, picture,telephone number...etc, choosing any of them then will be seen in the report at the end of finishing the report, you can view it or print it, and one report usually comes in lots of pages. also we can collect the advantages of the report in these points below: Uploade the design mode: the user who wants to make the report is able to view how the report will look while creating the report the user does not have to complete the report and run it before viewing. this enables the user to make design changes in a more time.
 * P2 || design a non-relational database system, including different data types || IE1; CT1 || I designed a non-relational databse and with different data types, every data type had a special reason and I had to understand the reason for choosing the data type.
 * P3 || create a non-relational database system from a given design || CT1 || I cretaed a databse, but I when I was uploading Images, I was not able to see the images properly and the concept of cretaing a non-relational databse system from a given design was to make a better database to see the images in a better view and with some better features. To see the given design of my databse system go to ( Barham Marzani.7z) ||
 * P4 || import data into a nonrelational
 * P5 || produce queries to extract meaningful data from a nonrelational database system || CT1 || The queries in the databse, the reason for doing this was to understanding the queries in Database.Queries in access is a way of extrcating information from a databse in Micriosoft access. The query usually involves certain criteria or requesting certain data. ||
 * P6 || create and use data entry forms  || CT1 || the form in the databse ||
 * P7 || export data from a nonrelational
 * P8 || produce user documentation for a non-relational database system. ||  || this is about databse and how we use database, why use database , for this one i have explained in this word decument in a wide way. click on the decoment below to see the explaination.
 * M1 || explain the importance of maintaining data integrity in a database system ||  || Data accuercy : for example if you have a data and all your data was right apart of one the data that you want to find in the database you will not find it because you have entered the data incorrectly. thats why its important to enter the information or (store the information in Datanbase ) properly and make sure that everything is entered in a right way. ||
 * M2 || explain the choice of fields, data types and primary key in a non-relational database system || IE6 || creating a databse is related to the data types in the database because the data types are going to help you to create your databse as it required, the data types are Text,Auto number,Date and time,OLE object and currency.Auto number is use for unique sequential or random numbers that are automatically inserted when a record is added, Text
 * M3 || explain the need to calculate data storage requirements ||  || this is about the size of the database which you going to create and some times the size is going to make a problem at the end of the project, for instance when you want to uploade the database to Wickispaces the size of the database doesn't allow you to uploade the database because it might be the database has got a bigger size as it required in wikispaces.so, its better to make sure that the databse that you'r e going to make has to be in accurate size. ||
 * M4 || sort records in a non-relational database system || CT1 || the query and its in the databse ||
 * M5 || produce meaningful reports based on database queries. || CT1 || In the database ||
 * D1 || test a non-relational database system to meet a given design || SM4 || The word decument : we cretae a table and the aim of making this table was to test our databse in three ways one was in normal way and the second way was extreme and the third one was abnormal. ||
 * D2 || explain the benefits of using reports  ||   || Report in Microsoft access:

Updating reports: Updating reports is one of the good advantage, because it helps you to update the informatin in the report that you want to make or before print the report and also when you save the report then you will be able to change the information in the report. ||