Describe a scenario in which a user assigned to role uses

Assignment Help Database Management System

Reference no: EM131826647

Problem

Imagine that you are the database administrator for a military transportation system. You have a table named cargo in your database that contains information on the various cargo holds available on each outbound airplane. Each row in the table represents a single shipment and lists the contents of that shipment and the flight identification number. Only one shipment per hold is allowed. The flight identification number may be cross-referenced with other tables to determine the origin, destination, flight time, and similar data. The cargo table appears as follows:

Flight ID	Cargo Hold	Contents	Classification
1254	A	Boots	Unclassified
1254	B	Guns	Unclassified
1254	C	Atomic bomb	Top Secret
1254	D	Butter	Unclassified

Suppose that two roles are defined: Role 1 has full access rights to the cargo table. Role 2 has full access rights only to rows of the table in which the Classification field has the value Unclassified. Describe a scenario in which a user assigned to role 2 uses one or more queries to determine that there is a classified shipment on board the aircraft.

Reference no: EM131826647

Questions Cloud

Confidence level would be higher : We are 95% confident that between 43% and 49% of Americans support the decision of the U.S. Supreme Court on the 2010 healthcare law.

Write command that would enable bruno to grant select access : Write the SQL commands that would enable bruno-s to grant SELECT access to these tables to hulk hogan and undertaker.

Determine the margin of error : Determine the margin of error for the 56% point estimate using a 95% confidence level.

Verify the margin of error reported : (a) Verify the margin of error reported by The Marist Poll.

Describe a scenario in which a user assigned to role uses : Describe a scenario in which a user assigned to role 2 uses one or more queries to determine that there is a classified shipment on board the aircraft.

Estimating the proportion of graduates at a mid-sized : Life after college. We are interested in estimating the proportion of graduates at a mid-sized university who found a job within one year of completing

Life rating in greece : Greece has faced a severe economic crisis since the end of 2009. A Gallup poll surveyed 1,000 randomly sampled Greeks in 2011 and found

Population of all high school seniors in the us : (a) Is this sample a representative sample from the population of all high school seniors in the US? Explain your reasoning.

Sample size and pairing : Determine if the following statement is true or false, and if false, explain your reasoning: If comparing means of two groups with equal sample sizes

User Account

All Pages