- ORDER BY название_стобца1 (либо номер, либо имя (после AS)), название_столбца2после имени столбца указывается ключевое слово ASC (по возрастанию) или DESC (по убыванию)
- IF(логическое_выражение, выражение_при_true, выражение_при_false)Разрешается вложенность
- SELECT author, MIN(price) AS Минимальная_цена, MAX(price) AS Максимальная_цена FROM book WHERE author <> 'Есенин С.А.' GROUP BY author HAVING SUM(amount) > 10;Лучше как можно больше использовать WHERE тк таким образом будут дальнейшие операции выполняться с меньшим объемом данных
- NOTANDORскобки важны тк приоритеты очень сильные BETWEEN (WHERE amount BETWEEN 5 AND 14;)IN (WHERE author IN ('Булгаков М.А.', 'Достоевский Ф.М.');)у этих выше приоритет
- - supplier providers multiple parts A part can only be provided by one supplier- a supplier provides multiple parts and a part can only be provided by one supplier
- Process of creating small, stable, yet flexible and adaptive data structures from complex groups of data and minimizes repeated data groups which makes it possible to use use a relational database model (RDBM) effectively.
- A collection of data organized to serve many applications at the same time by storing and managing data so that they appear to be in one location.
- Software as a service (SaaS), infrastructure as a service (IaaS) and platform as a service (PaaS)
- Comprises additional programs to handle, administrate and analyze the stored data.
- A one-to-one linkage (mapping) between General Ledger revenue accounts and CO revenue elements is established to permit the transfer of FI revenue information to CO.
- Rectangle : Entity (bike, plant)Cercle : Attribute (id, Color, capacity)Losange : Relation (is stored)- one and only one : 1- One or more, any number, optional : M or N
- Classify the valuated consumption of production factors of an enterprise within a controlling area. They provide information concerning the value flow and value consumption within the enterprise.
- Wave 1: Creating manageable data structuresWave 2: Web and content managementWave 3: Managing big data
- - More flexible data model- Easier to scale- Handle large volumes of unstructured and structured data
- - used to access and manipulate databases- Supports at least major commands (SELECT, UPDATE, DELETE, INSERT, WHERE)
- unique identifier for all the information in any row of a database table
- · Executives· Senior Management· Department Managers· Controllers· Cost Accountants
- Responsible for cost containment, not responsible for revenue generation
- 1. User interface we use different access opportunities2. Application logic components regarding our ERP system3. Large database where data is stored
- - Desire to grow- Changing business model- Need for advanced functionality- Too many business systems supporting processes - Problems such as exact financial performance, customers satisfaction, levels of inventory