This is my attempt at DBDL statements trying to plan a database in MySQL. Employers: CREATE TABLE Employers ( EmployerID INT PRIMARY KEY, CompanyName VARCHAR(255), Location VARCHAR(255), ContactInfo VARCHAR(255), ); Customers: CREATE TABLE Customers ( CustomerID INT PRIMARY KEY, Name VARCHAR(255), ContactInfo VARCHAR(255), Education VARCHAR(255), Experience INT ); Reference: CREATE TABLE References ( ReferenceID INT PRIMARY KEY, Name VARCHAR(255), ContactInfo VARCHAR(255), RelationshipToCustomer VARCHAR(255) ); Skills: CREATE TABLE Skills ( SkillID INT PRIMARY KEY, SkillName VARCHAR(255), ProficiencyLevel VARCHAR(255) ); EmploymentPositions: CREATE TABLE EmploymentPositions ( PositionID INT PRIMARY KEY, PostionTitle VARCHAR(255), EmployerID INT, Duration VARCHAR(255), FOREIGN KEY (EmployerID) REFERENCES Employers(EmployerID) ); Interviews: CREATE TABLE Interviews ( InterviewID INT PRIMARY KEY, InterviewDate DATE, Interviewer VARCHAR(255), Feedback VARCHAR(255) ); HiringStatus: HireStatusID INT PRIMARY KEY, CustomerID INT, EmployerID INT, HireDate DATE, FOREIGN KEY (CustomerID) REFERENCES Customer(CustomerID), FOREIGN KEY (EmployerID) REFERENCES Employers(EmployerID) ); I am new to databases and am having difficulties understanding the concepts. I also do not know how to take this information and put it into MySQL 8.0 workbench with relations set up. How can I enter this information in MySQL workbench to create several views that make sense of the context with a resume database? How do I add users to grant permissions?
This is my attempt at DBDL statements trying to plan a
Employers:
CREATE TABLE Employers (
EmployerID INT PRIMARY KEY,
CompanyName VARCHAR(255),
Location VARCHAR(255),
ContactInfo VARCHAR(255),
);
Customers:
CREATE TABLE Customers (
CustomerID INT PRIMARY KEY,
Name VARCHAR(255),
ContactInfo VARCHAR(255),
Education VARCHAR(255),
Experience INT
);
Reference:
CREATE TABLE References (
ReferenceID INT PRIMARY KEY,
Name VARCHAR(255),
ContactInfo VARCHAR(255),
RelationshipToCustomer VARCHAR(255)
);
Skills:
CREATE TABLE Skills (
SkillID INT PRIMARY KEY,
SkillName VARCHAR(255),
ProficiencyLevel VARCHAR(255)
);
EmploymentPositions:
CREATE TABLE EmploymentPositions (
PositionID INT PRIMARY KEY,
PostionTitle VARCHAR(255),
EmployerID INT,
Duration VARCHAR(255),
FOREIGN KEY (EmployerID) REFERENCES
Employers(EmployerID)
);
Interviews:
CREATE TABLE Interviews (
InterviewID INT PRIMARY KEY,
InterviewDate DATE,
Interviewer VARCHAR(255),
Feedback VARCHAR(255)
);
HiringStatus:
HireStatusID INT PRIMARY KEY,
CustomerID INT,
EmployerID INT,
HireDate DATE,
FOREIGN KEY (CustomerID) REFERENCES
Customer(CustomerID),
FOREIGN KEY (EmployerID) REFERENCES
Employers(EmployerID)
);
I am new to databases and am having difficulties understanding the concepts. I also do not know how to take this information and put it into MySQL 8.0 workbench with relations set up.
How can I enter this information in MySQL workbench to create several views that make sense of the context with a resume database? How do I add users to grant permissions?
Trending now
This is a popular solution!
Step by step
Solved in 4 steps
