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

fin 408 ,

Description I want the presentation file. College of Administration and Finance Sciences Form No 4- Internship Report Cover Page Student`s name: Rand Mishal almuatiri Student`s ID #: S210025071 Training Organization:SABIC Trainee Department:VAT Field Instructor Name: Meshari Althobaiti Field Instructor Signature: Course Title: FIN 408 CRN: 50233 Internship Start Date:23 june

FIN 408 Internship

Description I did my coop at SABIC VAT department I worked on SAP system and attend multiple meetings for many department vat , tax , financial closing , trusarey , audit , and I become I part of starting I new system name STAR . Course Name: Student’s Name: Course

499 dis 47 – 1

Description Discussion 1 Students must initiate a post and reply to at least three posts Briefly describe your role in the internship. What differences have you noticed as you have transitioned from your role as student to intern? What new knowledge or skill did you learn since the beginning of

499 dis 47 – 2

Description Discussion two, requires you to answer the following questions:  What did you learn, either from reading or classroom discussions that you applied on the internship?  Which courses/subjects you feel could be expanded or added that would have helped you perform the internship better?  How does this

Presentation-ECOM402

Description I have the Presentation part 3 I need only part 3, it’s the Presentation for the group project of ecom-402 (the subject is about : Namshi ksa)

Ecom-430 Final Report for internship and final presentation

Description Hello, I want to finalize 1- Final report related to my internship. 2- Final presentation I will share all the previous files. Course Name: Student’s Name: Course Code: Student’s ID Number: Semester: CRN: Academic Year: 144 /144 H ‫ر‬ ‫الجامعة السعودية االلكتونية‬ For‫ ر‬Instructor’s Use only ‫الجامعة السعودية االلكتونية‬

Management Question

Description Academic Report Guideline(Co-op) (please do not include this text in the final report, just follow its guidelines and use the cover page above) The report should be submitted within two weeks after you finish your Co-op training Program. In addition, the report should be approximately 3000 – 4000, single

499 dis 45 – 1

Description Discussion 1 Students must initiate a post and reply to at least three posts Briefly describe your role in the internship. What differences have you noticed as you have transitioned from your role as student to intern? What new knowledge or skill did you learn since the beginning of

499 dis 45 – 2

Description Discussion two, requires you to answer the following questions:  What did you learn, either from reading or classroom discussions that you applied on the internship?  Which courses/subjects you feel could be expanded or added that would have helped you perform the internship better?  How does this