create an ERD with oracle data modeler
DROP TABLE gym_user;
DROP TABLE administration;
DROP TABLE FAQ;
DROP TABLE feedback;
DROP TABLE schedule;
DROP TABLE crowd_meter;
CREATE TABLE gym_user (
user_id INT(8) NOT NULL,
fname VARCHAR(15) NOT NULL,
lname VARCHAR(15) NOT NULL,
email VARCHAR(50) NOT NULL,
address VARCHAR(400) NOT NULL,
phone_num VARCHAR(12) NOT NULL,
DOB DATE NOT NULL,
PRIMARY KEY (user_id)
) ENGINE=InnoDB;
CREATE TABLE administration (
username VARCHAR(30) PRIMARY KEY,
fname VARCHAR(15) NOT NULL,
lname VARCHAR(15) NOT NULL,
email VARCHAR(50) NOT NULL,
password VARCHAR(255) NOT NULL
) ENGINE=InnoDB;
CREATE TABLE FAQ (
question VARCHAR(255) PRIMARY KEY,
answer VARCHAR(255) NOT NULL
) ENGINE=InnoDB;
CREATE TABLE feedback (
feedback_id INT PRIMARY KEY,
feedback_text VARCHAR(255) NOT NULL,
feedback_date DATE NOT NULL
) ENGINE=InnoDB;
CREATE TABLE schedule (
schedule_id INT PRIMARY KEY,
duration INT NOT NULL,
announcement_text TEXT NOT NULL
) ENGINE=InnoDB;
CREATE TABLE crowd_meter (
current INT(3) PRIMARY KEY,
user_id INT(8) NOT NULL,
time_entery VARCHAR(4),
FOREIGN KEY (user_id) REFERENCES gym_user(user_id)
) ENGINE=InnoDB;
INSERT INTO gym_user (user_id, fname, lname, email, address, phone_num, DOB) VALUES
(‘87959403’, ‘Travis’, ‘James’, ‘[email protected]’, ‘203 Kimberly Rd, Winchester VA’, ‘540-533-6738’, ‘2003-03-01’);
INSERT INTO crowd_meter (current, user_id, time_entery) VALUES
(‘1’, ‘87959403’, ‘1300’);
INSERT INTO administration (username, fname, lname, email, password) VALUES
(‘coach.spring’, ‘Coach’, ‘Spring’, ‘[email protected]’, ‘securepass456’);
INSERT INTO FAQ (question, answer) VALUES
(‘Is the Gym only for student athletes?’, ‘No the gym is for everyone’);
INSERT INTO schedule (schedule_id, duration, announcement_text) VALUES
(‘1’, ‘1’, ‘*Special Announcement: Due to the unforeseen snowstorm the gym along with the school will be closed.’);
INSERT INTO feedback (feedback_id, feedback_text, feedback_date) VALUES
(‘1’, ‘Great practice today!’, ‘2025-03-20’);
