Our Services

Get 15% Discount on your First Order

[rank_math_breadcrumb]

MySQL Question

Description

College of Computing and Informatics
Assignment 2
Deadline: Sunday 05/05/2024 @ 23:59
[Total Mark for this Assignment is 8]
Student Details:
Name: ###
ID: ###
CRN: ###
Instructions:
• 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.
Restricted – ‫مقيد‬
Question One
Learning Outcome(s):
Build web applications
using PHP and MySQL
Restricted – ‫مقيد‬
Question One
2 Marks
Create the following relational tables by using SQL commands.
Add screenshots of the three created tables.
Marking Criteria
1.5 mark for SQL commands
0.5 mark for the screenshot
Question Two
Learning
Outcome(s):
Describe methods
and tools in
designing a creative
and dynamic
website.
Question Two
Use the technique you have learned in the class to debug the following code
and correct the error. Explain your steps in details.
PHP Excercise
.error{
font-weight: bold;
color: #C00;}
Assignment 1
Enter your first and last name
Font-wieght =22;
Restricted – ‫مقيد‬
2 Marks
Question Three
Learning Outcome(s):
Question Three
Build web applications
You have a table called users in MySQL database called IT405. The table
using PHP and MySQL
has the following data:
4 Marks
Id
Name
Address
1
Ali
Jeddah
2
Salah
Riyadh
Write a PHP code that output the following display:
3 @@@ Dammam
1 @@@ Jeddah
2 @@@ Riyadh
Note that the username is root, the password is empty string. You can
insert data in the table before the display.
Restricted – ‫مقيد‬

Purchase answer to see full
attachment

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

Project for IT 352

Description As a designer, you have been asked to come up with an application , website, or system to serve one of the following fields. Pet Care and Adoption Tourism Services Healthcare services Hajj and Umrah Services For the proposed prototype do the followings : a. Specify the field that

Project for IT354

Description Imagine you are the database administrator for a large healthcare corporation, and you’ve been tasked with designing and implementing a new Clinic Management System database. This system addresses real-world needs such as organizing patient records, scheduling appointments, tracking treatments, and handling prescriptions efficiently. You must use MySQL for database

discussion RES500

Description Question designers need to avoid specific wording problems. For example, they should avoid leading questions or double-barreled questions. What do you think about it? Elaborate with sample questions and possible answers. (Refer Chapter 11) Embed course material concepts, principles, and theories (which require supporting citations), along with two scholarly

Business Question

Description STUDENTS ARE ADVISED TO MAKE THEIR WORK CLEAR AND WELL PRESENTED,MARKS MAY BE REDUCED FOR POOR PRESENTATION. THIS INCLUDES FILLING YOUR INFORMATION ON THE COVER PAGE. • STUDENTS MUST MENTION QUESTION NUMBER CLEARLY IN THEIR ANSWER. • LATE SUBMISSION WILL NOT BE ACCEPTED. • Avoid plagiarism, the work should

Project for IT 353

Description The purpose of this project is to give you hands-on experience with the early phases of the System Development Life Cycle (SDLC). By working in groups, you will learn how to: Identify system needs and document them in a structured way. Apply analysis techniques to define requirements and model

113 ass 4

Description see College of Health Sciences ASSIGNMENT COVER SHEET Course name: Health Policy & Saudi Healthcare System Course code: HCM113 CRN: Assignment title: There are different types of healthcare system structure, and each one has its own advantages and disadvantages. 1. What are the types of healthcare system structure? (5)

hci 316 ass 2

Description see College of Health Sciences Department of Health Informatics HCI-316-ASSIGNMENT Course name: E-Health Course number: HCI316 CRN XXXX Assignment title or task: The Applications of Virtual Reality in Healthcare: from a Provider’s Perspective in Saudi Arabia. In this 600-word essay, answer the following question: How can Virtual Reality be

hci 316 ass 3

Description see College of Health Sciences Department of Health Informatics HCI-316-ASSIGNMENT Course name: E-Health Course number: HCI316 CRN XXXX Assignment title or task: The Applications of Virtual Reality in Healthcare: from a Provider’s Perspective in Saudi Arabia. In this 600-word essay, answer the following question: How can Virtual Reality be

Intro to International Business 321

Description Please solve it as its requiered on the file, please start as soonas you can ‫المملكة العربية السعودية‬ ‫وزارة التعليم‬ ‫الجامعة السعودية اإللكترونية‬ Kingdom of Saudi Arabia Ministry of Education Saudi Electronic University College of Administrative and Financial Sciences Assignment 2 Introduction to International Business (MGT 321) Due Date:

Communications Management MGT421

Description Please solve it as the requieres ‫المملكة العربية السعودية‬ ‫وزارة التعليم‬ ‫الجامعة السعودية اإللكترونية‬ Kingdom of Saudi Arabia Ministry of Education Saudi Electronic University College of Administrative and Financial Sciences Assignment 2 Communications Management (MGT 421) Due Date: 13/11/2025 @ 23:59 Course Name: Communication Management Student’s Name: Course Code:

Spreadsheet Decision Modeling – MGT425

Description Please solve it as the requieres on the file ‫المملكة العربية السعودية‬ ‫وزارة التعليم‬ ‫الجامعة السعودية اإللكترونية‬ Kingdom of Saudi Arabia Ministry of Education Saudi Electronic University College of Administrative and Financial Sciences Assignment-2 MGT425-Spreadsheet Decision Modelling Due Date: 01/11/2025@ 23:59 (End of Week 9) Course Name:Spreadsheet Decision Modelling

attached file

Description HBR’s fictionalized case studies present problems faced by leaders in real companies and offer solutions from experts. This one is based on the Ivey case study “Schiit Audio: Does It Make Sense to Sell on Amazon?” (HBR product no. W20914-PDF-ENG), by Michael A. Stanko and Jeffrey Pollack, which is

Business Question

Description ‫المملكة العربية السعودية‬ ‫وزارة التعليم‬ ‫الجامعة السعودية اإللكترونية‬ Kingdom of Saudi Arabia Ministry of Education Saudi Electronic University College of Administrative and Financial Sciences Assignment 2 Introduction to Operations Management (MGT311) Due Date: 01/11/2025 @ 23:59 Course Name:Introduction to Operations Management Course Code:MGT 311 Student’s Name: Semester:First CRN: Student’s

Boudor ecom322

Description ECOM 322: Social Media Marketing 1st 2025-2026 Project Assignment In this project, you will work as a group to provide social media consulting. You own a Social Media consulting company, and your company has been selected to work with a new Saudi B2C organization (business or non-profit) of your

362 ASS 11

Description see ASSIGNMENT COVER SHEET Course name: Workplace Health Promotion Course number: PHC362 CRN: 11662 Assignment title or task: (You can write a question) How workplace health promotion programs improve productivity and why some groups are more vulnerable to discrimination, harassment, and stigmatization which lead to stress at the workplace?

362 ASS 12

Description see ASSIGNMENT COVER SHEET Course name: Workplace Health Promotion Course number: PHC362 CRN: 11662 Assignment title or task: (You can write a question) How workplace health promotion programs improve productivity and why some groups are more vulnerable to discrimination, harassment, and stigmatization which lead to stress at the workplace?

362 ASS 13

Description see ASSIGNMENT COVER SHEET Course name: Workplace Health Promotion Course number: PHC362 CRN: 11662 Assignment title or task: (You can write a question) How workplace health promotion programs improve productivity and why some groups are more vulnerable to discrimination, harassment, and stigmatization which lead to stress at the workplace?