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

Management Question

Description ‫المملكة العربية السعودية‬ ‫وزارة التعليم‬ ‫الجامعة السعودية اإللكترونية‬ Kingdom of Saudi Arabia Ministry of Education Saudi Electronic University College of Administrative and Financial Sciences Assignment 2 Organizational Behaviour (MGT 301) Due Date: 01/11/2025 @ 23:59 Course Name: Organizational Behaviour Student’s Name: Course Code: MGT301 Student’s ID Number: Semester: 1st

discussion ECN500

Description Industrial Policy in Practice: Balancing State Intervention and Market Forces Developing nations have employed industrial policies to foster technological upgrading and sectoral diversification. Discuss how modern industrial policies differ from traditional “developmental state” models, particularly in addressing challenges like transnational corporation (TNC) dominance and credit market failures. Should developing

331 ASS 9

Description SEE College of Health Sciences Department of Public Health ASSIGNMENT COVER SHEET Course name: Chronic Disease Epidemiology Course Code & CRN: PHC331 -XXXX The tobacco epidemic is one of the biggest public health threats the world has ever faced. Being a leading cause of preventable diseases and deaths necessitates

Ecom201-project

Description Saudi Electronic University College of Administrative and Financial Sciences E-commerce Department Group Project Group Students Names: Cover Page Group IDs: Course Title: Introduction to EManagement Course Code: ECOM 201 Academic Year/ Semester: 2025/20261st Term Instructor Name: CRN: Student Grade: out of 20 Grade Level: Low/ Mid/ High 1 ECOM

BIOL 101 ASS 5

Description SEE ASSIGNMENT COVER SHEET Course name: Basic Medical Terminology Course number: BIOL101 CRN: XXXX Paper Assignment Assignment title or task: (You can write a question) Draw a table, include 5 Columns (1- Medical Term, 2- Prefix (if available), 3- Root, 4- Suffix, 5- Basic explanation of the term) and

BIOL 101 ASS 6

Description SEE ASSIGNMENT COVER SHEET Course name: Basic Medical Terminology Course number: BIOL101 CRN: XXXX Paper Assignment Assignment title or task: (You can write a question) Draw a table, include 5 Columns (1- Medical Term, 2- Prefix (if available), 3- Root, 4- Suffix, 5- Basic explanation of the term) and

515 model 9

Description Locate an article which addresses the prevalent healthcare fraud and abuse issues in the Kingdom of Saudi Arabia. Discuss the three of the most prevalent healthcare fraud and abuse issues in the Kingdom of Saudi Arabia. What regulatory and governmental efforts are in place to reduce fraud and abuse?

372 ASS 6

Description SEE College of Health Sciences Department of Health Informatics ASSIGNMENT COVER SHEET Course name: Public health outbreak and disaster management Course number: PHC 372 Assignment title The Role of Technology in Public Health Disaster Management “Natural disasters have always been a significant threat to human lives and infrastructure, causing

372 ASS 7

Description SEE College of Health Sciences Department of Health Informatics ASSIGNMENT COVER SHEET Course name: Public health outbreak and disaster management Course number: PHC 372 Assignment title The Role of Technology in Public Health Disaster Management “Natural disasters have always been a significant threat to human lives and infrastructure, causing

372 ASS 8

Description SEE College of Health Sciences Department of Health Informatics ASSIGNMENT COVER SHEET Course name: Public health outbreak and disaster management Course number: PHC 372 Assignment title The Role of Technology in Public Health Disaster Management “Natural disasters have always been a significant threat to human lives and infrastructure, causing

372 ASS 9

Description SEE College of Health Sciences Department of Health Informatics ASSIGNMENT COVER SHEET Course name: Public health outbreak and disaster management Course number: PHC 372 Assignment title The Role of Technology in Public Health Disaster Management “Natural disasters have always been a significant threat to human lives and infrastructure, causing

374 ASS 9

Description SRE ASSIGNMENT COVER SHEET Course name ORAL HEALTH PROMOTION Course number PHC 374 CRN XXXXX Evidence-based practice (EBP) integrates the best current research with clinical expertise and community needs to improve oral health outcomes. Evidence-Based Practices in Oral Health In this short paper, you will explore one evidence based

374 ASS 10

Description SEE ASSIGNMENT COVER SHEET Course name ORAL HEALTH PROMOTION Course number PHC 374 CRN XXXXX Evidence-based practice (EBP) integrates the best current research with clinical expertise and community needs to improve oral health outcomes. Evidence-Based Practices in Oral Health In this short paper, you will explore one evidence based

Hci 314 ass 1

Description see College of Health Sciences Department of Health Informatics ASSIGNMENT COVER SHEET Course name: Public Health Informatics Course number: HCI 314 CRN 11123 Assignment Question Discuss the impact of limited data interoperability on public health and potential approaches to improve it. Word count between 400 to 500 Students ID

Hci 314 ass 2

Description See College of Health Sciences Department of Health Informatics ASSIGNMENT COVER SHEET Course name: Public Health Informatics Course number: HCI 314 CRN 11123 Assignment Question Discuss the impact of limited data interoperability on public health and potential approaches to improve it. Word count between 400 to 500 Students ID

Hci 315 ass 1

Description See College of Health Sciences Department of Health Informatics ASSIGNMENT COVER SHEET Course name: Telehealth and Telemedicine Course number: HCI-315 Question: Future Trends in Healthcare Technology Assignment title or task: • • Discuss one emerging trend in Telehealth technology. Explain how this trend could impact healthcare delivery in the

Hci 315 ass 2

Description see College of Health Sciences Department of Health Informatics ASSIGNMENT COVER SHEET Course name: Telehealth and Telemedicine Course number: HCI-315 Question: Future Trends in Healthcare Technology Assignment title or task: • • Discuss one emerging trend in Telehealth technology. Explain how this trend could impact healthcare delivery in the

ph new 1 solve

Description General Guide / Instructions: Write your name and University ID at the top of your report. Read the assignment instructions and rubrics carefully. Do not copy and paste directly from slides or textbooks. Provide at least Two scientific reference for each question (textbook, journal, or reliable website). Plagiarism or