Data Structure Form Complete the form according to your instructions. For detail
ID: 3790473 • Letter: D
Question
Data Structure Form
Complete the form according to your instructions. For details, please refer to the sample completed form provided separately. The spaces expand as you write.
Table Name:
Business Rules:
List all cardinality and modality rules that apply to this data structure, rules for primary /candidate key selection, de-normalization considerations, and so on. Remember the data structure is one that comes out of the business for your project.
Data Structure: (List only one per form.)
Table Structure:
For each field identified in the data structure, complete the information in the table below.
Tip: In the "Comments" column (far right), be sure to specify assumptions for cardinality, modality and referential integrity constraints as needed. See definition below.*
Column Name
Data Type
Allow Nulls?
Comments: (foreign key, constraints, default)
* Use the following definition of referential integrity constraint:
A constraint (rule) that specifies that the value or existence of an attribute in one relation depends on the value or existence of a primary key in another relation.
2 tables - patient/ physician - patient one physician and physician many patients.
student -teacher
teacher - many students
Example: Admitting Physician in Patient must exist in Physician.
Physical Design Issues:
Estimate number of records in table, number of updates and/or queries per unit of time, issues that affect physical design such as security, joins, applications that use tables, and so on.
Data Volume
(# Records)
Data Volatility
(# of accesses per time period, % update to read access)
Additional Considerations
(Response time, Security, Performance, Applications, etc.)
24,000
How many records read each day.
Password for security; maybe add indexes.
Tip: In the "Comments" column (far right), be sure to specify assumptions for cardinality, modality and referential integrity constraints as needed. See definition below.*
Explanation / Answer
The lists below are not exhaustive. Aircraft hire: Aircraft type, manufacturer, call sign, period of charter, charter costs (including hourly flying rate and the method by which the rate is calculated), detail and amount of work conducted (e.g. dispersant application, aerial observation, personnel or equipment transport etc.), number of flights conducted, dates, times and area(s) of operation, weather conditions, volumes of dispersant sprayed (if applicable), crew details and passenger details (including their role and responsibility in the response and reason for flying), cargo manifests (if applicable), equipment used (e.g. for spraying or observation), reports of observation (e.g. as submitted to the incident command centre), fuel consumed, crew accommodation and food costs, landing and other airfield charges. Please provide the logs of each flight conducted and any relevant charter agreements or call-up contracts. Vessel hire: Vessel name, registration number, specification (construction, length, power, storage capacity, crew), detail of the work undertaken (e.g. oil recovery, dispersant application, waste transport, etc.) equipment used (e.g. spray arms, skimmers, etc.) fuel and lubes, etc. consumed, charter period, charter/ freight cost, hire rate (and the method by which the rate is calculated), area and dates of operation (please refer to nautical charts and provide extract), weather conditions, amounts of consumables used (e.g. dispersant, sorbents, etc.), additional personnel and passenger details (including their role and responsibility in the response and reason for being on board), type and amount of waste or other cargo transported, demobilisation and cleaning costs, port charges. Please provide daily logs of each voyage conducted and any relevant charter agreements, contracts of affreightment or call-up contracts. Treatment of waste: Origin point of waste collected (e.g. beach name or chart reference), destination or delivery point of waste collected, method of transportation, type and volume or weight of waste transported per trip from waste collection point to destination, labour costs (hours worked, rates of pay), equipment used and hire rates (e.g. trucks, excavators, skips, etc.), temporary storage costs (if applicable), treatment type and costs, residual value of waste after treatment, method of calculation of costs. The establishment of a wildlife treatment centre: A detailed rationale for establishing treatment centre, and triage arrangements, location of wildlife treatment centre, details of area where oiled wildlife were collected (using maps, charts, photographs or video, summary of events), methodologies used to clean oiled wildlife, dates of work conducted, number of oiled animals treated, number of oiled animals successfully released back into the wild, labour costs (hours worked, rates of pay), travel, accommodation and living costs of personnel, equipment and material costs at wildlife centre (type of equipment used, rate of hire or cost of purchase, quantity used and period of use, e.g. sanitary equipment, holding pens, vehicles, etc.), centre running costs (heating, electricity, water, communications, etc.), cost of consumable materials (e.g. personal protective equipment, animal feed, etc.), residual value of equipment and construction materials etc. at termination of operation, contributions received from general public (including costs of campaign to raise funds, amounts raised and explanation of how money was used). Copies of any agreements or contracts for services and receipts, invoices etc. should be provided. Removal of oil from wrecks: A detailed rationale for undertaking the removal of oil from a wreck, including the likelihood of release of remaining oil from wreck (for example, because of damage to structure or corrosion, etc.) and stability of seabed at location of ship (e.g. supporting scientific and engineering data), quantity, type and composition of remaining oil on ship, details of the likely pollution damage and the likely environmental damage which would result from further release of remaining oil, extent to which areas most likely to be affected by a further release are vulnerable to oil pollution damage from both an economic and environmental point of view, the technical feasibility and likelihood of success of the operation (taking into account visibility, currents, the presence of other wrecks in the vicinity and whether the ship was at a depth at which operations of the kind envisaged
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.