Assignment

Tables (7)

Class

  • Class ID (classID) — VARCHAR(20) — Primary key — NOT NULL
  • Class'name (className) — VARCHAR(200)
  • Description (description) — VARCHAR(1000)
  • Practice days,hours (schedule) — VARCHAR(100)
  • Price ( in $) (price) — FLOAT
  • Maximun students in a class (maxStudent) — INT
  • Period (in days) (period) — INT
  • Genre of Class (genre) — VARCHAR(50)
  • Difficult Level (difficulty) — VARCHAR(50)
  • Mentor ID (mentorID) — VARCHAR(20) — Foreign key → Mentor.Mentor ID — NOT NULL

Dance Session (DanceSession)

  • Dance Session ID (sessionID) — VARCHAR(25) — Primary key — NOT NULL
  • Overall Score (score) — FLOAT
  • Session TimeStamp (playAt) — TIMESTAMP
  • VideoID (videoID) — VARCHAR(50) — Foreign key → Video.Video ID — NOT NULL
  • User ID (userID) — VARCHAR(20) — Foreign key → User.User ID — NOT NULL

Feedback Detail (Evaluation)

  • Feedback ID (feedbackID) — VARCHAR(25) — Primary key — NOT NULL
  • timestamp of error movement (timestamp) — INT
  • error part (bodypart) — VARCHAR(20)
  • Error Type (error_type) — VARCHAR(50)
  • is this move correct? (isCorrect) — Boolean — NOT NULL
  • Dance Session ID (sessionID) — VARCHAR(25) — Foreign key → Dance Session.Dance Session ID — NOT NULL

Mentor

  • Mentor ID (userID) — VARCHAR(20) — Foreign key → User.User ID — NOT NULL
  • Biography (bio) — VARCHAR(1000)
  • Certificates URL (certificate) — VARCHAR(200)
  • Year of Experience (experience) — FLOAT
  • Rating for Students (rating) — FLOAT

Subscription

  • Subscription ID (subscriptionID) — VARCHAR(20) — Primary key — NOT NULL
  • User ID (userID) — VARCHAR(20) — Foreign key → User.User ID — NOT NULL
  • Class ID (classID) — VARCHAR(20) — Foreign key → Class.Class ID — NOT NULL

User

  • User ID (userID) — VARCHAR(20) — Primary key — NOT NULL
  • User's Display Name (username) — VARCHAR(30)
  • Password (password) — VARCHAR(30)
  • User Email (email) — VARCHAR(100) UNIQUE
  • Full Name (fullname) — VARCHAR(100)
  • Experience Level (experience) — VARCHAR(20)
  • createAt — DATE

Video

  • Video ID (videoID) — VARCHAR(50) — Primary key — NOT NULL
  • Video title (title) — VARCHAR(200)
  • Duration of Video session (duration) — FLOAT
  • Genre of Video (genre) — VARCHAR(50)
  • Difficulty of Video (difficulty) — VARCHAR(50)
  • Keypoint Data (keypointData) — VARCHAR(10)
  • Class ID (classID) — VARCHAR(20) — Foreign key → Class.Class ID