An agriculture company has decided to develop a multimedia database system for their company so that they can manage the crop information easily. Here are the basic operations that the company has decided to be included in the system. i. The system should be able to register a new user ii. Registered users are allowed to login into the system iii. Users are able to search the agriculture product iv. Search items can be added into the cart v. Before leaving the system, users can check out and make payment through the system. a. Draw a use-case diagram for the system based on the stated requirements. b. Draw an activity diagram to visualize each operation relation for the system.

An agriculture company has decided to develop a multimedia database system for their company so that they can manage the crop information easily. Here are the basic operations that the company has decided to be included in the system. i. The system should be able to register a new user ii. Registered users are allowed to login into the system iii. Users are able to search the agriculture product iv. Search items can be added into the cart v. Before leaving the system, users can check out and make payment through the system. a. Draw a use-case diagram for the system based on the stated requirements. b. Draw an activity diagram to visualize each operation relation for the system.

Fundamentals of Information Systems

9th Edition

ISBN:9781337097536

Author:Ralph Stair, George Reynolds

Publisher:Ralph Stair, George Reynolds

Chapter3: Database Systems And Big Data

Section: Chapter Questions

Problem 16SAT

See similar textbooks

Similar questions

An objective of this task is to implement your own simple method of auditing the database activities.It is strongly recommended to connect to MySQL either through command line interface mysql or graphical user interface MySQL Workbench and process a script file dbdrop.sql and immediately after that the scripts dbcreate.sql and dbload.sql to refresh a sample database csit115.Download a file solution3.sql and insert into the file the implementations of the following actions.You must connect as a user root with a password csit115.Your implementation must directly follow a comment with a specification of a subtask.(1) First, the script makes a relational table that contains a general log empty.(2) Next, the script sets the appropriate values of the variables to save a general log in a relational table and to start recording a general log from now.(3) Next, the script makes a database csit115 a default database, it stops recording a report, it executes a script file updates.sql, and it…
EXPLAIN THE BELOW PYTHON AND DBMS CODE STEP BY STEP WITH TERMINOLOGY import osimport platformimport mysql.connectorimport pandas as pdimport datetimemydb = mysql.connector.connect(user='root', password='Arun@102003',host='localhost',database='food')mycursor=mydb.cursor() def MenuSet(): #Function Food Booking System print("Enter 1 : To Add Cutomer details") print("Enter 2 : For Food Order") print("Enter 3 : Exit") try: #Using Exceptions For Validation userInput = int(input("Please Select An Above Option: ")) #Will Take Input From User except ValueError: exit("\nHy! That's Not A Number") #Error Message else: print("\n") #Print New Line if(userInput == 1): Customer() elif (userInput==2): orderitem() elif (userInput==3): Food() elif (userInput==4): OrderFood() elif (userInput==5): View() else: print("Enter correct choice. . . ") MenuSet() def Customer(): L=[] c_name=input("Enter…
One of your (hipster) acquaintances thinks he has the next billion-dollar startup idea for an app: Pizza Delivery with Entertainment. He heard from other people that you are following the course on database management, and asks you to design the EER model. Afterwards, he will use the UML model to ask programmers to implement the app. He explains the basic functionality of the app as follows: customers can order pizzas from restaurants to be delivered to a specific address, and if they want to, they can choose a special “entertainment order”. When an order is an entertainment order, the delivery person stays with the customer after delivering the pizza and entertains the customers (e.g., by singing, making jokes, doing magic tricks, etc.) for a certain amount of time. Now follows a detailed explanation of the range of capabilities of the app: when people create an account for the app and become app users, they have to indicate their birthday and fill in their name and address. Every…
A database has 4 transactions, shown below.TID Date items_boughtT100 10/15/04 {K, A, D, B}T200 10/15/04 {D, A, C, E, B}T300 10/19/04 {C, A, B, E}T400 10/22/04 {B, A, D}Assuming a minimum level of support min_sup = 60% and a minimum level ofconfidencemin_conf = 80%:(a) Find all frequent itemsets (not just the ones with the maximum width/length) using the Apriori algorithm. Show your work—just showing the final answer is not acceptable. For each iteration show the candidate and acceptable frequent itemsets. You should show your work similar to the way the example was done in thePowerPoint slides.(b)List all of the strong association rules, along with their support and confidence values, whichmatch the following metarule, where X is a variable representing customers and itemi denotes variables representing items (e.g., “A”, “B”, etc.).x  transaction, buys(X, item1)  buys(X, item2)  buys(X, item3)Hint: don’t worry about the fact that the statement above uses relations. The point of the…
Your task is to develop a database, in order to keep information on all sales at a motorcycle dealership. The database will include information on motorcycles, salespeople, sales, and customers. We assume for simplicity that the dealership sells only new motorcycles and that all motorcycles are produced by the same manufacturer. Each kind of motorcycle is called a model, and it has a unique model number. For each model, you want to store also its name, engine size in cubic centimeters (cc) which is an integer number, and the date when this particular model was introduced. For each salesperson, you want to store their employee ID number, first name, middle initial, last name, and the date when the employee was hired. For each customer, you want to store a customer ID number, first name, middle initial, last name, address information (city, state, and zipcode), phone number (given in standard US format), and e‐mail address. Assume that you do not have a zip code table available. Each…
Q. Suppose we want to develop a browser-based training system to help people prepare for such a certification exam. A user can request a quiz for the system. The system picks a set of questions from its database, and compose them together to make a quiz. It rates the user’s answers, and gives hints if the user requests it. In addition to users, we also have tutors who provide questions and hints. And also examiners who must certify questions. List down the functional requirements of the above said system? Use Form based method for specifying “Make Quiz” functional requirement.
It's recommended that you begin with a database that is administered by a flight service and makes use of "snapshot isolation" to get the most out of this illustration. What if the airline's improved overall performance was not due to a serializable execution, but rather to a non-serializable one?
Your company has grown significantly, and suddenly there is a significant increase in the usage of file servers. All of the file servers are in close proximity to the clients, and you're adding many more, resulting in a big group of servers. The number of namespace servers has also increased in recent years. Your original setup utilized the default options for the referral ordering mechanism and polling, which were both enabled. What modifications should you think about making?
A sales system is built using Java. The database used is MySQL with the DB name 'Sales' and has a database structure which is illustrated with the following Class Diagram: *On attachment From the existing Data Class Diagram, please make one I. Database Create a 'Sales' Database using MySQL. Field ID using Auto Increment Enter data into the Customer and Product Tables as follows: Table Customer Customer_ID Customer_Name Customer_Add Int Char(150) Char(100) 1 EFGH, PT XYZ 2 FGHI, CV LMNO 3 DEFG IJKL 4 EFGH MNOP 5 GHIJ QRST Table Product Product_ID Product_Name Stock Int Char(50) Int 1 FFFF 2 2 GGGG 7 3 HHHH 8 4 IIII 6 5 JJJJ 5 II. GUI Create a Sales Order Form with the following attached mockup: *On attachment *Note due to language differences in the mockup: Tanggal means DateKode means CodeNama means NameTambah Item means Add ItemHapus Item means Delete ItemSimpan…
Create a flowchart of how a product is bought from a candy company and the manufacturing of products in the same candy company. It should feature processes that check for stock, the sale of it, and the manufacturing of it. We should be able to see the use of a centralized database.
PLEASE HELP ME WITH THIS WHOLE PYTHON PROGRAMME QUESTION USE Bivariate Barplots Activity 2: Create Sub DataFrames Create two separate DataFrames for Male and Female such that one DataFrame holds the information only of Male while the other DataFrame holds the information only of Female. [ ] # Create two separate DataFrames for Male and Female. # Print the first 5 rows in the Male DataFrame
A database must store an employee table consisting of 100000records each of which is 80byteslong. Answer the following questions by assuming these congurations/parameters: B = 512bytes,interblock gap size G = 128bytes, numberof blockspertrack = 256, numberof trackspersurf ace =400. The disk has 8 platters each with two heads (only one head can read at a time of all 16 heads),rotates at 7200rpm, has a track − to − trackseektime(m) of 1ms, s = 12ms, r = 4.16ms, andbtt = 0.03255ms. 1. How many records can be stored per block (blocking factor) using spanned and unspannedcongurations?2. What is the utilization (%) for the unspanned conguration?3. If the le is physically ordered, what is the average time in milli second to read a record ineach conguration?