CREATE KEYSPACE university WITH REPLICATION = {'class':'SimpleStrategy','replication_factor':1};
 
USE university;
 
CREATE TABLE courses (
 department TEXT,
 course_id TEXT,
 semester INT,
 course_name TEXT,
 credits INT,
 PRIMARY KEY (department, course_id, semester)
) WITH CLUSTERING ORDER BY (course_id ASC, semester ASC);
 
INSERT INTO courses (department, course_id, semester, course_name, credits) VALUES 
('CSE','CS101',1,'Intro to Programming',4),
('CSE','CS201',2,'Data Structures',4),
('ECE','EC101',1,'Basic Electronics',3),
('ECE','EC202',2,'Digital Systems',4),
('ME','ME101',1,'Thermodynamics',3),
('ME','ME202',2,'Fluid Mechanics',4);
 
SELECT * FROM courses WHERE department='CSE';
 

Q1JFQVRFIEtFWVNQQUNFIHVuaXZlcnNpdHkgV0lUSCBSRVBMSUNBVElPTiA9IHsnY2xhc3MnOidTaW1wbGVTdHJhdGVneScsJ3JlcGxpY2F0aW9uX2ZhY3Rvcic6MX07CgpVU0UgdW5pdmVyc2l0eTsKCkNSRUFURSBUQUJMRSBjb3Vyc2VzICgKIGRlcGFydG1lbnQgVEVYVCwKIGNvdXJzZV9pZCBURVhULAogc2VtZXN0ZXIgSU5ULAogY291cnNlX25hbWUgVEVYVCwKIGNyZWRpdHMgSU5ULAogUFJJTUFSWSBLRVkgKGRlcGFydG1lbnQsIGNvdXJzZV9pZCwgc2VtZXN0ZXIpCikgV0lUSCBDTFVTVEVSSU5HIE9SREVSIEJZIChjb3Vyc2VfaWQgQVNDLCBzZW1lc3RlciBBU0MpOwoKSU5TRVJUIElOVE8gY291cnNlcyAoZGVwYXJ0bWVudCwgY291cnNlX2lkLCBzZW1lc3RlciwgY291cnNlX25hbWUsIGNyZWRpdHMpIFZBTFVFUyAKKCdDU0UnLCdDUzEwMScsMSwnSW50cm8gdG8gUHJvZ3JhbW1pbmcnLDQpLAooJ0NTRScsJ0NTMjAxJywyLCdEYXRhIFN0cnVjdHVyZXMnLDQpLAooJ0VDRScsJ0VDMTAxJywxLCdCYXNpYyBFbGVjdHJvbmljcycsMyksCignRUNFJywnRUMyMDInLDIsJ0RpZ2l0YWwgU3lzdGVtcycsNCksCignTUUnLCdNRTEwMScsMSwnVGhlcm1vZHluYW1pY3MnLDMpLAooJ01FJywnTUUyMDInLDIsJ0ZsdWlkIE1lY2hhbmljcycsNCk7CgpTRUxFQ1QgKiBGUk9NIGNvdXJzZXMgV0hFUkUgZGVwYXJ0bWVudD0nQ1NFJzsK