IT-FPX2230_LastFirst_Assessment2-Attempt1
docx
keyboard_arrow_up
School
Capella University *
*We aren’t endorsed by this school
Course
2230
Subject
Information Systems
Date
Feb 20, 2024
Type
docx
Pages
6
Uploaded by aralph1993
Weekly Solutions Submission Template
Name
: Angela Ralph
Date
: 1/25/24
Course
: IT-FPX2230 – Introduction to Database Systems
Assessment
:
Insert here a copy of your tee log file(s) of all of your SQL statements so that they could be unzipped, loaded, and run in MySQL command line client:
Insert here a copy of SQL statements text that you used here (copy and paste SQL statements here):
-USE test;
-CREATE TABLE books (book_id INT, title TEXT, status INT);
-SHOW TABLES FROM test;
-DESCRIBE books;
-INSERT INTO books VALUES(100, 'Heart of Darkness', 0);
-INSERT INTO books VALUES(101, 'The Catcher of the Rye', 1);
-INSERT INTO books VALUES(102, 'My Antonia', 0);
-SELECT * FROM books;
-SELECT * FROM books WHERE status = 1;
-SELECT * FROM books WHERE status = 0 \G
-UPDATE books SET status = 1 WHERE book_id = 102;
-SELECT * FROM books WHERE status = 1;
-UPDATE books SET status = 0 WHERE book_id = 101;
-SELECT * FROM books WHERE status = 0;
-UPDATE books SET title = 'The Catcher in the Rye', status = 1 WHERE book_id = 101;
-CREATE TABLE status_names (status_id INT, status_name CHAR(8));
-INSERT INTO status_names VALUES(0, 'Inactive'), (1,'Active');
Insert screenshot(s) showing the result running your SQL statements here:
Reflecting on this assignment, summarize the steps taken to complete the assignment and any issues you encountered:
Overall, I really enjoyed this assignment. I have used PostgreSQL, which is like MySQL when it comes to syntax. I did run into an issue when attempting to export my queries as a tee log, I am still trying to figure out how to do this. Other than that, I look forward to diving into MySQL and bettering my query skills.
For Unit 1, Unit 2, and Unit 5 Assessments Only
u01a1: First Steps With SQL
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
The Database System Life Cycle, otherwise known as the System Development Life Cycle (SDLC), consists of five important steps:
1.
Investigation.
2.
System Design.
3.
Development.
4.
Execution.
5.
Maintenance.
Using the Capella library or the Internet, research the Database System Life Cycle. Find at least
two references to it. Note that the names and wording in the steps of the life cycle may superficially vary between different sources. Focus on understanding the concepts presented, rather than the language.
Summarize each step and describe how they work together.
Explain how you have used, or can use, the cycle in another context. For example, how can these steps be used when buying a car or planning a trip?
Use a table to show parallels between developing a database and performing the
task you chose.
1.
Investigation: Requirements of the database are identified, and the scope of the project is defined.
2.
System Design: The structure and architecture of the database are planned out. The data models are defined, data storage and retrieval methods are specified, and a blueprint of the system is created.
3.
Development: The database is built based on specifications. During this phase, the database schema is tested, data integrity is implemented, and applications/programs are developed.
4.
Execution: Data is entered into the database and the system is used as intended. This also includes testing the system under realistic, real-world conditions.
5.
Maintenance: This phase is ongoing and entails making updates or modifications to the system to ensure that it is operating smoothly.
Together, all of these steps make up the Database System Lifecycle.
Phase
Developing a database
Renovating a house
1.
Investigation
Determining what the system will do.
Planning which changes to make and setting a budget.
2.
System Design
Blueprint created for system.
Blueprint created of new layout, paint colors/fixtures/etc. chosed.
3.
Development
The system is built.
Demolition started.
4.
Execution
Data entered into database and system tested.
Renovations are completed (walls painted,
new flooring put in, new plumbing installed.
5.
Maintenance
Any issues are addressed
Any issues are fixed and
and changes made.
the plumbing and home is upkept to secure the integrity of the renovations.
u02a1: Creating the Initial Table for the Volunteer Database
Think about the design of the table to hold a volunteer's ID number, name, mailing address, phone number, email address, and three more fields of your choice. Briefly summarize (2–3 paragraphs) your design for this table. Explain your decisions about the structure of the table and data types used. Discuss how you would go about gathering and normalizing the information that you need for putting the volunteer database together and how that fits into the database life cycle.
When designing the initial table for the volunteer database, I first decided which data types to use for each of the different required fields. For the VolunteerId, I decided to use integer since the records will be organized by a unique numerical identification number.
The Name field will use the VARCHAR(50) data type to accommodate for different lengths of names. For the MailingAddress I decided to use the VARCHAR(255) data type to allow flexibility in storing different address formats. For PhoneNumber I will use VARCHAR(15) to accommodate different phone number formats. The EmailAddress field will have a VARCHAR(100) data type.
In addition to the above fields, I have decided to add a few more fields to the table. The Count field will be an INT which counts the number of times the individual has volunteered. The LastService field will be a date field indicating the last time the volunteer was active. The Motto field will be TEXT data type which includes the volunteer’s personal motto that aligns with their values.
To populate the table, information will be gathered through online submissions, application forms, and direct input from the volunteers. The data will be normalized by analyzing the collected data to identify the different relationships between fields and to reduce redundancy and improve data integrity. Also, to avoid inconsistencies, each piece of data will be stored in only one place within the table. Through these methods of gathering and storing data, you can ensure that data is accurate and secure throughout its lifecycle.
u05a1: SQL Functions
Looking back at all of the work you have completed this quarter, briefly summarize (2–3 paragraphs) the key components of the volunteer database and discuss how the database life cycle has progressed through the phases of investigation, system design, development, execution, and maintenance.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help