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

273 ass 3

Description See College of Health Sciences Department of Public Health PAPER ASSIGNMENT Course name: Introduction to Mental Health Course number: PHC-273 Go through the following weblink of MOH, KSA: Answer the following questions based on the information provided in the above link: Q1. Why MOH decided to change the name

Accounting Question

Description I just want to solve the second and third questions College of Administration and Finance Sciences Assignment (1) Deadline: Saturday 04/10/2025 @ 23:59 Course Name: Advanced Financial Student’s Name: Accounting Course Code: ACCT 302 Student’s ID Number: Semester: First Semester CRN: Academic Year: 1447 H (2025-2026) For Instructor’s Use

Principle Of Accounting / Acct101

Description • THE ASSIGNMENT MUST BE SUBMITTED ON BLACKBOARD (WORD FORMAT ONLY) VIA ALLOCATED FOLDER. • ASSIGNMENTS SUBMITTED THROUGH EMAIL WILL NOT BE ACCEPTED. • 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

Fundamentals of Databases IT403

Description 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

ECOM101 Project – Part A

Description -Do not solve the whole assignment, only question number 1 called “Know the Business,” which is worth 7 marks. -The company is Sivvi. -I want original text, no plagiarism. Textbook Laudon, K., & Traver, C. (2018). E-commerce: Business, technology, society. 2018. (14th). Upper Saddle River, NJ: Pearson Prentice Hall.

PPT solve

Description COVID-19 Pandemic and Mental Health in KSA (110 points)Examine how the COVID-19 Pandemic influenced patients with mental health disorders and their treatment plans. Use this week’s required readings, recommended readings, the textbook and your own research to develop a PowerPoint presentation describing:An overview of symptoms, risk factors, and prevalence

ppt HCM-502:

Description Critical Thinking: Case Study – Develop a Motivation Plan (110 Points)First, read “Case Study 6-6 “Develop a Motivation Plan” on page 121 in Organizational Behavior in Health Care.Within the principles of the content theories of Maslow, Herzberg, and Alderfer:Explain why Susan is behaving the way she has been over

502 solve hu

Description Critical Thinking: Case Study – Develop a Motivation Plan (110 Points)First, read “Case Study 6-6 “Develop a Motivation Plan” on page 121 in Organizational Behavior in Health Care.Within the principles of the content theories of Maslow, Herzberg, and Alderfer:Explain why Susan is behaving the way she has been over

500 new o

Description COVID-19 Pandemic and Mental Health in KSA (110 points) Examine how the COVID-19 Pandemic influenced patients with mental health disorders and their treatment plans. Use this week’s required readings, recommended readings, the textbook and your own research to develop a PowerPoint presentation describing: An overview of symptoms, risk factors,

IT-475-Decision Support Systems

Description Universities often use a Student Information System to manage student data. Such systems may be used both for day-to-day operations (OLTP) and for decision-making and analysis (OLAP). 1. Briefly explain the difference between OLTP (Online Transaction Processing) and OLAP (Online Analytical Processing) in this context. 2. Give two examples

502 fisal new

Description Critical Thinking: Case Study – Develop a Motivation Plan (110 Points) First, read “Case Study 6-6 “Develop a Motivation Plan” on page 121 in Organizational Behavior in Health Care. Within the principles of the content theories of Maslow, Herzberg, and Alderfer: Explain why Susan is behaving the way she

alaa .it351

Description Hello New Beginning I want a correct and complete solution for all paragraphs. I must adhere to the instructions. I don’t want plagiarism. I don’t want similarities. I don’t want a solution using artificial intelligence. I want a correct solution. Put the solution inside the file. Include all requirements.

it351.hani

Description Hello New Beginning I want a correct and complete solution for all paragraphs. I must adhere to the instructions. I don’t want plagiarism. I don’t want similarities. I don’t want a solution using artificial intelligence. I want a correct solution. Put the solution inside the file. Include all requirements.

it352,alaa

Description Hello New Beginning I want a correct and complete solution for all paragraphs. I must adhere to the instructions. I don’t want plagiarism. I don’t want similarities. I don’t want a solution using artificial intelligence. I want a correct solution. Put the solution inside the file. Include all requirements.

hani..it352

Description Hello New Beginning I want a correct and complete solution for all paragraphs. I must adhere to the instructions. I don’t want plagiarism. I don’t want similarities. I don’t want a solution using artificial intelligence. I want a correct solution. Put the solution inside the file. Include all requirements.

it353,alaa

Description Hello New Beginning I want a correct and complete solution for all paragraphs. I must adhere to the instructions. I don’t want plagiarism. I don’t want similarities. I don’t want a solution using artificial intelligence. I want a correct solution. Put the solution inside the file. Include all requirements.

it.353,hani

Description Hello New Beginning I want a correct and complete solution for all paragraphs. I must adhere to the instructions. I don’t want plagiarism. I don’t want similarities. I don’t want a solution using artificial intelligence. I want a correct solution. Put the solution inside the file. Include all requirements.