=============================================University Db==============================================
-- task 1: (create nam)
	CREATE TABLE students(
	    stuID INT PRIMARY KEY,
	    nam VARCHAR(50),
	    dept VARCHAR(50)
	);
 
-- task 2: (insert info)
	INSERT INTO students (stuID, nam, dept) VALUES
	(1, 'rahim', 'cse'),
	(2, 'tanjin', 'bba'),
	(3, 'karim', 'eee'),
	(4, 'tajrin', 'cse'),
	(5, 'jerin', 'cse');
 
-- task 3: (fragmantation student 1)
	CREATE TABLE student1 AS
	SELECT *
	FROM students
	WHERE dept = 'cse'
 
-- task 4: (fragmantation student 2)
	CREATE TABLE student2 AS
	SELECT *
	FROM students
	WHERE dept != 'cse'
 
-- task 5 set primary key in student 1 table
	ALTER TABLE student1
	ADD PRIMARY KEY(stuID)
 
-- task 6 set primary key in student 2 table
	ALTER TABLE student2
	ADD PRIMARY KEY(stuID)
 
-- task 7 union student 1 & student 2 table
	CREATE TABLE studentUnio AS
	SELECT * FROM student1
	UNION
	SELECT * FROM student2
=====================================================================================================
 
===========================================  vertical fragmantation  =======================================
-- vertical table (student vf1)
	CREATE TABLE studentVF1 AS
	SELECT stuID, nam
	FROM students;
 
	ALTER TABLE studentVF1
	ADD PRIMARY KEY (stuID);
 
-- vertical table (student vf2)
	CREATE TABLE studentVF2 AS
		SELECT stuID, dept
		FROM students;
 
		ALTER TABLE studentVF2
		ADD PRIMARY KEY (stuID);
 
-- join table
CREATE TABLE studentJoin AS
SELECT studentVF1.stuID, nam, dept
FROM studentVF1
INNER JOIN studentVF2 ON studentVF1.stuID = studentVF2.stuID
=====================================================================================================

PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09VW5pdmVyc2l0eSBEYj09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT0KLS0gdGFzayAxOiAoY3JlYXRlIG5hbSkKCUNSRUFURSBUQUJMRSBzdHVkZW50cygKCSAgICBzdHVJRCBJTlQgUFJJTUFSWSBLRVksCgkgICAgbmFtIFZBUkNIQVIoNTApLAoJICAgIGRlcHQgVkFSQ0hBUig1MCkKCSk7CgkKLS0gdGFzayAyOiAoaW5zZXJ0IGluZm8pCglJTlNFUlQgSU5UTyBzdHVkZW50cyAoc3R1SUQsIG5hbSwgZGVwdCkgVkFMVUVTCgkoMSwgJ3JhaGltJywgJ2NzZScpLAoJKDIsICd0YW5qaW4nLCAnYmJhJyksCgkoMywgJ2thcmltJywgJ2VlZScpLAoJKDQsICd0YWpyaW4nLCAnY3NlJyksCgkoNSwgJ2plcmluJywgJ2NzZScpOwoJCi0tIHRhc2sgMzogKGZyYWdtYW50YXRpb24gc3R1ZGVudCAxKQoJQ1JFQVRFIFRBQkxFIHN0dWRlbnQxIEFTCglTRUxFQ1QgKgoJRlJPTSBzdHVkZW50cwoJV0hFUkUgZGVwdCA9ICdjc2UnCgkKLS0gdGFzayA0OiAoZnJhZ21hbnRhdGlvbiBzdHVkZW50IDIpCglDUkVBVEUgVEFCTEUgc3R1ZGVudDIgQVMKCVNFTEVDVCAqCglGUk9NIHN0dWRlbnRzCglXSEVSRSBkZXB0ICE9ICdjc2UnCgkKLS0gdGFzayA1IHNldCBwcmltYXJ5IGtleSBpbiBzdHVkZW50IDEgdGFibGUKCUFMVEVSIFRBQkxFIHN0dWRlbnQxCglBREQgUFJJTUFSWSBLRVkoc3R1SUQpCgkKLS0gdGFzayA2IHNldCBwcmltYXJ5IGtleSBpbiBzdHVkZW50IDIgdGFibGUKCUFMVEVSIFRBQkxFIHN0dWRlbnQyCglBREQgUFJJTUFSWSBLRVkoc3R1SUQpCgkKLS0gdGFzayA3IHVuaW9uIHN0dWRlbnQgMSAmIHN0dWRlbnQgMiB0YWJsZQoJQ1JFQVRFIFRBQkxFIHN0dWRlbnRVbmlvIEFTCglTRUxFQ1QgKiBGUk9NIHN0dWRlbnQxCglVTklPTgoJU0VMRUNUICogRlJPTSBzdHVkZW50Mgo9PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PQoKPT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PSAgdmVydGljYWwgZnJhZ21hbnRhdGlvbiAgPT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09Ci0tIHZlcnRpY2FsIHRhYmxlIChzdHVkZW50IHZmMSkKCUNSRUFURSBUQUJMRSBzdHVkZW50VkYxIEFTCglTRUxFQ1Qgc3R1SUQsIG5hbQoJRlJPTSBzdHVkZW50czsKCglBTFRFUiBUQUJMRSBzdHVkZW50VkYxCglBREQgUFJJTUFSWSBLRVkgKHN0dUlEKTsKCQotLSB2ZXJ0aWNhbCB0YWJsZSAoc3R1ZGVudCB2ZjIpCglDUkVBVEUgVEFCTEUgc3R1ZGVudFZGMiBBUwoJCVNFTEVDVCBzdHVJRCwgZGVwdAoJCUZST00gc3R1ZGVudHM7CgoJCUFMVEVSIFRBQkxFIHN0dWRlbnRWRjIKCQlBREQgUFJJTUFSWSBLRVkgKHN0dUlEKTsKCQkKLS0gam9pbiB0YWJsZQpDUkVBVEUgVEFCTEUgc3R1ZGVudEpvaW4gQVMKU0VMRUNUIHN0dWRlbnRWRjEuc3R1SUQsIG5hbSwgZGVwdApGUk9NIHN0dWRlbnRWRjEKSU5ORVIgSk9JTiBzdHVkZW50VkYyIE9OIHN0dWRlbnRWRjEuc3R1SUQgPSBzdHVkZW50VkYyLnN0dUlECj09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09