Презентация на тему Create a own Database

database in 1,2,3 normal form
Can create a database in

the environment XAMPP
Can create tables and table attributes in the environment XAMPP
Can determine key and foreign keys for a table
Can create links between tables
Can fill records for the table in the environment XAMPP
Can create queries for a database in the environment XAMPP

1 normal form Create a database in 2 normal forms Create

a database in 3 normal forms the3 normal form of the database is implemented in the environment XAMPP
Database creation Creating a table and attributes for a table Identifying primary and foreign keys Create a link between tables Fill in the records for the table Create queries for a table

functions:
Store book information such as Author, Title, Year, Press
Store

the location of the book, for example, which shelf
Store detail of the people who borrowed than book: who did that, when for how long
4. Fine people in case they don't return the book on time

F_name, L_Name, Address, Phone, Grade)
Normalization

F_Name, L_Name, Address, Phone, Grade);

Loan(ID_loan, Date_loan, ID_book, ID_student, Date_return,

Note)

char(10) NOT NULL DEFAULT '',
`ISBN` char(12) NOT NULL,

`Title` varchar(25) NOT NULL,
`Author` varchar(20) NOT NULL,
`Year` int(4) NOT NULL,
`Num_of_books` int(2) NOT NULL,
`Press` varchar(10) NOT NULL,
PRIMARY KEY (`ID_book`)
);
 

Table Books

`ID_student` char(12) NOT NULL DEFAULT '',
`F_name` varchar(15) NOT

NULL,
`L_name` varchar(15) NOT NULL,
`Grade` varchar(5) NOT NULL,
`Address` varchar(20) NOT NULL,
`Phone` char(12) NOT NULL,
PRIMARY KEY (`ID_student`)
);

int(11) NOT NULL AUTO_INCREMENT,
`Date_loan` date NOT NULL,
`ID_book`

char(10) NOT NULL,
`ID_student` char(12) NOT NULL,
`Date_return` date NOT NULL,
`Note` tinytext NOT NULL,
PRIMARY KEY (`ID_loan`),
KEY `ID_book` (`ID_book`,`ID_student`)
) ;

Table Loan