Cisc 310 Intro To Computer Information Science Databasespage 1 Of ✓ Solved
CISC 310 – Intro to Computer Information Science – Databases Last Modified 4/21/2021 Project 4 – 25 points Unit 10 | Databases - Create Database Tables Before completing this project, please review this week’s instruction module, and read Unit 10 – Computer Concepts 2016. For this project, students will create a new database, with at least 3 tables and multiple records. Project Instructions and Requirements Using Microsoft Access, create a New Database. Do not use a template for this assignment. Create at least three tables.
Students can create the database as shown in this handout. OR Students can choose to create a custom database project. Create your own database for music, small business inventory, etc. Then, enter your own data into the database. The project must include at least 3 tables, include at least 5 fields for each table, and include at least 5 records in each table.
Filename: project4 - upload the database file to Canvas by due date Extension for the file will be created by the program (Access) Database Software Application - Using Access Create the Donors Table (Table 1) Create a new table named DONORS. Use Design view and create the fields *PROVIDE A DESCRIPTION FOR EACH FIELD – AS SHOWN *PROVIDE A DESCRIPTION FOR EACH FIELD – AS SHOWN CISC 310 – Intro to Computer Information Science – Databases Last Modified 4/21/2021 Add 5 records to table | INCLUDE ONE RECORD WITH YOUR FIRST AND LAST NAME Create the Donations Table (Table 2) Create a new table named DONATIONS, go to Design view and create the fields *PROVIDE A DESCRIPTION FOR EACH FIELD – AS SHOWN Add at least 5 records to the table Create the Events Table (Table 3) Create a new table named EVENTS, go to Design view and create the fields *PROVIDE A DESCRIPTION FOR EACH FIELD – AS SHOWN CISC 310 – Intro to Computer Information Science – Databases Last Modified 4/21/2021 Add 5 records to each table | USE CURRENT DATE FOR DATE FIELD Before submitting the assignment • View each table to assure all data in each column can be seen • Resize any column that you cannot see all information each record o Hover over line between columns (at top) o With the mouse showing double-sided arrow, click/drag to resize the column so all data is visible Upload the Project 4 database file to Canvas by the due date.
Paper for above instructions
Introduction
In today's digital environment, effective data management is paramount for organizations, whether they are non-profits, small businesses, or educational institutions (Kumar & Nand, 2020). This project aims to demonstrate the identification, creation, and management of a simple database using Microsoft Access. I will develop a database consisting of three tables: DONORS, DONATIONS, and EVENTS. Each table will include at least five fields and five records to exemplify effective data organization.
Database Overview
Table 1: DONORS
The DONORS table will hold information about the individuals or organizations that have contributed to the cause.
Field Descriptions:
1. DonorID: A unique identifier for each donor (Data Type: AutoNumber).
2. FirstName: The first name of the donor (Data Type: Short Text).
3. LastName: The last name of the donor (Data Type: Short Text).
4. Email: Contact email address for the donor (Data Type: Short Text).
5. Phone: Contact phone number for the donor (Data Type: Short Text).
6. Address: Physical address of the donor (Data Type: Short Text).
Sample Records:
| DonorID | FirstName | LastName | Email | Phone | Address |
|---------|-----------|----------|----------------------|--------------|----------------------|
| 1 | John | Smith | johnsmith@gmail.com | 123-456-7890 | 123 Elm Street |
| 2 | Mary | Johnson | maryj@gmail.com | 098-765-4321 | 456 Oak Avenue |
| 3 | Alex | Brown | alexb@yahoo.com | 234-567-8901 | 789 Pine Road |
| 4 | Alice | White | alicew@hotmail.com | 345-678-9012 | 321 Maple Drive |
| 5 | [Your Name] | [Your Last Name] | [YourEmail@example.com] | [Your Phone] | [Your Address] |
Table 2: DONATIONS
The DONATIONS table will track the contributions made by donors.
Field Descriptions:
1. DonationID: A unique identifier for each donation (Data Type: AutoNumber).
2. DonorID: A foreign key linking to DonorID in the DONORS table (Data Type: Number).
3. DonationAmount: The amount donated (Data Type: Currency).
4. DateOfDonation: The date when the donation was made (Data Type: Date/Time).
5. DonationMethod: The method by which the donation was made, e.g., cash, credit card, etc. (Data Type: Short Text).
Sample Records:
| DonationID | DonorID | DonationAmount | DateOfDonation | DonationMethod |
|------------|---------|----------------|----------------|-----------------|
| 1 | 1 | 0.00 | 2023-10-01 | Cash |
| 2 | 2 | 0.00 | 2023-10-02 | Credit Card |
| 3 | 3 | 0.00 | 2023-10-03 | Online Transfer |
| 4 | 4 | 0.00 | 2023-10-04 | Cash |
| 5 | 5 | 0.00 | 2023-10-05 | Direct Deposit |
Table 3: EVENTS
The EVENTS table records fundraising events organized to attract donations.
Field Descriptions:
1. EventID: A unique identifier for each event (Data Type: AutoNumber).
2. EventName: The name of the event (Data Type: Short Text).
3. EventDate: The date the event will take place (Data Type: Date/Time).
4. Location: The venue of the event (Data Type: Short Text).
5. TargetAmount: The financial goal for the event (Data Type: Currency).
Sample Records:
| EventID | EventName | EventDate | Location | TargetAmount |
|---------|------------------|-----------|-----------------------|--------------|
| 1 | Charity Gala | 2023-10-21 | City Hall | ,000 |
| 2 | Fun Run | 2023-11-05 | Central Park | ,000 |
| 3 | Bake Sale | 2023-12-01 | Community Center |
Cisc 310 Intro To Computer Information Science Databasespage 1 Of
CISC 310 – Intro to Computer Information Science – Databases Last Modified 4/21/2021 Project 4 – 25 points Unit 10 | Databases - Create Database Tables Before completing this project, please review this week’s instruction module, and read Unit 10 – Computer Concepts 2016. For this project, students will create a new database, with at least 3 tables and multiple records. Project Instructions and Requirements Using Microsoft Access, create a New Database. Do not use a template for this assignment. Create at least three tables.
Students can create the database as shown in this handout. OR Students can choose to create a custom database project. Create your own database for music, small business inventory, etc. Then, enter your own data into the database. The project must include at least 3 tables, include at least 5 fields for each table, and include at least 5 records in each table.
Filename: project4 - upload the database file to Canvas by due date Extension for the file will be created by the program (Access) Database Software Application - Using Access Create the Donors Table (Table 1) Create a new table named DONORS. Use Design view and create the fields *PROVIDE A DESCRIPTION FOR EACH FIELD – AS SHOWN *PROVIDE A DESCRIPTION FOR EACH FIELD – AS SHOWN CISC 310 – Intro to Computer Information Science – Databases Last Modified 4/21/2021 Add 5 records to table | INCLUDE ONE RECORD WITH YOUR FIRST AND LAST NAME Create the Donations Table (Table 2) Create a new table named DONATIONS, go to Design view and create the fields *PROVIDE A DESCRIPTION FOR EACH FIELD – AS SHOWN Add at least 5 records to the table Create the Events Table (Table 3) Create a new table named EVENTS, go to Design view and create the fields *PROVIDE A DESCRIPTION FOR EACH FIELD – AS SHOWN CISC 310 – Intro to Computer Information Science – Databases Last Modified 4/21/2021 Add 5 records to each table | USE CURRENT DATE FOR DATE FIELD Before submitting the assignment • View each table to assure all data in each column can be seen • Resize any column that you cannot see all information each record o Hover over line between columns (at top) o With the mouse showing double-sided arrow, click/drag to resize the column so all data is visible Upload the Project 4 database file to Canvas by the due date.
,000 || 4 | Auction Night | 2023-12-15 | Downtown Convention Center | ,000 |
| 5 | Summer Festival | 2024-06-01 | Local Park | ,000 |
Database Implementation Steps
1. Creating the Database: Open Microsoft Access and select “Blank Database.” Save the database with the filename "Project4.accdb."
2. Setting Up the DONORS Table:
- Create a new table in Design View.
- Define fields as described above.
- Input the specified sample records, ensuring one record contains the user's details (as per assignment requirements).
3. Setting Up the DONATIONS Table:
- Create a new table in Design View.
- Define fields as described above.
- Input the specified sample records.
4. Setting Up the EVENTS Table:
- Create a new table in Design View.
- Define fields as described above.
- Input the specified sample records.
5. Final Touches:
- After all tables are set up, resize columns to ensure visibility of all data.
- Test the relationships among tables by using the Relationships function in Access, ensuring that the DonorID in the DONATIONS table correctly links to the Donors.
Conclusion
This project exemplifies how to create a database in Microsoft Access effectively. The three tables created provide a structured approach toward managing donor information, donations, and associated events. Efficient data management through databases promotes better decision-making and improved administrative efficiency within organizations, providing a solid foundation for further development or integration into larger systems (Silberschatz, Korth, & Sudarshan, 2011).
References
1. Kumar, R., & Nand, S. (2020). Fundamentals of Database Management Systems. John Wiley & Sons.
2. Silberschatz, A., Korth, H. F., & Sudarshan, S. (2011). Database System Concepts (6th ed.). McGraw-Hill.
3. Connolly, T., & Begg, C. (2015). Database Systems: A Practical Approach to Design, Implementation, and Management. Pearson.
4. Elmasri, R., & Navathe, S. B. (2015). Fundamentals of Database Systems (7th ed.). Addison-Wesley.
5. Date, C. J. (2004). An Introduction to Database Systems (8th ed.). Addison-Wesley.
6. Rob, P., & Coronel, C. (2016). Database Systems: Design, Implementation, & Management. Cengage Learning.
7. Chaffey, D. (2019). Digital Business and E-Commerce Management (7th ed.). Pearson.
8. Dorsey, K. S. (2020). Microsoft Access 2019 Comprehensive. Cengage Learning.
9. Martin, J. (2019). Database Theory. Wiley.
10. Teorey, T. J., & Yang, C. (2016). Database Modeling and Design (5th ed.). Morgan Kaufmann.
This structure ensures a thorough understanding of database design concepts while fulfilling the project requirements. The next steps would include continual querying and refining the database for practical applications.