I am learning databases and need help understanding normalization. I have these Entities: ENTITIES Employers: Companies or organizations that are hiring. Attributes: Employer ID, Company Name, Location, Contact Information Customers: Job Applicants or Candidates. Attributes: Customer ID, Name, Contact Information, Education, Experience References: References from customers. Attributes: Reference ID, Name, Contact Information, Relationship to Customer Skills: Software and hardware skill of the customer. Attributes: Skill ID, Skill Name, Proficiency Level Employment Positions: Employment position held by customers. Attributes: Position ID, Position Title, Company Name, Duration, Responsibilities Interviews: Interviews conducted with customers. Attributes: Interview ID, Interview Date, Interviewer, Feedback Hiring Status: Whether the customer was hired or not. Attributes: Hiring Status ID, Customer ID, Employer ID, Hire Date I ask: How can I identify and document functional dependencies for all entities? How would I take this information and turn it into 1nf, 2nf, and 3nf? How can 3nf be made into a BCNF database if possible?
I am learning databases and need help understanding normalization.
I have these Entities:
ENTITIES
Employers: Companies or organizations that are hiring.
Attributes: Employer ID, Company Name, Location, Contact Information
Customers: Job Applicants or Candidates.
Attributes: Customer ID, Name, Contact Information, Education, Experience
References: References from customers.
Attributes: Reference ID, Name, Contact Information, Relationship to Customer
Skills: Software and hardware skill of the customer.
Attributes: Skill ID, Skill Name, Proficiency Level
Employment Positions: Employment position held by customers.
Attributes: Position ID, Position Title, Company Name, Duration, Responsibilities
Interviews: Interviews conducted with customers.
Attributes: Interview ID, Interview Date, Interviewer, Feedback
Hiring Status: Whether the customer was hired or not.
Attributes: Hiring Status ID, Customer ID, Employer ID, Hire Date
I ask:
How can I identify and document functional dependencies for all entities?
How would I take this information and turn it into 1nf, 2nf, and 3nf? How can 3nf be made into a BCNF
Trending now
This is a popular solution!
Step by step
Solved in 5 steps