and some More lab 9 For the last lab of the term, I want you to create a practical application for your database, in which you modify it in some way, for instance, taking a new order. Since the emphasis is on the database connectivity, neither a GUI nor a web application is required. In fact, a GUI would require x2go, which I don't have at home and you probably don't either. A web interface would need to be on osiris, I could figure out some way to try it out, I guess. There are also numerous security concerns. The applications should be easy for someone like a store employee or on-line customer to use. The most common operations, such as adding a customer or renting a tool, should be implemented. These Part 1 instructions now include how to use postgresql in C as well as Java and python. The important issue of transactions and commit status is addressed here. Some previous notes about web applications, and the PHP language [Previously I wrote] Now write one more program, that updates your database, or add this functioality to the program you have so far. For example, it could ask for your customer name (or code), display a list of products, and let you pick one to order some amount of. It may be a GUI or a normal stdin - stdout program. It should run as a single transaction, to be committed upon completion. See note about various languages. Tell me what you did

Assume a scenario of inventory management system where the store-keeper has to enter the inventory for new products which are not at all available in the database. Design a front- end using JavaFX and JDBC APIs to achieve this objective with the following specifications: JavaFX menu design: A control to enter product ID A control to enter product name A control to enter quantity A control to enter expiry date A control to store the content into the database Database Table design ● ● • A table which is available in a DB which has already stored the above mentioned data in appropriate data type. Query design Query to store the new product submitted by the store- keeper.

Code for the following: Web application is written using the MVC (Model, View, Controller) architecture Web application is written using object-oriented PHP programming, including classes for: Database Connection & Information Products table model Products table DB Products table controller Categories table model Categories table DB Categories table controller Web application includes 3 user interface pages: Index/landing/navigation page Title: "Your Name Wk 3 GP" Page Header: Your Name Product Information Includes navigation links to all other pages Filename index.php Database Connection Status page Title: "Your Name Wk 3 GP" Page Header: Your Name Database Status Includes: Text display of the database name Text display of the database user ID Text display of the database password Text display of the status of the connection (successful or unsuccessful) Navigation link to the home page Filename db_conn_status.php Products page (and Product Add/Update page) Title: "Your Name Wk 3…

I'm warning you don't use AI platform to generate an answer.

You are creating a database for storing information for a Netflix like service. The database stores movies with id, title, filename and TV shows with id, title. TV Shows have episodes. Each episode has a corresponding TV show, a season id, an episode id, title, filename. Some episodes have a next episode (i.e. the episode that will automatically start showing once the user finishes watching the current episode!). The database also stores users, each user has an id, username, password. Users may watch zero or more movies, zero or more TV show episodes. For each movie or episode, the database stores a watch time value for each user, indicating how many minutes the user watched that movie or show. Finally, the database stores which movie appears similar to which other movie for a given user (to be able to make recommendations). Construct an E-R diagram (based on a Chen's model) to represent the above requirements. Make sure you include all appropriate entities, relationships, attributes,…

Assumptions: You can make the following assumptions in this project. The database stores information about houses, each with a house ID, address, and zip code. The database stores information about person, including person ID, house ID where the person lives, person name, phone number, and status where 1 means currently tested positive (i.e., the most recent test result is positive), 0 means currently tested negative (i.e., the most recent test result is negative), and null (no test so far so status is unknown). The database stores information about a person's all past tests, including person ID, test date, and result (1 means positive and 0 negative). The database stores information about events (could be gathering, party, etc.). Each event has an event ID, event name, date, and address. The database stores information about a person participated in an event. The database stores information about flights, including flight ID, flight date, flight number (a varchar type e.g.,…

Create relational model

Create a BPMN model (1) (Application layer) of the following Application scenario: A housing system is run by the campus housing service which helps students find apartments. Apartment owners complete information forms (Add a rental unit/Delete Apartment) about the available/vacant rental units based on three criterions: (Distance from campus, Number of bedrooms, Monthly rent), which are then entered into a database. These criteria can be used individually or by any combination of the three. Students can Search Available Rental Units via the Web to find apartments that meet their needs (e.g., a two-bedroom apartment for $400 or less per month within 100 meters of campus) and contact the apartment owners directly to see the apartment and possibly rent it.

Exercise 2.8 Although you always wanted to be an artist, you ended up being an expert on databases because you love to cook data and you somehow confused database with data baste. Your old love is still there, however, so you set up a database company, ArtBase, that builds a product for art galleries. The core of this product is a database with a schema that captures all the information that galleries need to maintain. Galleries keep information about artists, their names (which are unique), birthplaces, age, and style of art. For each piece of artwork, the artist, the year it was made, its unique title, its type of art (e.g., painting, lithograph, sculpture, photograph), and its price must be stored. Pieces of artwork are also classified into groups of various kinds, for example, portraits, still lifes, works by Picasso, or works of the 19th century; a given piece may belong to more than one group. Each group is identified by a name (like those just given) that describes the group.…

I am creating a react app that connects to a mysql database, but for some reason it is not making the connection My code is shown below: const path = require("path"); const express = require("express"); const bodyParser = require("body-parser"); const errorController = require("./controllers/error"); //const db = require("./util/database"); const app = express(); var mysql = require("mysql"); var con = mysql.createConnection({   host: "localhost",   user: "root",   password: "COP4710", }); con.connect(function (err) {   if (err) throw err;   console.log("Connected!"); }); app.use(bodyParser.urlencoded({ extended: false })); app.use(express.static(path.join(__dirname, "public"))); app.use(errorController.get404); app.listen(3000);