Microsoft has developed the Active Directory Domain structure so that a central authority, called the __________, is the reposit
1 answer:
You might be interested in
Answer:
The scripts are:
1. SELECT * FROM planes
2. UPDATE planes SET YEAR = 2013 WHERE year IS NULL
3. INSERT INTO planes (Tailnum, Year, type, Manufacturer, Model, Engines, Seats) VALUES ('N15501',2013,'Fixed wing single engine', 'BOEING', 'A222-101',3,100,NULL)
4. DELETE FROM planes WHERE Tailnum = 'N15501'
Explanation:
1. SELECT * FROM planes
To select all from a table, use <em>select * from [table-name]. </em>In this case, the table name is planes
2. UPDATE YEAR = 2013 WHERE year IS NULL
To do this, we use the update query which is as follows:
<em>UPDATE [table-name] SET [column-name]= [value] WHERE [column] IS NULL</em>
So: the above query will update all YEAR column whose value is NULL to 2014
3. INSERT INTO planes (Tailnum, Year, type, Manufacturer, Model, Engines, Seats) VALUES ('N15501',2013,'Fixed wing single engine', 'BOEING', 'A222-101',3,100,NULL)
To insert is very straight foward.
The syntax is:
INSERT INTO [table-name] (column names) VALUES (values)
4. DELETE FROM planes WHERE Tailnum = 'N15501'
To do this, we use the update query which is as follows:
<em>DELETE FROM [table-name] WHERE [column] = [value]</em>
So: The above query will delete the entry in (3) above
Flowcharts are used as a prototype of an actual program.
First, I will write out the algorithm; which will be used as an explanation of the flowchart (see attachment for flowchart)
The algorithm is as follows;
1. Start
2. Get input for cost of a meal and cost of a drink;
3. Calculate the total cost for a meal and two drinks
4. Multiply the total cost of a meal and two drinks by 7, to get the weekly cost
5. Display the weekly cost
6. Stop
At the end of the algorithm/flowchart, the weekly cost is calculated and printed.
See attachment for flowchart
Read more about algorithms and flowcharts at:
