Big Data Tech Linux Mint VM

In this week, we will cover the following topics: Optionality and cardinality. Types of relationships between different tables (one to many, many to one etc..). Keys: foreign keys and primary keys. Modelling time-dependent data. Physical design: data types and sequencing. … and will result in the following learning outcomes: An understanding of optionality and cardinality. An understanding of many-to-one, one-to-many kinds of relationships between data. Knowledge of how to accumulate time-relevant data into tables. An appreciation, from examples given, that databases are critical in the real world, e.g., for keeping freight systems in motion (and therefore our fridges stocked with food).

In this week, we will cover the following topics: What modelling is, and specifically what data modelling is. What data modelling involves in real-world situations (modelling cycle) Some visual design conventions used in relational database design. The language of sets … and will result in the following learning outcomes: An understanding of the general modelling cycle and how database designers might liaise with business clients. An appreciation for the fact that good design needs an good appreciation of the data domain, and the data in the domain. An understanding that of the mathematical language of sets. An appreciation that understanding this language will help inform database queries.

In this week, we will cover the following topics: Data: that you can design the structure of data, including the relationships between data. The important of being able to uniquely identify datum within a set of data. How to accumulate relationships between data, as data, stored in tables. A brief look at a real word set of data known as Codepoint, and the limitations. ‘Programming’: the distinction between declarative programming and algorithmic … and will result in the following learning outcomes: An initial appreciation that it is good to be systematic in how data is represented. That data ‘keys’ allow us to access specific datum. Knowledge that tables can be used to store data and relationships between data. That real-word data is available, but not necessarily perfectly organised. A feeling for the kind of programming relevant for database interactions.

In this week, we will cover the following topics: Data: what (and examples of where) it is. How data might be stored on a computer. Examples of where data might be useful. Spreadsheet data storage. Distinction between data and derived information. What databases are. What relational database systems are. How relational approach sits with other approaches to databases. … and will result in the following learning outcomes: An appreciation of what data is and how structured data can be stored. Knowledge that data is very important. An appreciation of how databases are different to more traditional data storage approaches. An understanding that relational databases, the focus of this course, are not the only kind of database that exist.