How to Write a Summary of an Article? Unit 1, Business Administration Level2 Unit one:
Instapaper How important is database documentation to you? How much time will you spend trying to remember that purpose in seven months when a developer has a question about it?
Documenting a database and its objects when they are created can save you hours of work in the long run. There are many ways to create and store documentation.
You could create a spreadsheet for each database, with information about each table, view, and stored procedure — and update it manually.
Extended Properties Many objects in SQL Server — tables, filegroups, triggers, and more — have a mechanism for you to add properties to them beyond the built-in information such as names. Extended properties allow you to customize the information, storing the data within the database itself.
When you need to retrieve the information, you simply query it. Extended properties have been available since at least SQL Server How cool is that?
You can add extended properties to many — but not all — objects in SQL Server. Common items with the functionality are the database, schemas, tables, views, columns, constraints, functions, parameters, and triggers.
Less-used items such as service broker queues, partition functions and schemes, and plan guides can also be documented! The list of items you can add properties to is shown in Figure 1. For each schema in the database, you can document the purpose of it — was it to support application functionality, for readability, or for security?
If you have a column with a default constraint or a default value, document what it is and why if appropriate. Security Not just anyone can add or modify extended properties. There are four major parameters to this procedure — name, value, level type, and level name.
Name is just that — a name to describe the property.
The value is the description — what is this property for, and why are you adding it? The level type is a pre-defined value — refer back to Figure 1 for the values available. The level name is the specific object you are adding the property to — a plan guide name, a table name, an index name.
The highest-level property is the database. All other properties fall under this. Schemas, certificates, triggers, and plan guides are just a few examples. Then properties become nested.
Tables and views are level 1 properties, under schema. A few properties even are at level 2 — column is level 2, under table and view, for example. The syntax from Books Online is: First are the name and value.
Then, you see a type and name for each level — 0, 1, and 2. If you add a level 1 property, you add the level 0 and level 1 information. If you want a level 2 property, you enter information for all three levels.
There are no level types or names. The property is for a Schema, and the schema is Jes. This property documents the purpose of the schema — it holds information for one user, Jes. This is under the type Schema, and the schema name is Jes. Updating Extended Properties What if something changes?
Maybe a default value changes, or you want to add more information. This is very similar to adding — pass in the property name and the updated value, then the appropriate levels. RunDistance that I want to remove. The view returns a class, class description, major ID, minor ID, name, and value.
Then things start getting a little different. Most of the level 0 properties tie into a specific class. Rather than querying levels to find objects — the way we added the properties — we query for classes.Level 2 Certificate in Principles of Business Administration.
Level 2 Certificate in Principles of Business Administration. Best Practice Training & Development Transforming skills, careers and lives. Home; Menu. Unit 1: Principles of providing administrative services Unit 2. INTRODUCTION This unit is about preparing high quality and attractive documents to agreed layouts, formats, styles to meet agreed deadlines.
Outline different types of documents that may be produced and the different styles that could be used. Unit 1, Business Administration Level2 Unit one: Principles of personal responsibilities and working in a business environment Section 1 – Know the employment rights and responsibilities of the employee and employer 1.
That’s ugly, but let’s walk through it. First are the name and value. You’ll add these for every property. Then, you see a type and name for each level – 0, 1, and 2. Business and Administration Level 2 (Unit 1) Uploaded by.
Shaits Shaab. Business and Administration Unit one: Principles of personal responsibilities and working in a business environment Assessment You should use this file to complete your Assessment. The first thing you need to do is save a copy of this document, either .
Essay on Business Administration Level 2 Unit 1 Assesment More about Business and Administration Level 2 Unit 3 Assessment Essays. Business and Administration Level 2 Unit 2 Assessment Essay Words | 10 Pages; Essay on Business Administration Level 2 Unit 1 Assesment.