I Need Someone To Do This For Me Week 10 Assignment 3 Create

Question

I Need Someone To Do This For Meweek10 Assignment 3createtables A I need someone to do this for me. Week 10 Assignment 3: Create Tables and Queries in MS Access (100 Points) Using an ERD to create tables in MS Access Refer to the ERD created in Assignment 2 / Week 8: Perform the following steps in MS Access: Create the tables and relationships from the database design created in Assignment 2 / Week 8. Add at least five (5) records into each table ( Note: You must determine the field values). Include the following screen shots in a Microsoft Word document to show the completion of the steps above: Screen shot depicting the tables created within MS Access. Screen shots depicting the records added into each table. Include one student where the student's last name is your name . Query tables in MS Access Perform the following steps in MS Access Create a query with all fields from the student table, where the student's last name is your name . Create a query that includes students’ first names, last names, and phone numbers. Create a query that includes instructors' first names, last names, and courses they teach. Include the following screen shots in a Microsoft Word document to show the completion of the steps above: Screen shot depicting the tables created. Screen shots depicting the records added into each table. Screen shots depicting the query results from each of the queries created.

Dr. Jack HW Helper · Accepted Answer

Introduction The task of creating a relational database in MS Access based on an Entity-Relationship Diagram (ERD) involves a systematic approach to database design, implementation, and querying. This process encompasses translating the ERD into SQL tables, establishing relationships, populating the tables with data, and then executing queries to retrieve specific datasets. The importance of this procedure lies in its ability to organize complex data efficiently and support meaningful data analysis within a user-friendly environment like MS Access. Creating Tables and Establishing Relationships Following the guidelines of the assignment, the initial step involves examining the ERD created in Assignment 2 (Week 8). Based on the ERD, tables representing entities such as Students, Instructors, and Courses are designed. In MS Access, each entity is converted into a table, and the relationships dictated by the ERD are implemented through primary keys and foreign keys. For instance, the Students table might include fields such as StudentID, FirstName, LastName, and PhoneNumber, while the Courses table contains CourseID, CourseName, and InstructorID. The Instructor table would include InstructorID, FirstName, and LastName. Establishing relationships between tables is crucial; for example, the InstructorID in the Courses table links to the Instructor table, ensuring referential integrity. Once the tables are created, at least five records are added into each, with data manually entered into fields such as student names, phone numbers, course titles, and instructor details. Screenshots of the tables and sample data validate that the design and data population phases are complete. Performing Queries in MS Access After populating the database, the next step involves creating specific queries to extract useful information. Query 1: Student Last Name This query retrieves all data from the Student table where the Last Name matches the user’s last name. It demonstrates filtering c

I Need Someone To Do This For Me Week 10 Assignment 3 Create

I Need Someone To Do This For Meweek10 Assignment 3createtables A

Paper For Above instruction

Introduction

Creating Tables and Establishing Relationships

Performing Queries in MS Access

Query 1: Student Last Name

Query 2: Student Names and Phone Numbers

Query 3: Instructor Names and Courses

Conclusion

References