Create a own Database

Сентябрь 4, 2022

Содержание

2. Expected results (Success criteria) Are able to create a database in 1,2,3 normal form Are able
3. Development a mini project Create a database in 1, 2, 3 normal forms The 3 normal
4. “Library Management System” - should provide the following functions: Store book information such as Author, Title,
5. 1NF: Library(ID, Date_loan, ISBN, Title, Author, Year, Num_of_books, Press, F_name, L_Name, Address, Phone, Grade) “Library Management
6. 2-3NF: Books(ID_book, ISBN, Title, Authors, Year, Num_of_books, Press); Students(ID_student, F_Name, L_Name, Address, Phone, Grade); Loan(ID_loan, Date_loan,
8. Chen style
9. CREATE TABLE `books` ( `ID_book` char(10) , `ISBN` char(12), `Title` varchar(25), `Author` varchar(20), `Year` int(4), `Num_of_books`
10. Table Students CREATE TABLE `students` ( `ID_student` char(12) , `F_name` varchar(15), `L_name` varchar(15), `Grade` varchar(5), `Address`
11. CREATE TABLE `loan` ( `ID_loan` int(11) AUTO_INCREMENT, `Date_loan` date, `ID_book` char(10), `ID_student` char(12), `Date_return` date, `Note`
12. Relationships
13. Queries SELECT * FROM books WHERE Press LIKE “M_ _ _ _ _”; SELECT Title, Author
15. Скачать презентацию

Слайд 2

Expected results (Success criteria)
Are able to create a database in 1,2,3

normal form
Are able to create a database in the XAMPP
Are able to create tables and table attributes in the XAMPP
Are able determine primary and foreign keys for a table
Are able to create links between tables
Are able to fill records for the tables in the XAMPP
Are able to create queries for a database in the XAMPP

Слайд 3

Development a mini project
Create a database in 1, 2, 3 normal

forms
The 3 normal form of the database is implemented in the XAMPP
Create a database
Create tables and attributes for tables
Identifying primary and foreign keys
Create links between tables
Fill the records for the table
Create the queries for the table

Слайд 4

“Library Management System” - should provide the following 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

Слайд 5

1NF:
Library(ID, Date_loan, ISBN, Title, Author, Year, Num_of_books, Press, F_name, L_Name, Address,

Phone, Grade)

“Library Management System”

Слайд 6

2-3NF:
Books(ID_book, ISBN, Title, Authors, Year, Num_of_books, Press);
Students(ID_student, F_Name, L_Name, Address, Phone,

Grade);
Loan(ID_loan, Date_loan, ID_book, ID_student, Date_return, Note)

Слайд 7

Слайд 8

Chen style

Слайд 9

CREATE TABLE `books` (
`ID_book` char(10) ,
`ISBN` char(12),
`Title` varchar(25),

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

Table Books

Слайд 10

Table Students
CREATE TABLE `students` (
`ID_student` char(12) ,
`F_name` varchar(15),
`L_name`

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

Слайд 11

CREATE TABLE `loan` (
`ID_loan` int(11) AUTO_INCREMENT,
`Date_loan` date,
`ID_book` char(10),

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

Table Loan

Слайд 12

Relationships

Слайд 13

Queries
SELECT * FROM books WHERE Press LIKE “M_ _ _ _

_”;

SELECT Title, Author FROM books WHERE Press LIKE “P%”;

Select * from books WHERE Num_of_books=10;

Select * from books WHERE Num_of_books=10 and Press =‘Semey’ ;

Create a own Database

Содержание

Expected results (Success criteria)Are able to create a database in 1,2,3

Development a mini projectCreate a database in 1, 2, 3 normal

“Library Management System” - should provide the following functions:Store book information

1NF:Library(ID, Date_loan, ISBN, Title, Author, Year, Num_of_books, Press, F_name, L_Name, Address,

2-3NF:Books(ID_book, ISBN, Title, Authors, Year, Num_of_books, Press);Students(ID_student, F_Name, L_Name, Address, Phone,

Chen style

CREATE TABLE `books` ( `ID_book` char(10) , `ISBN` char(12), `Title` varchar(25),

Table StudentsCREATE TABLE `students` ( `ID_student` char(12) , `F_name` varchar(15), `L_name`

CREATE TABLE `loan` ( `ID_loan` int(11) AUTO_INCREMENT, `Date_loan` date, `ID_book` char(10),