ER data model Design a schema that incorporates the specification described below as efficiently as possible....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
ER data model Design a schema that incorporates the specification described below as efficiently as possible. You should submit a written diagram of your schema design using the notation given in the class and/or the textbook. In this diagram, indicate all the classes, subclasses, relationships (weak & strong), attributes, and primary keys. If you feel you need to make additional assumptions, state them clearly on a separate page. Application Domain Introduction Geotechnical information on soil deposits is critical for our civil infrastructure. Local, state and federal agencies, universities, and companies need this information for a variety of civil engineering and urban policies applications, including land usage and development, and mapping of natural hazards such as soil liquefaction and earthquake ground motions. Foremost examples of geotechnical information, geotechnical boreholes are vertical holes drilled in the ground for the purpose of obtaining samples of soil and rock materials and determining the stratigraphy, groundwater conditions and/or engineering soil properties. In spite of rather costly drilling operations, boreholes remain the most popular and economical means to obtain subsurface information. These type of data range from basic borehole logs containing a visual inspection report of soil cuttings to sophisticated composite boreholes combining visual inspection and in-situ, laboratory geotechnical and geophysical tests. Design Specification The following is a description of the information required for a database system that manages data for Alabama Department of Transportation (ALDOT, http://www.dot.state.al.us/). We will refer to this as the ALDOT Database. ALDOT is in charge of many geotechnical projects around the State of Alabama. Geotechnical project data is the primary components of the ALDOT Database. A project has a project ID for identifying these projects, a brief title for describing the project, a project start date, a project end date, and a project creation date. Usually, a project contains several different experiments and the experiment data represents a particular experiment that is part of a project. It includes information that applies to the experiment as a whole, but may vary from one experiment to another. Zip code regions are widely used in civil engineering for identifying locations as well as recording information about the population. Each zip code boundary is defined by a 2-D polygon area. Each experiment is conducted in a specific area, which is usually represented by zip code region(s). Each experiment also has an experiment ID for identifying the experiment, a brief title for describing the experiment, an experiment start date, an experiment end date, and the organization that conducted the experiment, which includes its name and address (street, city, state, and zip code). ALDOT hires engineers in several different specialties: civil engineering, computer science, and geoscience. These scientists and engineers' personnel data are also managed by the ALDOT Database and the personnel data include information on any individual who participates in an ALDOT project. Note that each person will have at least one role (principal-investigator, project manager, assistant, and field engineer) with respect to each project he/she participates in. The people who are involved in projects have three different professional titles: civil engineer, field operator, and computer specialist. The information about a civil engineer's field of expertise, a field operator's experience (in years), and a computer specialist's computer skills are also included in the personnel data. A person has a social security number, a last name (surname of this person), a middle name, a first name, an address (street, city, state, and zip code), a phone number, date of joining the project, and an email. Employees of ALDOT ordinarily carry out several missions for an experiment. The mission data represents a particular configuration or steps used in conducting some portions of an experiment. There may be multiple missions for a given experiment. A mission has a mission ID for identifying this mission in a specific experiment, a brief title, a mission start date, a mission end date, and a number of ALDOT employees who work on the mission. ALDOT owns various engineering vehicles and construction equipment. The usages and status of all the vehicles and equipment are controlled by the ALDOT Database. The database tracks machines such as excavators, bulldozers, cranes, centrifuges, and drills, which are used for accomplishing the experiments. Excavators have different bucket sizes, bulldozers have different horsepower, cranes have different boom lengths, centrifuges have different motor power, and drills have different diameters. Vehicle(s) and equipment are associated with the particular mission(s) where they are used. Each vehicle has a vehicle identification number (VIN), a price, and an administrator. Equipment has an ID for identifying each equipment, a name, and a short description of the equipment functionality. For each mission a collection of boreholes are drilled. A borehole has a borehole ID that is unique among all the boreholes of one experiment, the depth of the borehole, the location of the borehole, a drill date, and a testing type (CPT, SPT, etc.). For each borehole the database also records the soil layer data (encountered while drilling the borehole); each layer information contains a unique layer ID, start depth, end depth, and soil type. ALDOT finances its operations through commercial banks. The banking system provides two kinds of accounts for ALDOT: personal accounts and business accounts. Each bank has a unique routing number, name, address and several phone numbers. Each account has a unique account number, balance and owner name. Each person working in ALDOT has one or more personal accounts. Banks also provide funding for projects through ALDOT business accounts. Each project may receive several funding transactions (called funds), each fund has the amount information, start date, and end date. ojo Firstname lastName Book No Reg no name Issue/Return name Staff id Email Phone no User_id User ID Reports N Manages 1 Address Staff Keeps track of Readers M N IN THIS FORMAT FOR YOUR DIAGRAM N Login ReserveDate eserve/ returi date return date maintain 1 N Password N Due date Authentication system Loginid Publishes Books Auth No ISBN Publisher Title Publisher id earOfPublication Price name Category Edition ER data model Design a schema that incorporates the specification described below as efficiently as possible. You should submit a written diagram of your schema design using the notation given in the class and/or the textbook. In this diagram, indicate all the classes, subclasses, relationships (weak & strong), attributes, and primary keys. If you feel you need to make additional assumptions, state them clearly on a separate page. Application Domain Introduction Geotechnical information on soil deposits is critical for our civil infrastructure. Local, state and federal agencies, universities, and companies need this information for a variety of civil engineering and urban policies applications, including land usage and development, and mapping of natural hazards such as soil liquefaction and earthquake ground motions. Foremost examples of geotechnical information, geotechnical boreholes are vertical holes drilled in the ground for the purpose of obtaining samples of soil and rock materials and determining the stratigraphy, groundwater conditions and/or engineering soil properties. In spite of rather costly drilling operations, boreholes remain the most popular and economical means to obtain subsurface information. These type of data range from basic borehole logs containing a visual inspection report of soil cuttings to sophisticated composite boreholes combining visual inspection and in-situ, laboratory geotechnical and geophysical tests. Design Specification The following is a description of the information required for a database system that manages data for Alabama Department of Transportation (ALDOT, http://www.dot.state.al.us/). We will refer to this as the ALDOT Database. ALDOT is in charge of many geotechnical projects around the State of Alabama. Geotechnical project data is the primary components of the ALDOT Database. A project has a project ID for identifying these projects, a brief title for describing the project, a project start date, a project end date, and a project creation date. Usually, a project contains several different experiments and the experiment data represents a particular experiment that is part of a project. It includes information that applies to the experiment as a whole, but may vary from one experiment to another. Zip code regions are widely used in civil engineering for identifying locations as well as recording information about the population. Each zip code boundary is defined by a 2-D polygon area. Each experiment is conducted in a specific area, which is usually represented by zip code region(s). Each experiment also has an experiment ID for identifying the experiment, a brief title for describing the experiment, an experiment start date, an experiment end date, and the organization that conducted the experiment, which includes its name and address (street, city, state, and zip code). ALDOT hires engineers in several different specialties: civil engineering, computer science, and geoscience. These scientists and engineers' personnel data are also managed by the ALDOT Database and the personnel data include information on any individual who participates in an ALDOT project. Note that each person will have at least one role (principal-investigator, project manager, assistant, and field engineer) with respect to each project he/she participates in. The people who are involved in projects have three different professional titles: civil engineer, field operator, and computer specialist. The information about a civil engineer's field of expertise, a field operator's experience (in years), and a computer specialist's computer skills are also included in the personnel data. A person has a social security number, a last name (surname of this person), a middle name, a first name, an address (street, city, state, and zip code), a phone number, date of joining the project, and an email. Employees of ALDOT ordinarily carry out several missions for an experiment. The mission data represents a particular configuration or steps used in conducting some portions of an experiment. There may be multiple missions for a given experiment. A mission has a mission ID for identifying this mission in a specific experiment, a brief title, a mission start date, a mission end date, and a number of ALDOT employees who work on the mission. ALDOT owns various engineering vehicles and construction equipment. The usages and status of all the vehicles and equipment are controlled by the ALDOT Database. The database tracks machines such as excavators, bulldozers, cranes, centrifuges, and drills, which are used for accomplishing the experiments. Excavators have different bucket sizes, bulldozers have different horsepower, cranes have different boom lengths, centrifuges have different motor power, and drills have different diameters. Vehicle(s) and equipment are associated with the particular mission(s) where they are used. Each vehicle has a vehicle identification number (VIN), a price, and an administrator. Equipment has an ID for identifying each equipment, a name, and a short description of the equipment functionality. For each mission a collection of boreholes are drilled. A borehole has a borehole ID that is unique among all the boreholes of one experiment, the depth of the borehole, the location of the borehole, a drill date, and a testing type (CPT, SPT, etc.). For each borehole the database also records the soil layer data (encountered while drilling the borehole); each layer information contains a unique layer ID, start depth, end depth, and soil type. ALDOT finances its operations through commercial banks. The banking system provides two kinds of accounts for ALDOT: personal accounts and business accounts. Each bank has a unique routing number, name, address and several phone numbers. Each account has a unique account number, balance and owner name. Each person working in ALDOT has one or more personal accounts. Banks also provide funding for projects through ALDOT business accounts. Each project may receive several funding transactions (called funds), each fund has the amount information, start date, and end date. ojo Firstname lastName Book No Reg no name Issue/Return name Staff id Email Phone no User_id User ID Reports N Manages 1 Address Staff Keeps track of Readers M N IN THIS FORMAT FOR YOUR DIAGRAM N Login ReserveDate eserve/ returi date return date maintain 1 N Password N Due date Authentication system Loginid Publishes Books Auth No ISBN Publisher Title Publisher id earOfPublication Price name Category Edition
Expert Answer:
Related Book For
Applied Regression Analysis and Other Multivariable Methods
ISBN: 978-1285051086
5th edition
Authors: David G. Kleinbaum, Lawrence L. Kupper, Azhar Nizam, Eli S. Rosenberg
Posted Date:
Students also viewed these computer network questions
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
An investor creates an investment portfolio from stock A and stock B where she invests 0.5 of her wealth in stock A and 0.5 of her wealth in stock B. Stock A has a beta of 1.39 and stock B has a beta...
-
Its a nursing assignment based upon the communication skill of the nurses will respond to the situation and to the circumstances. You need to answer in the blank spaces Aim: Knowledge Evidence: The...
-
Three charged pellets are arranged along a line. Three hypothetical closed surfaces are drawn around this set of three pellets. The three surfaces have identical cylindrical walls but different top...
-
Adamson and Baker formed a partnership by investing \($220\) 000 and \($180\) 000 respectively. The partnership had a final profit of \($92\) 000 in the first year. Required a. Prepare the journal...
-
Bennett acquired 70 percent of Zeigler on June 30, 2014, for $910,000 in cash. Based on Zeiglers acquisition-date fair value, only one unrecorded intangible of $400,000 was recognized and is being...
-
123456 7 8 Define plant location. Define product layout and process layout. What are the methods of production? Define work study. What do you mean by method study and time study? Explain inventory...
-
The MFG Corporation is planning to produce and market three different products. Let x1, x2, and x3 denote the number of units of the three respective products to be produced. The preliminary...
-
As controller for Henderson, you are attempting to reconstruct and revise the following balance sheet prepared by a staff accountant. Henderson Manufacturing Company Balance Sheet December 31, 2024...
-
Consider an MXN pixel gray-scale image f(x, y) with the image intensity given below: y =yo, 0 xM-1 f(x, y)= otherwise where c is a constant between 0 and 255 and yo is a constant between 0 and N -1....
-
Let f(x) = 12 ln(x). Then f'(x) is and f'(5) is f'(x) is and f''(5) is
-
The gene for curled wings (C/c) is located nearly at the end of the long arm of chromosome 2 of Drosophila, while the gene for smooth abdomen (S/s) is nearly at the end of the short arm of the same...
-
The two purely black and white images shown above are each 80 x 80 pixels. Each image contains an equal number of black and white pixels, which are represented using 8-bit grayscale intensity levels....
-
Consider a 2 m long shaft held rigidly between two walls. The shaft is loaded by a torque 20 kN-m = 20000 N-m at its center (point B) as shown. Between A and B the shaft is a hollow steel sleeve (G=...
-
Before you change from one tapered-shank drill bit to another, make sure to Clean the chips from the shank and spindle Lubricate the spindle shank Remove the old bit with a file Sand any nicks or...
-
The text defined intrinsic value as the value of an asset given a hypothetically complete understanding of the assets investment characteristics. Discuss why hypothetically is included in the...
-
A team of environmental epidemiologists used data from 23 counties to investigate the relationship between respiratory cancer mortality rates (Y) for a given year and the following three independent...
-
Repeat Problem 9 using LN_BLDTL as the dependent variable. Problem 9 This problem involves data from Problem 15 in Chapter 5. Treat LN_BRNTL as the dependent variable and dosage level of toluene...
-
Use the results from Problem 4 in Chapter 8, as well as the computer output given here, to answer the following questions about the data from that problem. a. Conduct the overall regression F test...
-
An air compressor has eight stages of an equal pressure ratio of 1.4. The flow rate through the compressor and the overall efficiency are 40 \(\mathrm{kg} / \mathrm{sec}\) and \(92 \%\),...
-
Discuss the assumptions and advantages of multistage compression.
-
A double acting, single cylinder, reciprocating air compressor has a piston displacement of \(0.014 \mathrm{~m}^{3}\) per revolution, operates at \(600 \mathrm{rpm}\) and has a \(4 \%\) clearance....
Study smarter with the SolutionInn App