CST363: Journal 1

  1. Relational database tables and spreadsheets look similar with both having rows and columns.  What are some important differences between the two?
        -Data Structure:
            Relational Database Table: Organized using a schema, which defines the data types and             relationships between tables. The data is structured and normalized to avoid                                redundancy.
            Spreadsheet: Data is often stored in a flat file format, with each sheet containing its own             set of data. There is typically no enforced schema or relationship between sheets.
         
       -Data Integrity:
            Relational Database Table: Enforces data integrity through the use of primary keys,                    foreign keys, and constraints. This ensures accuracy, consistency, and avoids data                    redundancy.
            Spreadsheet: Relies on manual data entry and validation, making it more prone to errors             and inconsistencies.

2.Installing and configuration a database and learning how to use it is more complicated that just reading and writing data to a file.  What are some important reasons that makes a database a useful investment of time?
    -Databases provide data integrity and consistency.
    -SQL allows user to perform efficient data analysis.


3.What do you want to learn in this course that you think will be useful in your future career? 

    -I want to enhance my SQL skills. Having a good grasp of SQL will help me have a strong           grasp of relational databases. 

Comments

Post a Comment

Popular posts from this blog

CST438 Week 6 Journal

This week i learned about Service-Oriented Architecture (SOA) and its significant impact on modern software development. I learned that SOA promotes the creation of independent services that can communicate over a network, enhancing interoperability and system flexibility. This architecture allows for better scalability, as services can be independently updated and reused across different applications. However, I also recognized the challenges associated with SOA, such as increased complexity and the need for effective data management and governance. Overall, understanding SOA has given me valuable insights into designing systems that can adapt to changing business needs while optimizing resource utilization.
Read more

CST439 Week 10 Journal

What project milestones did you accomplish this week? If you're working in a team, please list what you personally contributed, not the project status overall.     I looked for data for Ifo Business Climate and Manufacturing PMI for Germany. What is your plan for next week?     Look for  Ifo Business Climate and Manufacturing PMI for other European countries. What challenges, if any, are you currently facing in project development? Do you need instructor assistance?     None
Read more

CST499 Week 14 Journal

What project milestones did you accomplish this week? Started working on Part 1 and 2 of Project Status Update and Project Testing. Also started working on the presentation. What is your plan for next week? Finish the above. What challenges, if any, are you currently facing in project development? Do you need instructor assistance? None.
Read more