Hello, dear friend, you can consult us at any time if you have any questions, add WeChat: THEend8_
Assignment 3 – Microsoft Access
Database: a collection of data, or information, that is specially organized for rapid search and retrieval by a computer. Databases are structured to facilitate the storage, retrieval, modification, and deletion of data in conjunction with various data-processing operations. A database management system (DBMS) extracts information from the database in response to queries.
ASSIGNMENT OBJECTIVES
The objective of this assignment is to get you familiarized with the basics of designing a database in a simple RDBMS application such as MS Access. As an introductory assignment, each requirement is elaborated through a series of guided steps. In addition to advancing your knowledge of relational databases, a complementary objective is to foster your analytical thinking and logical reasoning skills.
SUBMISSION INSTRUCTIONS
1. This assignment is due by 11:59 PM on Saturday, April 6, 2024.
2. This assignment is to be completed individually and must adhere to the University’s policy on Academic Integrity.
3. The assignment submission must be:
• One (1) electronic .ZIP file,
• Contain only files pertinent to this assignment, and
• Have files that follow the naming and file format conventions specified below.
• Make sure to download and open your submission from Brightspace after you have submitted to
ensure the files are as expected. Any files that cannot be opened (e.g. the file extension was removed or altered) will receive a grade of zero.
4. The following files and file naming are required (including underscores):
• ADM1370_W24_A03_StudentID.zip (contains your submission files)
• ADM1370_W24_A03_StudentID_Academic (PDF or MS Word file)
• ADM1370_W24_A03_StudentID_Database (Access file)
• ADM1370_W24_A03_StudentID_Report (both PDF and MS Word files)
5. Include your signed Declaration of Academic Integrity (see next page).
6. Failure to properly name your files, submit in the correct file formats, or omitting your Academic Integrity statement will result in deductions, up to and including receiving a mark of zero on the assignment.
ASSIGNMENT SCENARIO
Icarus Flights (IF) is attempting to modernize their information systems to better manage their operations. As part of their modernization project, they have tasked you with developing a prototype database application that they will then provide to developers and/or suppliers when obtaining an enterprise-grade system.
IF maintains a fleet of different aircraft that fly passengers across its regional routes. Each aircraft has various seat configurations, referred to as seat maps, that include different types and numbers of seats; for example, larger jet airplanes will have Premium Class, Business Class, and Economy Class seats while turboprop airplanes normally only have Economy Class seats.
When a passenger wishes to travel with the airline, they will book a seat on a particular flight and will be issued a ticket. The ticket will state which flight it is for, which seat on the airplane they will sit in, and how much they paid for the ticket. As the airline prioritizes passenger experience, they avoid double-booking seats on a flight, ensuring only one passenger is ever assigned to a particular seat for a flight.
When being given requirements for the prototype, a conceptual model was provided, along with the required tables and fields on the following pages.
To prepare the database for IF, you will need to perform the following actions:
create & populate tables,
link tables together through lookups and relationships,
create queries to display results,
create forms for data entry,
create reports for tables and queries,
create a navigation menu for the database.
Each of these are described throughout the rest of the document.
PART 1 - CREATING TABLES
Start Microsoft Access and create a Blank Database.
Step 1.1 - Create the AIRPLANE Table
1. Create a new table using the Design View (Create => Table Design) command.
2. In the Field Name column, enter all the attributes as shown in the AIRPLANE table definition. Make sure the Data Type pertaining to each field is of the correct type.
3. Use the “Description (Optional)” column in the Design View to describe the type of information that goes in each of those fields (e.g. for the plane_Model field, state that the field captures the plane’s manufacturer’s model number)