Podcast
Questions and Answers
What is a database best defined as?
What is a database best defined as?
What role does knowledge play in relation to data?
What role does knowledge play in relation to data?
Which of the following statements best describes information?
Which of the following statements best describes information?
Which email belongs to the module coordinator for the Full-Time group?
Which email belongs to the module coordinator for the Full-Time group?
Signup and view all the answers
Why are databases significant in the digital world?
Why are databases significant in the digital world?
Signup and view all the answers
What distinguishes data from knowledge?
What distinguishes data from knowledge?
Signup and view all the answers
Which of the following best encapsulates the relationship between data, information, knowledge, and wisdom?
Which of the following best encapsulates the relationship between data, information, knowledge, and wisdom?
Signup and view all the answers
Which statement is true regarding the types of data that can be stored in a database?
Which statement is true regarding the types of data that can be stored in a database?
Signup and view all the answers
What is the estimated amount of data in the digital universe as of 2017?
What is the estimated amount of data in the digital universe as of 2017?
Signup and view all the answers
What percentage of data was created in the last two years leading up to 2017?
What percentage of data was created in the last two years leading up to 2017?
Signup and view all the answers
Which database management system is primarily used in the labs for the module?
Which database management system is primarily used in the labs for the module?
Signup and view all the answers
Which of the following will NOT be included in the learning objectives of the module?
Which of the following will NOT be included in the learning objectives of the module?
Signup and view all the answers
What is a major focus of the module's curriculum in relation to SQL?
What is a major focus of the module's curriculum in relation to SQL?
Signup and view all the answers
Which of these topics will likely be covered in the module?
Which of these topics will likely be covered in the module?
Signup and view all the answers
What is a skill students will acquire by the end of the module?
What is a skill students will acquire by the end of the module?
Signup and view all the answers
Which one of the following is NOT a topic to be studied in the module?
Which one of the following is NOT a topic to be studied in the module?
Signup and view all the answers
What is the minimum total effort required for this module?
What is the minimum total effort required for this module?
Signup and view all the answers
How many hours of lectures are included in the total effort for the module?
How many hours of lectures are included in the total effort for the module?
Signup and view all the answers
What is the recommended weekly time allocation for private study?
What is the recommended weekly time allocation for private study?
Signup and view all the answers
Which resource is essential for gaining complete knowledge of the module's material?
Which resource is essential for gaining complete knowledge of the module's material?
Signup and view all the answers
What is the primary purpose of the weekly 'homeworks' assigned in this module?
What is the primary purpose of the weekly 'homeworks' assigned in this module?
Signup and view all the answers
Why is regular engagement with the library's resources stressed for this module?
Why is regular engagement with the library's resources stressed for this module?
Signup and view all the answers
Which of the following statements is true regarding the recommended textbooks?
Which of the following statements is true regarding the recommended textbooks?
Signup and view all the answers
What proportion of the total effort is dedicated to independent study?
What proportion of the total effort is dedicated to independent study?
Signup and view all the answers
What is the main focus of the book 'Database Design for Mere Mortals®'?
What is the main focus of the book 'Database Design for Mere Mortals®'?
Signup and view all the answers
Which book specifically addresses database administration fundamentals?
Which book specifically addresses database administration fundamentals?
Signup and view all the answers
Where can students find the electronic copy of 'Database Administration Fundamentals'?
Where can students find the electronic copy of 'Database Administration Fundamentals'?
Signup and view all the answers
What year was the 3rd edition of 'SQL Queries for Mere Mortals®' published?
What year was the 3rd edition of 'SQL Queries for Mere Mortals®' published?
Signup and view all the answers
Which of the following ISBNs corresponds to 'Database Systems: A Practical Approach'?
Which of the following ISBNs corresponds to 'Database Systems: A Practical Approach'?
Signup and view all the answers
What is the purpose of the Additional Resources Folder mentioned?
What is the purpose of the Additional Resources Folder mentioned?
Signup and view all the answers
Which book was mentioned as a resource specifically focused on data manipulation in SQL?
Which book was mentioned as a resource specifically focused on data manipulation in SQL?
Signup and view all the answers
Which of these authors wrote 'Database Systems: A Practical Approach'?
Which of these authors wrote 'Database Systems: A Practical Approach'?
Signup and view all the answers
What is the primary relational database management system used in this module?
What is the primary relational database management system used in this module?
Signup and view all the answers
What percentage of the total module assessment is attributed to the assignment?
What percentage of the total module assessment is attributed to the assignment?
Signup and view all the answers
What is required to pass the module?
What is required to pass the module?
Signup and view all the answers
When is the submission deadline for the assignment?
When is the submission deadline for the assignment?
Signup and view all the answers
What is the structure of the coursework assessment for this module?
What is the structure of the coursework assessment for this module?
Signup and view all the answers
What type of resource is NOT explicitly mentioned as being provided?
What type of resource is NOT explicitly mentioned as being provided?
Signup and view all the answers
Which of the following is NOT an expectation from the students?
Which of the following is NOT an expectation from the students?
Signup and view all the answers
How long is the class test scheduled to be?
How long is the class test scheduled to be?
Signup and view all the answers
Study Notes
Introduction to Databases
- The module is about databases and how they are used in a digital world.
- The module is taught by Dr. Matthew Burns (full-time), Dr. Hanif Ullah (part-time), Dr. Naveed Khan, and Dr. Jose Santos.
- Attendance is mandatory. Laboratories are held on both Mondays and Fridays.
- This is a 200-hour module, including lectures, laboratories, and independent study.
Module Overview
- Data is information processed or stored by a computer, and may be in a variety of forms.
- Information is data with meaning and purpose.
- Knowledge is information placed in context.
- Databases are essential for organizing information, building knowledge, and making decisions.
- Databases are a fundamental part of computing and business.
- There was an estimated 16 Zettabytes (1021 Bytes) of data in the digital universe in 2017, and 90% of that was created in the past two years.
- There is a growing need for real-time data analysis to derive value from data.
Learning Outcomes
- Students will be able to explain database concepts, including design, implementation, manipulation, and management.
- Students will be able to apply models, processes, and techniques in the design and implementation of database systems.
- Students will be able to construct a database from a relational schema using a database management system, such as Microsoft SQL Server 2017 or Azure SQL Databases.
- Students will be able to perform basic data manipulation and information retrieval operations using SQL.
- Students will gain experience in using a commercial database management system.
Module Content
- Database Basics
- Data Models
- Query Processing in the Relational Model
- Data Management Issues
- Running SQL in Jupyter Notebooks
- Combining SQL and Python
Learning Resources
- Attendance at lectures and practicals is compulsory.
- Weekly homeworks are assigned, to help students prepare for the next week's class.
- The course is supported through Blackboard Learn, which includes additional resources such as a folder for laboratories.
- Online resources, such as books, blogs, videos, courses, and simulators, are also recommended.
Recommended Books
- Database Systems: A Practical Approach to Design, Implementation, and Management
- Database Administration Fundamentals, Exam 98-364
- Database Design for Mere Mortals®: A Hands-on Guide to Relational Database Design
- SQL Queries for Mere Mortals®: A Hands-On Guide to Data Manipulation in SQL
Module Assessment
- The module is assessed through coursework, specifically, Set Exercise and Assignment.
- Set Exercise: A 90-minute class test, individual assessment (40% of the final mark).
- Assignment: Design and implementation of a database, submission through a video screencast, individual assessment (60% of the final mark).
- Students must achieve a minimum of 40% in aggregate across coursework components to pass.
- Students are not required to pass each component separately.
Studying That Suits You
Use AI to generate personalized quizzes and flashcards to suit your learning preferences.
Related Documents
Description
Test your understanding of databases and their significance in the digital age with this quiz. Explore the key concepts, types of data, and the role of databases in organizing information and decision-making. This quiz will help reinforce your knowledge of the module and prepare you for further studies.