Answered step by step
Verified Expert Solution
Question
1 Approved Answer
You have been asked to design and implement a database for CTU, which includes 3 entities ( tables ) , as follows: Students Faculty Courses
You have been asked to design and implement a database for CTU, which includes entities tables as follows:
Students
Faculty
Courses
Part
Create a Word document that includes the following:
Identify at least attributes for each entity, including the following:
Student's entity should have an attribute for the program the student is enrolled in
Faculty should have an attribute identifying their rank.
Properly identify all of the primary keys use solid underlines
Create an entity relationship diagram ERD from the entities. You may use SmartDraw, Visio, Erwin, or even Word to draw the diagram. Take a screenshot no need if you use Word and insert it into the Word document.
Part
Use Microsoft Access to implement the database that you designed in Part and include the following:
Create the Student, Faculty, and Course tables in Access.
Add a few instances in each table.
Create queries for the following objectives:
Find the student names for all students who are in the BSIT program.
Find the faculty names for all faculty whose rank is Associate Professor.
Take screenshots for the tables and queries, including the results.
Insert the screenshots into the Word document, and add a short explanation for each screenshot.You have been asked to design and implement a database for CTU, which includes entities tables as follows:
Students
Faculty
Courses
Part
Create a Word document that includes the following:
Identify at least attributes for each entity, including the following:
Student's entity should have an attribute for the program the student is enrolled in
Faculty should have an attribute identifying their rank.
Properly identify all of the primary keys use solid underlines
Create an entity relationship diagram ERD from the entities. You may use SmartDraw, Visio, Erwin, or even Word to draw the diagram. Take a screenshot no need
if you use Word and insert it into the Word document.
Part
Use Microsoft Access to implement the database that you designed in Part and include the following:
Create the Student, Faculty, and Course tables in Access.
Add a few instances in each table.
Create queries for the following objectives:
Find the student names for all students who are in the BSIT program.
Find the faculty names for all faculty whose rank is Associate Professor.
Take screenshots for the tables and queries, including the results.
Insert the screenshots into the Word document, and add a short explanation for each screenshot.
Save your Word document as "yournameWKdocx."
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