Assignment1 P1, CPSC5207E Virtualization and s24 v7

Open your text editor and create a new document named model.php model.php will contain functions that will connect to a database potentially return PDO statementobjects to the controller for processing. updateMessagesfunction updateMessages($id)This method will take a single parameter of id which is the saved id from the last or latest message displayed. It will conditionally select from the table “messages”, id, name, message, and time. The condition is that the field id is greater than the parameter for id. The return is the PDOStatement object with the row data from the query.

O Using the Customer database (Customer Database has one table Customer), Create Class Library Project (Please note use project for creating C# class library) that Handles the CRUD Operation of Customers Project Create Class Library Project should contain the following O O BussinessObject DataAccessLayer ■ ■ ■ BussinessLogic Layer ■ ■ Customer Class Properties of Customers Class should match the columns of Customers Table. Insert Customer Insert Stored Procedure Update Customer Update Stored Procedure Delete Customer Delete Stored Procedure Select Customer By customerld Select Customer By customerld Select All Customer Select All Customers DBHelper Class Add Customer Update Customer Delete Customer Select Customer By customerld Select All Customer Customer BussinessLogic DataAccessLayer DBHelper Customer Id FirstName MiddleName LastName Street City State Zip Add Update Delete GetCustomer GetAllCustomers Add Update Delete GetCustomer GetAllCustomer

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

please write with proper explanation. Question half solution is here please write what is main disadvantages of this approach? Half solve questions: Mutual Exclusion:   Mutex is an abbreviation for Mutual Exclusion. It is a programme object that prevents multiple users from accessing a shared resource at the same time. When a process accesses a shared variable, it is said to be in the critical section. When no two processes are present in the critical section at the same time, this is referred to as Mutual Exclusion or Mutex. while (true)       {           semaphore sem = S;           while (S <= 0) do no operation          {                 S = S-1;                wait (S);          }          /*critical section*/         while (S > 0)         {             S = S+1;             signal (S);         }         /*remainder section*/   }

task 2:   Mission 7: Patient Registry For this mission, we are developing a patient registry for the country-wide vaccination program. We have also been supplied with generated JavaDocs in the docs.zip file. To read them, we need only open the docs/index.html file in a compatible browser. Task 1: Planning Takes Patients For this task we will be creating an overview of the classes in our system using the Unified Modeling Language (UML) Class Diagram. IMPORTANT: When submitting this question, you must submit it as a Portable Network Graphics (PNG) file. Below is a list of tools for drawing UML diagrams, but you are free to use any program of your choosing: Google Drawings (https://docs.google.com/drawings/) PlantUML(https://plantuml.com/) Inkscape (https://inkscape.org/) Visual Paradigm (https://online.visual-paradigm.com/) You may use any tool you wish as long as your diagram follows the UML conventions and is in the correct format (PNG). Instructions IMPORTANT: Unless otherwise…

Enterprise architecutre. Please refer to the screenshot

Refactor your design so that it is easy to add a new rule to the system. Discuss your design in terms of GRASP patterns.

I may need help with this project: A combined cycle gas turbine power station requires a webbased system to manage the storage and installation of spare parts and the acquisition of new parts from the Central Storage Warehouse (the CSW). The powerstation maintains an inventory of all the parts it owns comprising: part name, description and specification. There are many copies of some parts – each part has a unique ID, known as an asset tag number. The asset tag number is used when there is damage to particular parts. The power station also keeps a catalogue of all the possible spare parts types used.Only registered maintenance engineers and team leaders are allowed to install and repair parts on the plant. Maintenance engineers and team leaders can use the parts catalogue tosearch for part types and can also search the parts inventory. Maintenance engineers work in teams, currently: electrical, mechanical and environmental. Each team has its own team lead. However, the system needs to…

1. You are asked to design a database for Banks. A bank will have one unique Code, Name andAddress. Banks will have multiple branches and each of those branches will be numbered (1,2..), first branch will be Number 1 for example and these will have an address of their own besides thebranch number. The Bank Branches will offer the option of creating accounts to customers, they willalso have the option of creating joint accounts. Customers will be able to open different accounts ineach of the bank branches. Account information will include the unique Account Number, TotalBalance and Account Type. The Bank Branches will also give Loans to Customers. Loans will haveunique Loan Number, Loan Amount and Loan Type. A customer can take multiple loans from acertain bank branch and banks can issue a number of different types of loans just like accounts. Thecustomer’s National_ID, Name, Phone and Address will be taken and stored. Using theseRequirements please construct an Entity-Relationship…

Task 1: Planning and Passengers For this task we will be creating an overview of the classes in our system using the Unified Modeling Language (UML) Class Diagram. IMPORTANT: When submitting this question, you must submit it as a Portable Network Graphics (PNG) file. Below is a list of tools for drawing UML diagrams, but you are free to use any program of your choosing: . Google Drawings (https://docs.google.com/drawings/) . Plant UML (https://plantuml.com/) • Inkscape (https://inkscape.org/) • Visual Paradigm (https://online.visual-paradigm.com/) You may use any tool you wish as long as your diagram follows the UML conventions and is in the correct format (PNG). Instructions IMPORTANT: Unless otherwise stated, all attributes should be private or protected. You may decide for yourself whether an attribute should be private or protected. Draw the UML class diagrams for the following classes: 1. An abstract Java class called Person that has the following attributes: a String called…

1. Develop a data manipulation application with a user-friendly JavaFX GUI for student's database (as shown in the ER diagram below). The user should be able to edit existing data and add new data to the database (obeying referential and entity integrity constraints). Allow the user to edit the database in the following ways: a) Add a new student. b) Edit the existing information for a student. c) Delete an existing student. d) Add a new course registration for a student. Student Registration Course id 1 studentid id name courseid major grade name semester room 2. Upgrade the application in Ql to provide an appropriate JavaFX to allow the user to perfom a query that is defined in a TextArea and the results will be shown in a Tableview. Sample predefined queries are: a) Select all students studying "Software Engineering" major. b) Select students who have excellent grades. c) Select all pass students in ascending order based on their names. d) For all students studying "Computer…

Assignment 1 University Library SystemIn this assignment you are going to implement your own version of university library system,The system will have two different sides , the first one is to help the librarian to do his job and the other side for admin to manage every one permissions in the system , so You should provide the following features in your system: Admin viewo Add/remove Studentso Add/remove librariano Add/remove other admins  Librarian viewo Add/Delete bookso Issue/Return bookso View bookso View Issued bookso Log in /log outo Search for the book(id/name) Simple backend for your system , You could use a file each row should represent item o Books File should be something like:Id , Book Name, Author Name, Available quantity, Issued Quantity 1,Oliver Twist, Charles Dickens,98,2In the previous the first row was the name of each column , you can do that orhandle it in your code , id =1 , Book Name =Oliver Twist ..Etc.  Tables neededo Books Id Book Name Author Name…

Make use of Windows Presentation Foundation (WPF) to develop a Stock Management System thatwill manage the items being stocked in a warehouse. The application has 3 modules named: Addproduct, List Product, and Print Bar Code.Add Product:This module is used for adding new products to the system. It will require some basic details likeProduct category, Product Name, cost price, selling price, quantity and bar code. The details willbe saved into a SQL database named StockSystemdb. One other interesting feature of this systemis the alert system.You can set a particular quantity for each item. Now a notification or alert will be given to the userif a particular item’s quantity gets below the set quantity. This will help the user in gettingnotifications of the items getting low in stock.List Product:This module lists all the items present in the database of the Stock Management System. It will haveoptions to edit the details of each item or delete a particular item from the list.Print Bar…