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.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

A key for this database is {Departure Time}. Enter a different key for the database. Airline Flight Number Gate Destination Departure Time FlyRight 221 34 Denver 08:27 JetGreen 222 13 Anchorage 08:43 JetGreen 199 22 Honolulu 08:46 JetGreen 322 34 Anchorage 09:36 FlyRight 122 33 Honolulu 09:45 FlyRight 323 22 Detroit 09:50 FlyRight 222 33 Denver 09:55 Key: { Ex: Gate
An Art Museum needs to keep track of its artwork and exhibitions. The museum has a collection of artwork. Each piece of art has a unique id [ArtID], an artist, year and title. Artwork is categorized by type. There are two types, paintings and sculptures. Paintings have a paintType and style. Sculptures have a material, height and weight. Artwork is frequently shown in exhibitions. Each exhibition has a unique name, startDate, endDate. A listing of the artwork displayed at an exhibition is also retained. Below is an E-R diagram for a database to help the Art Museum. Provide appropriate names for entities E1, E2, E3, E4 identifiers 11, 12, 13, 14 missing attributes and relationship cardinality RC1 and relationship type RT1. Start_date End_date E1 E1 11 RC1 PaintType Style E3 13 A1 Title Year A/ A A/ A/ A/ A/ A/ A/ A A/ A/ E2 12 A/ E2 E3 E4 11 12 13 14 A1 A2 RC1 RT1 RT1 A2 Height Weight E4 14 Activate Go to Settin
I have to create a database using python to show geographical points. Create a program the will create your database and insert at least five points. Use your own data, something like: 100, 200, 123, Main Campus 120, 133, 142, Montoya 153, 123, 322, Rio Rancho 133, 123, 143, STEMULUS Center 153, 142, 122, ATC Run your initialization code to create the database.
Create a new database using phpmyadmin (or any other method you choose). The database should have at least two tables: One table should be able to store the username and password of users for session management. Insert one record in this table for use later in the project. The second table should be able to store the articles written by the user. The only information we need for articles is the author (which would be a user of the system), the title of the article and the content of the article. The content field should be able to store at least a thousand characters. Insert one simple record in this table for use later in the project H4
A database has been designed to display a list of popular movies and also a list of actors acting in these movies. The relationship that would exist between the related tables would be: O many to many one to many O many to one O one to one
c# Create a small Sports database with two tables: Team and Athlete. The Team table should include fields for the type of team (e.g., basketball), coach's name (both last and first), and the season the sport is most active (S for spring, F for Fall, or B for both). The Athlete table should include fields for student number, student first and last names, and type of sport. Use the same identifier for type of sport in both tables to enable the tables to be related and linked. Populate the tables with sporting teams from your school. Write a C# program that displays information about each team, including the names of the athletes. The data base we have provided to us just need to know how to program it in with the other guidelines given.
For this week's assignment you will allow the user to add employee, view all employees, search employee by ssn, and edit employee information. Below this is what its supposed to look like when completed. I have also included what I started to do but I can't figure out how to add the search by SSN option or the edit employee option. If you can give me a step by step on how to do this in python I would greatly appreciate it.
import sqlite3 from sqlite3 import Error # Creates connection to sqlite in-memory database def create_connection(): """ Create a connection to in-memory database :return: Connection object """ try: conn = sqlite3.connect(":memory:") return conn except Error as e: print(e) # YOUR CODE HERE # Use sqlite3.connect(":memory:") to create connection object return conn # query to create the table table_sql = """ CREATE TABLE Horses ( id integer PRIMARY KEY NOT NULL, name text, breed text, height real, birthday text ); """ # query to insert data into the table ins_sql = """INSERT INTO Horses VALUES(1,'Babe','Quarter Horse',15.3,'2015-02-10'); """ # query to fetch all data from the table fetch_sql = """SELECT * FROM Horses;""" # creating db connection conn = create_connection() # fetching a cursor from the connection c = conn.cursor() # executing statement to create table c.execute(table_sql) # executing statement to…
SCENARIO:A database contains information about ticket reservations for movie performances. To make a reservation you must be registered as a user of the system. In order to register you choose a unique username and enter your name, address, and telephone number (the address is optional). When you use the system later, you just have to enter your username. In the system, a number of theaters show movies. Each theater has a name and a number of (unnumbered) seats. A movie is described by its name only. (In a real system you would, of course, store more information, such as actor biographies, poster images, video clips, etc.) A movie may be shown several times, but then during different days. This means that each movie is shown at most once on any day. You can only reserve one ticket at a time to a performance (if you want several tickets for the same performance you must make several separate reservations) and cannot reserve more tickets than are available at a performance. When you make…
Scenario and Database Model: InstantRide InstantRide is the new ride sharing application in the city and it has just started its operations. With the help of the InstantRide mobile application, the users request a ride with their location. Drivers and cars are assigned to the request; and then the driver picks up the user to ride their requested location. Information for the users, drivers and cars are stored in the database as well as the travel transactions. In the USERS table, information for the users are stored with their first name, last name and email: In the DRIVERS table, all the drivers in the InstantRide are stored with their name, driving license number and check and rating information: In the CARS table, all the cars in the InstantRide system are kept with the license plate, model and year: Finally, the transactions of the rides are stored in the TRAVELS table. For each travel, start and end time with location are stored. In addition, the involved driver, car and…
Need some help understanding this Python program that creates a new database named DSUCollege.db and calls 4 functions. The function named create_table will create a table in the DSUCollege.db database called students that has five fields: student_id, first_name, last_name, major, and gpa. The first_name, last_name, and major columns should be TEXT data types, the student_id column should be an INTEGER datatype and gpa should be a REAL datatype (link to SQLite Data typesLinks to an external site.). Before creating the table, add code to drop the table. After the table has been created, display a message that the table has been created successfully. The function named populate_table populates the students table with the following values: student_id first_name last_name major gpa 1111 Dave Grohl Music 4.0 2222 Belinda Carlisle Accounting 3.5 3333 Joe Elliot Computer Science 2.8 4444 Angus Young Accounting 2.1 5555 Susanna Hoffs Music 3.1 6666 Debbie Harry Computer…
ObjectiveTo develop a simple database application using modern programming tools.ToolsStudents can choose either one of the programming languages C++, C#, Java, and Python as their main development platform. They can also choose either one of the database management systems SQLite, MySQL, PostgreSQL, and Microsoft SQL Server.GuidelinesEach student should agree to work with one student from the class as a teammate. Otherwise, the student works alone and gets penalized by getting at most 75% of the project grade. Teams should work independently toward the same project goal. Each team has to prepare a report presenting all the details about the work done and the job division. The number of pages should not pass twenty.Description of the ProjectThe project is to develop a simple university management system. The application should let three different kinds of users to work, namely, the student, the instructor, and the faculty coordinator. Users should have the following functionalities in…