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

Reply.

Description reply. NAWAL ALGHANMI Effective Accounting Functions Collapse Introduction This discussion explores the critical functions of managerial and financial accounting in the healthcare industry, emphasizing how these functions affect internal decision-making, operational supervision, and financial management, all of which are necessary to guarantee efficient and long-lasting healthcare delivery (Gapenski, 2015).

Finance Question

Description discussion board post for my finance course (Principle Of Finance). Below are the exact requirements provided by my instructor: Financial Analysis Select two of the four companies shown below. Use the following SEC Edgar website for your research: Companies: FORD MOTOR CO Walmart Inc. Pepsi Coca-Cola Instructions: Compare the

Global Economics – Discussion

Description Question 1: What do you know about Globalization? Consider what you learned from the lecture and readings this week and discuss how economic interdependence has affected Saudi Arabia. Is it good or bad? Expand your thinking to additionally discuss the relationship between Saudi Vision 2030 and international competitiveness .

MGT325 – discussion

Description Watch the short video in the following link 2.3 Test your Knowledge (Question): Q. What traits appear to make individual most creative? Are these traits that lead to successful invention?

To answer part 1

Description Saudi Electronic University College of Administrative and Financial Sciences E-commerce Department Student Name: Student ID: Course Title: Management Information Course Code: MIS201 System Academic Year/ Semester: CRN: Instructor Name: Student Grade: Grade Level: Low/ Middle / High Saudi Electronic University College of Administrative and Financial Sciences Assignment of MIS201-

Hci 214 activity 1

Description What are the benefits of using CD 10 coding system? Study Guide Basic Medical Coding Using ICD-10 By Sheila McCray Introduction to Coding Lesson 1 Medical coders review the documents in the patient’s medical record and abstract (collect clinical data) or retrieve information from specific documents. They then assign

Dis

Description Dis1. 2 file Accounting discussion : Financial accounting and managerial accounting are subdivisions of accounting and play an essential role within an organization. Discuss the major differences between managerial and financial accounting then apply your understanding to the following 4 scenarios. Discuss if these are managerial accounting or financial

ACT 500 – Dis 1

Description Directions: 1.Discuss the concepts, principles, and theories from the textbook. 2.Cite the textbooks and cite any other sources if appropriate. ACT 500 – Dis 1 Management Accounting Financial accounting and managerial accounting are subdivisions of accounting and play an essential role within an organization. Discuss the major differences between

MGT 521 – Dis 1

Description Directions: 1.Discuss the concepts, principles, and theories from the textbook. 2.Cite the textbooks and cite any other sources if appropriate. 3.Text Not Image. 4.Unique Answer. 5.Avoid Plagiarism. 6.500-word limit. 7.AI is not allowed. To Download Text Book Click Here >> (( TEXT BooK MGT 521 )) MGT 521 –

MGT 530 – Dis 1

Description MGT 530 – Dis 1 Operations Management Carrefour is a French owned hypermarket operating in many places including Saudi Arabia. Consider Carrefour in Saudi Arabia when you, as a customer, judge the quality of the hypermarket. Explain how quality is evaluated, and the role of technology in the customer

Management Question

Description • Self-Study: How to Do Research: A Step-By-Step Guide Question: In your company’s management development program, there was a heated discussion between some people who claimed, “Theory is impractical and thus no good,” and others who claimed, “Good theory is the most practical approach to problems.” What position would

Disss.

Description Identify a current public health concern in Saudi Arabia (do not use COVID-19). Explain the corresponding Saudi Vision 2030 goal and national policy governing this concern. Address the following: • Identify the major issues associated with this global public health concern. • Describe the Saudi Vision 2030 goal pertinent

answer all q

Description Question 1 of 25 You don’t need to be the best salesperson to be the best coach. Option A True Option B False Question 2 of 25 Dialogues are used when speaking to your guests, monologues should be used when speaking to your team. Option A True Option B

Internship report and presentation

Description Field Training Report Student Trainee: ID. No: Name of the Company: Submitted to: (Academic Supervisor) Department of———————————————————Jubail Industrial College Acknowledgement (Font 14) Thank the company which gave you an opportunity to do the training and also thank all the individuals who helped and supervised you during the 15 weeks

DB-The Role of Management Accounting

Description The focus of this module is on the terminology and concepts that will be used throughout the course. It is important to learn this terminology and watch the videos to better understand the cost flows. Management Accounting Financial accounting and managerial accounting are subdivisions of accounting and play an

DB- The Role of Management Accounting

Description The Role of Management Accounting Management Accounting Financial accounting and managerial accounting are subdivisions of accounting and play an essential role within an organization. Discuss the major differences between managerial and financial accounting then apply your understanding to the following 4 scenarios. Discuss if these are managerial accounting or

Dis

Description Dis1. book managerial.  Management Accounting Financial accounting and managerial accounting are subdivisions of accounting and play an essential role within an organization. Discuss the major differences between managerial and financial accounting then apply your understanding to the following 4 scenarios. Discuss if these are managerial accounting or financial accounting