Botswana has always been one of those countries that has suffered the curse of proximity to...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Botswana has always been one of those countries that has suffered the curse of proximity to South Africa. The proximity to South Africa has led to a lot of reliance on South Africa for almost every commodity. This has led to the countries export bill being too big. The government of Botswana has over the years implemented many schemes and programmes to encourage local production to reduce this reliance on South Africa. Once of these programmes was the ISPAAD programme. Despite good intentions of the programmes and after huge sums of money has been disbursed, it has been concluded that the programme has not yielded great results since the country still import a lot of its food from South Africa with local production only accounting for a very small percentage of the total food consumed. The government has since decided to cancel the ISPAAD programme and replace it with a new programme. With the new programmes, the government wants to link the support it provides to farmers to production or total yield rather than assisting farmers for assistance's sake. To do this, the government wants to implement a computer-based system that would assist in the management of the programme. You are hired as a consultant to build such as system. You are told the system should perform the following functions: 1. Register farmers. (ID/Passport number, first name, last name, DOB, postal address, email address, phone number). The system should also capture details of a farmer's farm details including: location, size, number of hectors debushed or ploughable area. Please note that a farmer can have more than one farms. 2. Capture production data. There two types of production information: cropping and actual: a. Cropping - this is also referred to as planning information. For this, a farmer should be able to indicate how many hectors will be planted for each type of crop (sorghum, maize, and millet). Based on some formula and the number of hectors planted, the system should be able to estimate the expected yield (in tons) for each crop b. Actual - The system should allow a farmer to capture actual production information at the end of the season. This is the actual tons they produced per crop. c. They system should implement some reward scheme rewards farmers for good production. To make the rewards scheme fair, you could categorize farmers into small scale farmer, medium scale farmer, and commercial farmer. You can therefore set targets for each of these categories and then give rewards based on how well the farmers have met the targets within their group. Your Task 1. List all the Business rules that are applicable to the scenario described above. 2. Use tools you have learnt in this course to design the database that solves the problem described above. As a guide use the following: a. Relationship table b. Entity-Relationship Model: Develop a top down design of the data in the form of an entity-relationship diagram using crow's foot notation. You should note all assumptions you make about the data and the reasoning behind your design choices. Also include any appropriate constraints and list of entities types showing their attributes and identifiers. c. Normalize your database up to 3rd Normal Form: Once you are satisfied that the ER diagram is a good representation of the data, produce a logical design by mapping the ER to a set of normalized relations. Clearly show all intermediate steps. 3. Implement your final database using Microsoft SQL Server: Take each of the relations from your relational model and implement them in SQL Server using SQL commands - i.e. do not just create the tables using the Studio in design view. You must include all primary and foreign keys as well as any table or column constraints you deem appropriate. You must supply all SQL code in your report. You must also write insert statements to populate the database with sample data (make sure that these insert statements forms part of the code files that you will submit along with your report) 4. Query your database: Using SQL, write a set of realistic sample queries based on the above scenario (use your imagination for the details of the query) but they should include the following SQL query techniques: Joins (using two, three, or more tables) Set operations (UNION, INTERSECT, and MINUS) Ordering Grouping Aggregate functions (MIN, MAX, AVG, COUNT, SUM) Botswana has always been one of those countries that has suffered the curse of proximity to South Africa. The proximity to South Africa has led to a lot of reliance on South Africa for almost every commodity. This has led to the countries export bill being too big. The government of Botswana has over the years implemented many schemes and programmes to encourage local production to reduce this reliance on South Africa. Once of these programmes was the ISPAAD programme. Despite good intentions of the programmes and after huge sums of money has been disbursed, it has been concluded that the programme has not yielded great results since the country still import a lot of its food from South Africa with local production only accounting for a very small percentage of the total food consumed. The government has since decided to cancel the ISPAAD programme and replace it with a new programme. With the new programmes, the government wants to link the support it provides to farmers to production or total yield rather than assisting farmers for assistance's sake. To do this, the government wants to implement a computer-based system that would assist in the management of the programme. You are hired as a consultant to build such as system. You are told the system should perform the following functions: 1. Register farmers. (ID/Passport number, first name, last name, DOB, postal address, email address, phone number). The system should also capture details of a farmer's farm details including: location, size, number of hectors debushed or ploughable area. Please note that a farmer can have more than one farms. 2. Capture production data. There two types of production information: cropping and actual: a. Cropping - this is also referred to as planning information. For this, a farmer should be able to indicate how many hectors will be planted for each type of crop (sorghum, maize, and millet). Based on some formula and the number of hectors planted, the system should be able to estimate the expected yield (in tons) for each crop b. Actual - The system should allow a farmer to capture actual production information at the end of the season. This is the actual tons they produced per crop. c. They system should implement some reward scheme rewards farmers for good production. To make the rewards scheme fair, you could categorize farmers into small scale farmer, medium scale farmer, and commercial farmer. You can therefore set targets for each of these categories and then give rewards based on how well the farmers have met the targets within their group. Your Task 1. List all the Business rules that are applicable to the scenario described above. 2. Use tools you have learnt in this course to design the database that solves the problem described above. As a guide use the following: a. Relationship table b. Entity-Relationship Model: Develop a top down design of the data in the form of an entity-relationship diagram using crow's foot notation. You should note all assumptions you make about the data and the reasoning behind your design choices. Also include any appropriate constraints and list of entities types showing their attributes and identifiers. c. Normalize your database up to 3rd Normal Form: Once you are satisfied that the ER diagram is a good representation of the data, produce a logical design by mapping the ER to a set of normalized relations. Clearly show all intermediate steps. 3. Implement your final database using Microsoft SQL Server: Take each of the relations from your relational model and implement them in SQL Server using SQL commands - i.e. do not just create the tables using the Studio in design view. You must include all primary and foreign keys as well as any table or column constraints you deem appropriate. You must supply all SQL code in your report. You must also write insert statements to populate the database with sample data (make sure that these insert statements forms part of the code files that you will submit along with your report) 4. Query your database: Using SQL, write a set of realistic sample queries based on the above scenario (use your imagination for the details of the query) but they should include the following SQL query techniques: Joins (using two, three, or more tables) Set operations (UNION, INTERSECT, and MINUS) Ordering Grouping Aggregate functions (MIN, MAX, AVG, COUNT, SUM)
Expert Answer:
Answer rating: 100% (QA)
Your Task List all the Business rules that are applicable to the scenario described above 1 A farmer is defined as an individual who owns and cultivates land for the purpose of growing crops 2 A farm ... View the full answer
Related Book For
Cost Management Accounting and Control
ISBN: 978-0324559675
6th Edition
Authors: Don R. Hansen, Maryanne M. Mowen, Liming Guan
Posted Date:
Students also viewed these business communication questions
-
South Africa is home to huge reserves of coal, gold, diamonds, and natural gas. In addition to their intrinsic value, gold and diamonds have many industrial uses in which South Africa is the world...
-
It has been almost 15 years since Julia graduated with a major in aeronautical engineering, and now she makes buckets of money working as a project manager for a large defense contracting company....
-
It has been over 25 years since Julia graduated with a major in aeronautical engineering, and she has been quite successful in her career as well as in managing her personal finances. She has moved...
-
can you complete this concept map that reviews some key ideas about species and speciation logy with Lab Connecting the Concepts: Species and Speciation oncepts: Species and Speciation oncept map...
-
Suppose a population proportion is .40, and 80% of the time when you draw a random sample from this population you get a sample proportion of .35 or more. How large a sample were you taking? Discuss.
-
To invest or not to invest, what do you do? After analyzing the financial statements and thoroughly researching a company, you have realized that the firm has had zero interest-bearing debt (no...
-
Otis Carpenter opened a medical practice in Alexandria, Virginia. Requirement 1. Record the preceding transactions in the journal of Otis Carpenter, M.D., RC. Include an explanation with each entry....
-
The Easy Drive Car Rental Agency needs 500 new cars in its Nashville operation and 300 new cars in Jacksonville, and it currently has 400 new cars in both Atlanta and Birmingham. It costs $30 to move...
-
Does market failure and distributional equity reasons provide enough justification for government intervention in the production and distribution of goods and services? Directions Discuss areas where...
-
Jennifer Lee, an engineering major in her junior year, has received in the mail two guaranteed lineofcredit applications from two different banks. Each bank offers a different annual fee and finance...
-
An inverted T RC column is proposed. Its cross-section and reinforcement is shown in the sketch below. The concrete characteristic strength is to be fe' = 32 MPa. The column can be considered to be...
-
The things that might lead a person to quit might not be the same things that lead a person to stay with an organization. For example, another job offer or the tendency to always be looking for new...
-
Reread the Managers Notebook, High-Priced CEOs: Are They Worth It? Develop a list of arguments in favor of the position of Prof. Desai (that CEO pay is irrational) and a list of arguments in favor...
-
A serious barrier to employment of people with disabilities continues to be a perception problem. Managers and coworkers lack knowledge, awareness, and comfort in working with employees with...
-
This exercise asks you to explore your attitudes concerning illegal immigrants in the workplace. a. Would you work for an employer who makes it a point to hire illegal immigrants? Why or why not? b....
-
The director of HR has appointed you to a committee responsible for investigating allegations that reliance on internal referrals through social sites undermines the diversity efforts of the firm....
-
Which of the following is an example of law not enacted by an elected body? United States Code administrative regulations all of the above are enacted by an elected body state codes municipal law
-
Sundial Technologies produces and sells customized network systems in New Brunswick. The company offers a 60-day, all software and labor-and an extra 90-day, parts-only- warranty on all of its...
-
Wright Manufacturing has recently studied its order-filling process and initiated some changes that were expected to improve its efficiency. The changes involved such things as redesign of the plant...
-
Thorpe Company produces wireless phones. One model is the miniphone'a basic model that is very small and slim. The miniphone fits into a shirt pocket. Another model, the netphone, has a larger...
-
A local barbershop cuts the hair of male customers. The barbers offer no special styling. During the month of February, 1,500 haircuts were given. The cost of haircuts includes the following: Direct...
-
For the two-mass system shown in Figure 2.54 derive the equation of motion in terms of \(x_{1}\). Assume the pulleys are massless, the cable is inextensible, and let the spring constant be \(k\). The...
-
Derive the equation of motion and natural frequency for mass \(m\) shown in Figure 2.53. Assume the pulleys are massless, the cable is inextensible, and let the spring constant be \(k\). The...
-
Derive the equation of motion and natural frequency for the disk shown in Figure 2.56. Assume the disk is rolling without slip, and the cable is wrapped around the disk. y k eelle IG Position of the...
Study smarter with the SolutionInn App