Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Hands - on Activity Entity Relationship Modeling Objective: At the end of the exercise, the students should be able to: Incorporate entities into the database
Handson Activity Entity Relationship Modeling Objective: At the end of the exercise, the students should be able to: Incorporate entities into the database design process. Software Requirements: Microsoft SQL Server Management Studio or higher Microsoft SQL Server Express Instructions: Launch Microsoft SSMS Create a database named in this format: DBLastNameFirstNameex DBReyesMark Create five tables based on the attribute boxes below. Set appropriate data types. Professors ClassSchedules Students Rooms PK professorid PK classid PK studentid PK roomid firstname FK courseid firstname roomname lastname subject lastname building contactnumber schedule contactnumber major FK roomid address Courses department FK professorid FK courseid PK courseid title description department
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started