DATA MODEL in QSEE/MySQL workbench 2. Spreadsheet, containing data (un-normaliz

DATA MODEL in QSEE/MySQL workbench
2. Spreadsheet, containing data (un-normalized and normalized)
3. HTML and PHP code
4. Website allowing queries of MySQL database: Appearance and Functionality
Broadly speaking, the assignment requires you to design and implement a web-based information
system.

Website development refers to the process of creating and maintaining websites.

Website development refers to the process of creating and maintaining websites. It involves a combination of technical and creative skills to build, design, and manage the various elements that make up a website. The goal of website development is to create a functional and visually appealing online presence that serves a particular purpose, such as providing information, selling products or services, or facilitating communication.
Here are key components of website development:
Planning: Before any coding or design work begins, it’s essential to plan the website’s structure, features, and functionality. This includes defining the target audience, creating a sitemap, and outlining the content and features the site will include.
Domain Registration and Hosting: A domain name is the web address users will use to access your site (e.g., www.yourcompany.com). Hosting involves renting server space to store your website’s files and make it accessible on the internet.
Front-End Development: This aspect of development involves creating the user interface and the visual elements of the website. It includes using languages such as HTML (Hypertext Markup Language), CSS (Cascading Style Sheets), and JavaScript to structure content, define styles, and add interactive features.
Back-End Development: The back end is the behind-the-scenes functionality that powers the website. It involves server-side scripting, database management, and server configuration. Common back-end languages include PHP, Python, Ruby, and Node.js.
Database Management: Many websites store and retrieve data from databases. Database management involves organizing, storing, and retrieving this data efficiently. Common database systems include MySQL, PostgreSQL, and MongoDB.
Content Management System (CMS): A CMS is a software application that allows non-technical users to manage and update website content easily. Popular CMS platforms include WordPress, Joomla, and Drupal.
Testing: Before launching a website, it’s crucial to test its functionality across different browsers and devices to ensure a consistent and reliable user experience. This includes checking for broken links, testing forms, and verifying that interactive features work as intended.
Deployment: Once the website has been thoroughly tested and is ready for public access, it is deployed to the web server. This involves uploading all the necessary files and configuring the server settings.
Maintenance and Updates: Websites require ongoing maintenance to ensure security, fix bugs, and update content. Regular updates may also be needed to incorporate new features or improve performance.
Website development can be done by individual developers or teams of professionals, and it often involves collaboration between designers and programmers to create a seamless and effective online presence.

What is web design?Web design refers to the process of creating and designing we

What is web design?Web design refers to the process of creating and designing websites, encompassing aspects such as layout, graphic design, color scheme, fonts, and overall user experience.
What are the key principles of good web design?Key principles include simplicity, consistency, readability, visual hierarchy, and effective use of color and imagery.
What is the difference between UX and UI design?User Experience (UX) design focuses on the overall user journey and satisfaction, while User Interface (UI) design deals with the visual elements and interactive components of a website or application.
What is responsive web design?Responsive web design is an approach to design that makes web pages render well on a variety of devices and window or screen sizes, ensuring a consistent user experience.
What is the importance of mobile-first design?Mobile-first design prioritizes designing for smaller screens like mobile devices first and then scaling up to larger screens. This is crucial as more users access websites on mobile devices.
Explain the concept of wireframing in web design.Wireframing is the process of creating a skeletal structure of a website, outlining the basic layout and placement of elements without focusing on design details. It helps in planning the structure and functionality of a site.
What is the role of color in web design?Color plays a crucial role in conveying emotions, establishing brand identity, and guiding user attention. It should be used strategically to enhance the overall user experience.
What is a content management system (CMS) in web design?A Content Management System is a software application that allows users to create, edit, and manage digital content on a website without needing advanced technical skills. Examples include WordPress, Joomla, and Drupal.
Why is website navigation important?Intuitive navigation is essential for a positive user experience. It helps users find information easily, improving engagement and reducing bounce rates.
What is the significance of web accessibility in design?Web accessibility ensures that websites are designed and developed to be usable by people with disabilities. It involves considerations for factors like screen readers, keyboard navigation, and alternative text for images.
Feel free to ask if you have more specific questions or if you’d like more detailed information on any of these topics!

TASK 6: Presentation  Each presentation must be 10 minutes in length only. Deli

TASK 6: Presentation
 Each presentation must be 10 minutes in length only.
Deliverables
 Once your product is final, show it to your tutor and get the feedback of your product and improve your product based on the feedback given by the tutor.
 After the development and submission of the above design, submit and present a reflection report outlining the methods you used in your production. The report structure is given at the rest of this coursework paper.
 Upload your report to Turnitin and submit the graphics folder to the link provide by your tutor.
 Any citations and references should be done using the Harvard Style of Referencing.
 The quality of your work will be carefully assessed (Please see marking scheme and marking criteria)
3. Some points about Graphics Implementation
You should design/collect the images/videos/logos to support the building of your product and then to combine all those graphics and other interactive screens to produce a meaningful required final product. Here are some points about graphics Implementation:
 Collection of still images /videos /interactive product material
 Use of your own taken images gets more marks
 Create some composite images (collages or other) that make use of layers in Photoshop
 Imaginative use of filters, feather selections, and other Photoshop edits
 Combining images /videos /interactive screens to produce the final product.
 Animation of text and/or objects (movement: sizing, visual effects such as fade-blurs, etc.), in interactive or video or banner products.
 The design of the web pages is important.
 Appropriate use of Screen fonts are one of the points that must be considered in designing multimedia products, besides margins, font animations and readability of texts.

I have a project on web subject and I need help. What is required is to use html

I have a project on web subject and I need help. What is required is to use html, css, javascript, PHP, and MySQL. The project is very simple, but I don’t have enough time for it.
The idea of the project is to choose a problem specific to the university. We chose the problem (car parking in front of the university building) and created a website consisting of 4 pages (including the content page, etc.).
you can search for ideas using AI, just for more help.
Text me if you want more information about the project.
Thank you.

Java Programming Language In this 2-hour video, we will cover the entire Java pr

Java Programming Language
In this 2-hour video, we will cover the entire Java programming language starting from basic installation to advanced programming concepts. This video is for all students who are starting out in the world of coding and programming, or who know languages like C or Python and want to learn Java. After watching this video, you will be able to apply many concepts and code using Java and even create a mini-project using the concepts you have learned. We hope this course helps you learn Java and apply your knowledge to real-world projects.
We have already created a course with over 200 videos on C programming, and a web development course where we covered HTML, CSS, and JavaScript. We will also provide notes at the end of the video that you can use as a reference to learn about the technologies you are interested in learning. For these technologies, you can refer to those courses.
Java Extension and Java Class
In Java, an extension is represented by a Java file. Within this file, there is a Java class with some code that represents a function. A function in Java is a block of code that performs a specific task that is important. We are happy to provide a guide to all Java programming and Java. We hope to help students learn about Java and learn more about the language that we are comfortable with using Java. You can also use Java programming. We will be happy to share your knowledge of Java and our knowledge.
In Java, a function is a block of code that performs a specific task, such as pressing the volume button on a phone increases its volume. The syntax for printing to the console is System.out.println in Java. Semicolons are used to indicate the end of a line of code, just like a period at the end of a sentence in English. In Java, we use types to indicate what kind of variable we are creating, whether it is a name, character, or a number, we are using a type of variable.
Primitive and Non-Primitive Types
The primitive types include byte, short, int, long, float, double, char, and boolean. The primitive types are used for simple values, and a type such as age with a type like age with the type of age with an age. The type of variables and a number that is a number is a type of string, or a string number.
Non-primitive types include String, which is a collection of characters to form a word or sentence. The length of a primitive type is fixed and within the byte range of 128 to 127, we can store any number. If we have a variable of reference type, we can store as many characters as we want without getting an error, as long as we don’t exceed the available memory. We will discuss this in more detail later on.
New Keyword and Length Function
We will use the new keyword to declare non-primitive or reference types. Using the new keyword when we use it to create an instance of a class. To print the length of the name variable, we can use the length function by typing name.length.
To assign a value such as true or false to a variable called isAdult, we can use a type of boolean. To assign a number such as a value to a variable, we use the type of the variable. To write a string to a string, we use a new type to read the length and read a new name to read the string. We have a new value, we need to use the type to read and write the new name length. We should use the name.length to provide a new message and identify a new object.
Introduction to Java
Java is a zero-indexed language, meaning positions start from zero and not one.
We can assign a string to a variable and then use that variable to manipulate the string. We will use the “new String” keyword to avoid errors in our code when we don’t use it.
The `charAt` function allows us to access the first position of the string and which character is stored at which position is present. The `length` of a string is the number of characters in the string. We can replace any character with another character at that position.
Strings in Java are immutable, which means once you have created a string inside Java, you cannot change it. If you want to change it, then you will have to create a new string.
Manipulating Strings
The `subString` method is used to return a new string that is a substring of the original string. It takes two parameters: starting index and ending index.
The `length` function is used to find out the number of characters in our own string. We will also use this function to replace the length. It is a function to remove any character from the original string.
Arrays in Java
If we want to store the marks of three subjects, then we need to create an array with three memory locations in which we can store the values of int type.
The first function of two important functions of arrays is `length`. If we want the length of a list of an array, then we can get it. Along with that, we have an important function `sort`. If we want to sort a list, then we write a function `sort

Tasks: First, watch the following tutorials: Google Sites Demo Produce a websit

Tasks:
First, watch the following tutorials:
Google Sites Demo
Produce a website and publish it so it can be viewed on the internet. The topic and content is up to you. Choose something that interests you or relates to your future goals. Take the opportunity to present something you already know or learn about something new. Complete the following steps:
Decide on a purpose / topic for your website and target users (i.e., entertainment, display a talent, instructional, motivational, sales) .
Use a free online website maker of your choiceFor example:Google sites (included in the Google Suite of your CSU email account)
Wix
Weebly
WordPress
Site123
Amazon (more complicated and manual possibly than some)
Your site should have at least four pages (e.g., About Us, Products, Services, Contact Us, Pictures, Projects…)
Include a navigation menu so a visitor can easily move from page to page
Include at least four different and distinct images throughout the site or on one pageYou can use your own images or any free images and clip-art found on the Internet. Be careful to observe copyright rules. (Check out this article: Find Copyright-Free Images
You can use Paint or Photoshop to crop and save an image as JPEG, JPG or PNG files for the web. Saving for the web means compressing the image to smaller file size, so it will download quickly
Include at least 5 hyperlinks to sites that you find interesting
Include a form on your sitethe form can be a registration form or email signup
include fields to enter at a minimum:First name
Last name
Email address
Comments
Thank you page upon submission
Publish the site (while you are creating and editing a site it is typically not viewable by others.) Find out what steps you need to take to make your website public
Test the site and all the links from a different computer so you can be sure it worksHint: give the URL address of your site to a friend so they can test
What to submit: the working URL to your website
Criteria:
Pts
10Site has at least four pages
10Site has a navigation menu
20Site has at least 5 distinct hyperlinks
10Site has at least 4 distinct images that are appropriately sized for fast loading on the web
10Site has a form with at least five fields
15Website functionality: all content loads without error
15Language, no spelling or grammatical errors
10Creativity and overall quality
100Total

Cut-Off Date: –/–/—-. Total Marks: 100 marks turned to 15 marks Contents W

Cut-Off Date: –/–/—-.
Total Marks: 100 marks turned to 15 marks Contents
Warnings and Declaration…………………………………….……………………………………1
Phase 1 ……………….…………………………………. …………………………………………2
Phase 2 ………………………………………………………………………………….………….2
Phase 3 ……………………………………………………………………………………………..3
Marking criteria …………………………………………………………………………………….3
Plagiarism Warning:
As per AOU rules and regulations, all students are required to submit their own TMA work and avoid plagiarism. The AOU has implemented sophisticated techniques for plagiarism detection. You must provide all references in case you use and quote another person’s work in your TMA. You will be penalized for any act of plagiarism as per the AOU’s rules and regulations.
Declaration of No Plagiarism by Student (to be signed and submitted by student with TMA work):
I hereby declare that this submitted TMA work is a result of my own efforts and I have not plagiarized any other person’s work. I have provided all references of information that I have used and quoted in my TMA work.
Name of Student:…………………………….. Signature:…………………………………………… Date:…………………………………………………
Application Service Scenario
Develop a service-based distributed web application that is part of “OnlinePlant” system. It records all of the transactions (selling and buying) of different types of plants and keeps track of the number of plants available in store. The system user could sign in as a store employee (seller), buyer, or as a system administrator.
The system contains the following components: a web application with SOAP services for selling, buying and retrieval processes and a Restful service for viewing and searching the available plants in the store through a web client and SOAP client at the store employee (seller).
1.Phase 1 (client-side) [30 marks]
At phase 1, develop the client-side interface to ensure that SOAP services are accessed properly via a java application and RESTful service is accessed via a web browser
For store employee (seller) [10 Marks]
1.The employee should be able to issuing receipts either for the customers need to buy a plant or those need to retrieve plant details such as type of plant, name of plant, age of plant, and the prize.
For buyer [5 Marks]
1. The buyer should be able to view the plant details and place an order.
For system administrators: [15 Marks]
1.After a successful login process, system administrator should be able to view all available plants in the store.
2. System administrator should be able to search for a specific plant by name or by age or by price.
.
Hint: Provide the necessary attributes and GUI interfaces and use the necessary communicating protocol.
2.Phase 2 (Server-side service) [60 marks]
At phase 2, develop web-side services using the JAVA programming languages. For each task required in phase one, you should provide the appropriate service using JAVA and provide the required security for only Restful service to grant access only to authorized users. [15 Marks each]
Here are some details regarding the functionality of some services:
View all available plants in store: this service should retrieve available plants in store that exist in a file (JSON format) on the server side.
Add a transaction: this service should reduce the number of existing plants according to the applied transaction; modifying the JSON file accordingly. If the number of plants from a specific type of plant reached the lower limit of that plant, the plant details should be stored in an “fast_selling” file (JSON format).
Delete a transaction: this service should update the various associated file(s) after applying a retrieval request.
Search for plant in store: this service should enable the system administrator to search for plant in store by any of their attributes.
Hint:Use the appropriate presentation format to save and read the necessary attributes to and from file.
3.Phase 3 (Using Cloud services) [10 marks]
1.The system is to be deployed over the Cloud for saving organization the cost of servers and other equipment and make use of remote resources. Answer the following with justification: Which cloud deployment model should be used. [4 Marks]
2.Design an architecture for the above application services showing its components and interaction between the components. [6 Marks]
Instructions:
1.Submit two files
a.one zip file containing all the project’s folders, assuming that you are using NetBeans to develop your TMA, then you are required to send the whole project folder as a single zip file.
Use the following format to name your zip file:
TM352-TMA-FALL-23_24-Branch-StudentName-ID
b.Put in a word file
1. Phase 1 and Phase 2 codes of client side, the operations of the web services as well as screenshots after running each service.
2. Needed xml files.
3.Answers of Phase 3.
Use the following format to name your word file:
TM352-TMA-FALL-23_24-Branch-StudentName-ID.docx
Note:
1. Violating the instructions would cause mark deduction.
2. Plagiarism policy is strictly applied in marking this TMA.
2. Fail to submit the Project File (Zip file) will deduct 50% of TMA marks.
3. Fail to submit the Word File will deduct 50% of TMA marks.
4. Every day late submission (after the due date) will deduct 10% of TMA marks.

You must submit two separate copies (one Word file and one PDF file) using the A

You must submit two separate copies (one Word file and one PDF file) using the Assignment Template on Blackboard via the allocated folder. These files must not be in compressed format.
It is your responsibility to check and make sure that you have uploaded both the correct files.
Zero mark will be given if you try to bypass the SafeAssign (e.g. misspell words, remove spaces between words, hide characters, use different character sets, convert text into image or languages other than English or any kind of manipulation).
Email submission will not be accepted.
You are advised to make your work clear and well-presented. This includes filling your information on the cover page.
You must use this template, failing which will result in zero mark.
You MUST show all your work, and text must not be converted into an image, unless specified otherwise by the question.
Late submission will result in ZERO mark.
The work should be your own, copying from students or other resources will result in ZERO mark.
Use Times New Roman font for all your answers.
Grading Criteria
Introduction about your organization
0.25
System service request
0.5
Stakeholders’ roles and responsibilities
0.25
Baseline Project Plan
0.75
Calculate the NPV, ROI, and Break-Even
Gantt chart
1
System requirements determination (at least 10 requirements)
1
Requirement determination Techniques
0.25
Use Case Diagram
1
DFD (at least 3 levels)
1.5
E-R diagram (complete and correct entity types, attributes, relationships, and cardinality)
1
Class diagram (complete class names, attributes, operations, multiplicity, associations)
1
Maintenance Type
0.25
Challenges
0.25
Presentation
5
Total
14
Description and Instructions
This project aims to describe the role of analysis and design in software development and illustrate the most common analysis and design techniques.
The project is a Group work with a minimum of 3 People and a maximum of 4 People.
Each group must submit/upload 3 files:
project report in Word document
PDF file of the project report
Presentation in PPT/PPTX format.
One of the group members (group leader) should submit all the files on the blackboard. Marks will be given based on your submission and the quality of the content.
Your project must be original work. The project will be checked using a plagiarism tool. Any matching with an online project or another/previous student project will be given ZERO.
Project Total Marks = 14
Due date: Sunday 3rd December 2023 @11:59 PM
Learning
Outcome(s):

CLO 3:

Recognize different concepts, principles, and software modelling techniques.
CLO 5:
Illustrate most common analysis and design techniques in the form of a group project.
Description and Instructions
You are the project manager in an IT department related to a health, hostel, or financial organization. One of the employees recognized the need for a new information system. Your role is to create an information system to support the business process. You need to choose the type of organization you want to build an information system for them and give it a name.
After choosing your organization, do the following:
A.Give a brief introduction about your organization.
B.Explain the needs for the new system by filling in the below system service request.
Organization name: ………………………
System Service Request
REQUESTED BY
…………………
DATE
…………………
TYPE OF REQUEST

…………………

URGENCY

…………………
PROBLEM STATEMENT
…………………
…………………
…………………
REQUESTED BY
Date:
DEPARTMENT
LOCATION

TYPE OF REQUEST

URGENCY

PROBLEM STATEMENT
…………………
…………………
…………………
SERVICE REQUEST
…………………
…………………
…………………
C.Who are the main stakeholders, and what are their roles and responsibilities?
Stakeholders
Role
Responsibility
D.Declare the Baseline Project Plan for the new system by filling in the form below.
Project Name:
Project Manager:
Project Start Date:
Project End Date:
Project Budget:
Project Goals:
The project includes the following tasks:
Project Scope:
The project includes the following tasks:
Project Timeline:
The project will be completed in the following phases:
Project Budget:
The project budget is as follows (Just an Example you can add or modify):
System purchase:
Implementation costs:
Maintenance and support cost:
Staff training costs:
Total budget:
Project Risks:
The following are potential risks to the project:
Project Mitigation Strategies:
The following mitigation strategies will be used to address the project risks:
E.Calculate the Net Present Value (NPV), Return On Investment (ROI), and Break-Even.
F.Create a Gantt chart showing the project’s phases, tasks, and duration.
G.List the functional and nonfunctional system and their priorities.
Functional Requirement
Description
Non-Functional Requirement
Description
Priority
H.Describe the techniques that have been used for requirement determination and collecting.
I.Explain how to represent business processes with the following business process diagrams.
i.Use Case Diagram
ii.DFD
iii.E-R Diagram
iv.Class Diagram
J.What type of maintenance do you suggest for maintaining this new IS?
K.What challenges have you faced while building this new system?