ppl&dbtSlip9

Q1:-

CREATE (math:Department {name: 'Mathematics', location: 'Building A'}),
(geo:Department {name: 'Geology', location: 'Building B'}),
(chem:Department {name: 'Chemistry', location: 'Building C'}),
(cs:Department {name: 'Computer Science', location: 'Building D'})

CREATE (calculus:Course {name: 'Calculus', code: 'MATH101', credits: 4}),
(geology101:Course {name: 'Introduction to Geology', code: 'GEO101', credits: 3}),
(organicChemistry:Course {name: 'Organic Chemistry', code: 'CHEM201', credits: 4}),
(dataStructures:Course {name: 'Data Structures', code: 'CS102', credits: 3}),
(databases:Course {name: 'Database Systems', code: 'CS201', credits: 3})

CREATE (math)-[:CONDUCTS]->(calculus),
(geo)-[:CONDUCTS]->(geology101),
(chem)-[:CONDUCTS]->(organicChemistry),
(cs)-[:CONDUCTS]->(dataStructures),
(cs)-[:CONDUCTS]->(databases),
(math)-[:CONDUCTS]->(dataStructures) // Assuming Mathematics also conducts Data Structures

MATCH (d:Department)
RETURN d.name AS Department, d.location AS Location

MATCH (cs:Department {name: 'Computer Science'})-[:CONDUCTS]->(c:Course)
RETURN c.name AS Course, c.code AS Code, c.credits AS Credits

Q2:-

// Base class Sports
class Sports(val id: Int, val name: String, val description: String, val amount: Double) {

// Method to display sports details
def displayDetails(): Unit = {
println(s"Sports ID: $id") println(s"Name:$name")
println(s"Description: $description")
println(f"Amount: $$${amount}%.2f")
}
}

// Derived class Indoor
class Indoor(id: Int, name: String, description: String, amount: Double, val courtType: String)
extends Sports(id, name, description, amount) {

// Method to display indoor sports details
override def displayDetails(): Unit = {
super.displayDetails()
println(s"Court Type: $courtType")
}
}

// Derived class Outdoor
class Outdoor(id: Int, name: String, description: String, amount: Double, val surfaceType: String)
extends Sports(id, name, description, amount) {

// Method to display outdoor sports details
override def displayDetails(): Unit = {
super.displayDetails()
println(s"Surface Type: $surfaceType")
}
}

object SportsApp {
def main(args: Array[String]): Unit = {
// Creating objects for Indoor and Outdoor sports
val indoorSport = new Indoor(1, "Badminton", "A racquet sport played by two or four players.", 200.0, "Wooden Court")
val outdoorSport = new Outdoor(2, "Soccer", "A team sport played with a spherical ball between two teams of 11 players.", 150.0, "Grass")

// Performing operations
println("Indoor Sports Details:")
indoorSport.displayDetails()

println("\nOutdoor Sports Details:")
outdoorSport.displayDetails()

}
}