Tablets

idNamePriceOperating_SystemScreenSize
1iPad Pro899.99iOS12.9
2Galaxy Tab S6799.99Android10.5
3Surface Pro 7999.99Windows 1012.3
4Pixel Slate799.99Chrome OS12.3
5Xiaomi Mi Pad 4249.99Android8

Laptops

idNamePriceOperating_SystemRAM
1MacBook Air999.99macOS8
2Dell XPS 131199.99Windows 1016
3Lenovo Thinkpad T490s1499.99Windows 1016
4HP Spectre x3601299.99Windows 1016
5Asus Zenbook UX333FA1199.99Windows 1016

Students

idFirstNameLastNameAge
1JohnSmith21
2JaneDoe22
3MichaelBrown23
4EmilyWhite20
5DavidGreen24

Classes

idNameTeacherId
(→ Students.id)
1Math1
2English2
3History3
4Biology4
5Physics5

Enrollments

StudentIdClassIdGrade
(→ Students.id)(→ Classes.id)
11A
22B+
33C
44A-
55B

Devices

DeviceTypeOSPurchaseDateWarrantyPeriod
TabletWindows 102022-01-011
TabletiOS2022-01-011
LaptopmacOS2022-01-011
LaptopLinux2022-01-011
DesktopWindows 102022-01-011