Question: 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
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
