Database DesignAbstractDescription of domainDescription of the program and sample queries.Detailed RequirementsRelation or entities’ names and attributesLandscape: location, elevation, forest densityClimate: location, time, rainfall, temperature, wind, humidityAnimal: location, time, average number present per area of landLand cultivated: physical boundaries of plots of land under GMO cultivation, timeHerbicide Usage: plot of land, total herbicide used, season.GMO Crop Yield: plot of land, total crop yield, seasonGMO Contamination: percentage GMO plant, location of test siteHerbicide-resistant wild weeds: plot of GMO cultivated land, frequency of occurrenceSuperweed: frequency of occurrence, locationProject Problem statementDatabase DesignDatabase DesignCmpE 226 Practice Problems Practice Problem (10)________________________________________________________________________1. Design a database with at least 10-12 of tables or ((constraint tables. The constraint tables should use the full power of linear constraints. (For example, the equality constraint x =1 does not use the full power of linear constraints. So don ’t use only equality constraints in your database.)) The tables should contain areasonable number of tuples or (constraint tuples), not too few and not too many. 2. Prepare traditional class diagram for the following problems showing at least 10 relationships among the following object classes, including associations, aggregations, and generalizations. Show multiplicities in your diagrams. Your model should have 3-5 attributes and 3-5 operations per class. Use association and role names when needed. As you prepare the diagrams, you may add additional object classes.3. If you use MLPQ, find at least 4 iconic queries or sequence of iconic queries.Explain what they mean and write them down in the style of the examples in theMLPQ system manual. (Iconic queries are shown in Figure 1 MLPQ GraphicalInterface in the MLPQ Specifications, such as Intersection, Union, Difference,Max, Min, etc.)4. Find at least 4 SQL queries of each of the following kind: Basic, Aggregation, Sets,and Nested. (That is, a total of 16 queries.)________________________________________________________________________A solution to track spread of Genetically modified OrganismELITE226 TeamAbstract.............................................................................................................................................................3Description of domain......................................................................................................................................3Description of the program and sample queries...............................................................................................4Detailed Requirements.....................................................................................................................................4Relation or entities’ names and attributes.........................................................................................................5Landscape: location, elevation, forest density.............................................................................................5Climate: location, time, rainfall, temperature, wind, humidity...................................................................5Animal: location, time, average number present per area of land...............................................................5Land cultivated: physical boundaries of plots of land under GMO cultivation, time.................................5Herbicide Usage: plot of land, total herbicide used, season........................................................................6GMO Crop Yield: plot of land, total crop yield, season..............................................................................6GMO Contamination: percentage GMO plant, location of test site............................................................6Herbicide-resistant wild weeds: plot of GMO cultivated land, frequency of occurrence...........................6Superweed: frequency of occurrence, location............................................................................................6CMPE 226 Fall 2006 1Project Problem statementAbstractBiotechnology has lots of new and upcoming research being conducted on agriculturalproducts and lot of work has already been done in genetic engineering of agriculturalproducts. The goal of this program is to collect and analyze available information aboutcultivation of a particular genetically modified organism, its spread, and conditionsaffecting the spread. Information about area under cultivation, landscape, climate,animals affecting spread of seed and pollen, use of herbicides, crop yield, GMOcontamination, occurrence of superweeds, will be stored in our database.We propose to design a database to record and analyze the undesirable spread of aspecific genetically modified organism in the United States. We choose a crop that hasbeen engineered to tolerate a specific herbicide. Our database would contain available oreasily obtainable information related to the undesirable spread of this GMO crop.Description of domainBiotechnology is a relatively new and quickly growing area of research and development.Large biotech companies invest resources into developing agricultural products withcertain desirable properties. Modern technology allows scientists to take a desirable genefrom one organism and insert it into another organism, producing an organism that doesnot exist in nature. The so-called “first generation” of genetically-modified (GMO)agricultural crops has been engineered to either tolerate specific herbicides or resist pests.Such properties make it easier for farmers to grow these crops.The first GMO crop was marketed in the United States in 1996. Since then, cultivation ofGMO agricultural crops in the US has been rapidly expanding. Today the US producestwo thirds of the world’s production of GMO crops. Most of the corn, soybeans, andcotton cultivated in the US are from the genetically modified variety. Because the technology is relatively new and untested, many GMO crops have beenmarketed prematurely and are still considered unsafe and banned by many countriesoutside the US.
View Full Document
Unlocking...