Annual Report FY [Year] [Add a quote here from one of your company executiv

Annual Report
FY [Year]
[Add a quote here from one of your company executives or use this space for a brief summary of the document content.]

Fundamentals of Database
IT403

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.

Name: ###

CRN: ###
ID: ###

2 Marks

Learning Outcome(s):
CLO 1 Explain the concepts and architectures involved in the database development.

Question One
Using your own world, differentiate between database schema and database state with examples.
2 Marks

Learning Outcome(s): CLO3
Create Entity-Relationship model, Relational model, and write SQL queries

Question Two The advent of online shopping has revolutionized the traditional shopping experience, offering convenience to consumers worldwide. However, have you ever pondered the intricate processes that unfold once you confirm your purchase? Beyond the seamless transaction lies a sophisticated infrastructure comprising databases, servers, and applications working in unison.
Provide the relational database schema for an online shopping system where customers place orders. An order may consist of multiple products, with products categorized for easy organization and search. The Customer table identifies the customers placing orders with their personal information, while the Category table specifies the product categories and description. The Product table lists the available items for purchase and their prices, each linked to a category through the Category ID. Orders, recorded in the Order table with date of order and the total amount, and they are associated with customers through the Customer ID. The Order Detail table captures the intricate relationship between orders and products, detailing the products included in an order along with their respective quantities.
2 Marks

Learning Outcome(s):
CLO3: Create Entity-Relationship model, Relational model, and write SQL queries.

Question Three Compare and contrast the effects of specialization and generalization on the hierarchy of Enhanced Entity-Relationship (EER) diagrams. Give examples to illustrate how generalization and specialization differ.
2 Marks

Learning Outcome(s):
CLO 3
Instructors: Create Entity-Relationship model, Relational model, and write SQL queries

Question Four Draw an ER diagram for the following SPL Saudi Post system.
SPL application relies on a company-wide information system. In SPL Saudi Post system, shipped items are the main component of the SPL product tracking information system. Shipped items can be characterized by item number (unique), weight, dimensions, insurance amount, destination, and final delivery date. Shipped items are received into the SPL system at a single retail center. Retail centers are characterized by their type, unique ID, and address. Shipped items make their way to their destination via one or more standard SPL transportation events (flights, truck deliveries). These transportation events are characterized by a unique schedule Number, a type (flight, truck), and a delivery Route.

Annual Report FY [Year] [Add a quote here from one of your company executiv

Annual Report
FY [Year]
[Add a quote here from one of your company executives or use this space for a brief summary of the document content.]

Fundamentals of Database
IT403

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.

Name: ###

CRN: ###
ID: ###

2 Marks

Learning Outcome(s):
CLO 1 Explain the concepts and architectures involved in the database development.

Question One
Using your own world, differentiate between database schema and database state with examples.
2 Marks

Learning Outcome(s): CLO3
Create Entity-Relationship model, Relational model, and write SQL queries

Question Two The advent of online shopping has revolutionized the traditional shopping experience, offering convenience to consumers worldwide. However, have you ever pondered the intricate processes that unfold once you confirm your purchase? Beyond the seamless transaction lies a sophisticated infrastructure comprising databases, servers, and applications working in unison.
Provide the relational database schema for an online shopping system where customers place orders. An order may consist of multiple products, with products categorized for easy organization and search. The Customer table identifies the customers placing orders with their personal information, while the Category table specifies the product categories and description. The Product table lists the available items for purchase and their prices, each linked to a category through the Category ID. Orders, recorded in the Order table with date of order and the total amount, and they are associated with customers through the Customer ID. The Order Detail table captures the intricate relationship between orders and products, detailing the products included in an order along with their respective quantities.
2 Marks

Learning Outcome(s):
CLO3: Create Entity-Relationship model, Relational model, and write SQL queries.

Question Three Compare and contrast the effects of specialization and generalization on the hierarchy of Enhanced Entity-Relationship (EER) diagrams. Give examples to illustrate how generalization and specialization differ.
2 Marks

Learning Outcome(s):
CLO 3
Instructors: Create Entity-Relationship model, Relational model, and write SQL queries

Question Four Draw an ER diagram for the following SPL Saudi Post system.
SPL application relies on a company-wide information system. In SPL Saudi Post system, shipped items are the main component of the SPL product tracking information system. Shipped items can be characterized by item number (unique), weight, dimensions, insurance amount, destination, and final delivery date. Shipped items are received into the SPL system at a single retail center. Retail centers are characterized by their type, unique ID, and address. Shipped items make their way to their destination via one or more standard SPL transportation events (flights, truck deliveries). These transportation events are characterized by a unique schedule Number, a type (flight, truck), and a delivery Route.

 You must submit two separate copies (one Word file and one PDF file) using the

 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

Action Items Access the discussion forum for this assignment by clicking on the

Action Items
Access the discussion forum for this assignment by clicking on the discussion forum title.
Click on “Create Thread.”
Enter a title for your question in the “Subject” line.
Type your response into the message field to the following discussion prompt:
1. Discuss three tier Client-Server DBMS architecture in relation with the
functionality of each layer. How does it improve the security of a database?
2. Respond to two other classmates’ postings by critically reviewing your classmate’s answer and stating which points you agree or disagree with.
Submission Instructions
Post your questions and your answer to your classmates before 18/09/2024 @ 23:59
ResourcesRequired Reading
Textbook
Ramez Elmasri & Shamkant Navathe (2017), Fundamentals of Database Systems, Global Edition, 7th Edition, Person, ISBN-13: 978-0133970777 | ISBN-10: 0133970779.

1. Consider a relation R(A,B,C,D,E,F,G,H) with the following functional dependen

1. Consider a relation R(A,B,C,D,E,F,G,H) with the following functional dependencies:
A -> BCD
AD -> E
EFG -> H
F -> GH
(a) Based on these functional dependencies, there is one minimal key for R. What is it?
(b) One of the four functional dependencies can be removed without altering the key. Which one?
2. Consider the following relational schema:
UnivInfo(studID, studName, course, profID, profOffice)
Each tuple in relation UnivInfo encodes the fact that the student with the given ID and name took the given course from the professor with the given ID and office. Assume that students have unique IDs but not necessarily unique names, and professors have unique IDs but not necessarily unique offices. Each student has one name; each professor has one office.
(a) Specify a set of completely nontrivial functional dependencies for relation UnivInfo that encodes the assumptions described above and no additional assumptions.
(b) Based on your functional dependencies in part (a), specify all minimal keys for relation UnivInfo.
(c) Is UnivInfo in Boyce-Codd Normal Form (BCNF) according to your answers to (a) and (b)? If not, give a decomposition of UnivInfo into BCNF.
(d) Now add the following two assumptions: (1) No student takes two different courses from the same professor; (2) No course is taught by more than one professor (but a professor may teach more than one course). Specify additional functional dependencies to take these new assumptions into account.
(e) Based on your functional dependencies for parts (a) and (d) together, specify all minimal keys for relation UnivInfo.
(f) Is UnivInfo in BCNF according to your answers to (d) and (e)? If not, give a decomposition of UnivInfo into BCNF.

Download and open the Access test file below: SloAnimals.accdbDownload SloAnimal

Download and open the Access test file below:
SloAnimals.accdbDownload SloAnimals.accdb
StepsOpen the Animals table and change the field length of the AnimalBreed to thirty characters. Change the caption to “Breed”.
Relate the two tables by the common field, and enforce referential integrity.
Examine the data in the tables. Become familiar with the field names and data in each field.
Create and save the following queries, using the names provided (Q1, Q2, etc.):Q1: Create a query to list all the dogs’ names and birthdates for all dogs born after 1/1/2015. Why? This will be used to send out advertisements for puppy training classes.
Q2: Create a query to list the animal type, animal name and offsite for all appointments for cattle that had an off-site visit. Why? We need special vets for farm cattle if we have the demand.
Q3: Create a query to show all the animals that are beagles or all that are bulldogs. Display the Owner Id and the Dog’s name but not the breed field. Why? We need to give them special shots due to a specific virus going around.
Q4: Create a query to sum up all the visit costs grouped by Owner. Show the list in order by Cost, high to low. Instead of displaying the label “Cost” in the result, display “Amount Spent”. Why? We want to see who spends the most with us so we can send them an office calendar.
Create a report that shows every animal name, birthdate, animal type, and breed. Group by Animal type and sort on breed, so they sort in alphabetical order. Use a block layout in portrait mode. The report will be named Local Animals. Make sure no fields or data are chopped off.

The first few items you need to complete to get started in this course are: Down

The first few items you need to complete to get started in this course are:
Download Tableau: Instructions for obtaining your license are found here on Brightspace. I urge you to start this process as soon as possible. You will need Tableau up and running in order to follow along with certain course content as well as to complete your assignments.
Introduce yourself on the Student Connection Forum: I’d really like to get to know each of you! Please post a brief introduction about yourself on the Student Connection Forum in Brightspace. This will help me, the GAs, and your fellow students to get to know you.
Begin with Module 0 and Read the Course Syllabus: You should begin the course content by starting with Module 0, which includes the Course Syllabus. It’s vital that you understand and adhere to the guidelines outlined in the syllabus. The syllabus also contains pertinent course information. Passing the syllabus quiz with a 100% score is a requirement to unlock further quizzes.
Please login here :https://eastern.brightspace.com/d2l/home/105412
username:tochukwu.duru
password:Goings1955######
Search Topics
Bookmarks
Bookmarks
0 bookmarked topics
Course Schedule
Course Schedule
0 upcoming events
Table of Contents
Table of Contents
selected
167
Module 0: Introduction
module: contains 3 sub-modules
16
Module 1: Introduction to Information Visualization
module: contains 3 sub-modules
16
Module 2: Choosing an effective visual
module: contains 3 sub-modules
24
Module 3: Clutter is your enemy
module: contains 3 sub-modules
16
Module 4: Focus your audience’s attention
module: contains 3 sub-modules
33
Module 5: Think like a designer
module: contains 3 sub-modules
24
Module 6: Dissecting model visuals
module: contains 3 sub-modules
19
Module 7: Lessons in Storytelling
module: contains 1 sub-modules
12
Final ProjectFinal Project Submission
Assignment
Task: Submit to complete this assignment
Due June 30 at 11:59 PM
Available until Jun 30, 2024 11:59 PM. Submission restricted after availability ends.
You can login to check the course:
username:tochukwu.duru
password:Goings1955######
please make sure you login and check. It is a TABLEU COURSE

The data and fields file will be provided by your lecturer at the commencement o

The data and fields file will be provided by your lecturer at the commencement of the class. The data relates to nutrition of breakfast cereal. Suppose that you are an Analytics team for a sport and dieting company. You have been given data on the nutritional components (e.g. sugar, fat, protein…) of common breakfast cereals and a rating. You wish to determine which cereals are best for diabetics and those on special diets. PLEASE TYPE OR SEND ME STEPS BY STEP IN THE WORD DOCUMENT HOW YOU GET THAT ANSWER.
Upload the data into Excel for an initial check. The file is a csv (txt) file. Check for missing data and errors.
a. State the number of data records you have in the sample
b. You may notice some negative values which can be modified using an approximate based on a similar product and state your changes.
c. Provide any assumptions, changes and issues presented in the data that may impact your analysis
d. Sort the ratings from largest to smallest to get an idea of general customer approval of the cereals and state the cereal with the highest and lowest approval rating
e. Save the file as an Excel file for uploading into Power BI or Tableau.

Project DEADLINE: SUNDAY 12/05/2024 @ 23:59 [Total Mark is 14] Web Design IT404

Project
DEADLINE: SUNDAY 12/05/2024 @ 23:59
[Total Mark is 14]
Web Design
IT404
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, usedifferent 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.
Student Details: CRN:
Name:
Name:
Name:
ID:
ID:
ID:
JavaScrip<> “Error*” “JavaScripJavaScrip
Learning Outcome(s):
CLO1: Identify most HTML tags and CSS properties and use a text editor to construct the basic HTML and CSS structure for a webpage.
CLO3: Evaluate the effectiveness of a web design in respect to its context.
CLO4:Developwebsites that present information, graphics and hypertext using CSS and JavaScript.
Description and InstructionsThe aims of this project are to understand the role of the web designer, become familiar with the web design environment, and learn about the tools and programming languages that are required to create a web page.
➢ Project Instructions
• The project is a Group work with a minimum of 3 People and a maximum of 4 People.
• Each group must submit three files:
1. Word document of project report.
2. PDF file of the project report
3. Presentation in PPT/PPTX format.
• Only one of the group members (group leader) should submit all the files on the blackboard.
• Your project MUSTbe original work.
• The project will be checked using a plagiarism tool.
• Any matching with an online project or another/previous student project will be given ZERO.

Project DEADLINE: SUNDAY 12/05/2024 @ 23:59 [Total Mark is 14] Web Design IT404

Project
DEADLINE: SUNDAY 12/05/2024 @ 23:59
[Total Mark is 14]
Web Design
IT404
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, usedifferent 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.
Student Details: CRN:
Name:
Name:
Name:
ID:
ID:
ID:
JavaScrip<> “Error*” “JavaScrip JavaScrip
Learning Outcome(s):
CLO1: Identify most HTML tags and CSS properties and use a text editor to construct the basic HTML and CSS structure for a webpage.
CLO3: Evaluate the effectiveness of a web design in respect to its context.
CLO4:Developwebsites that present information, graphics and hypertext using CSS and JavaScript.
Description and InstructionsThe aims of this project are to understand the role of the web designer, become familiar with the web design environment, and learn about the tools and programming languages that are required to create a web page.
➢ Project Instructions
• The project is a Group work with a minimum of 3 People and a maximum of 4 People.
• Each group must submit three files:
1. Word document of project report.
2. PDF file of the project report
3. Presentation in PPT/PPTX format.
• Only one of the group members (group leader) should submit all the files on the blackboard.
• Your project MUSTbe original work.
• The project will be checked using a plagiarism tool.
• Any matching with an online project or another/previous student project will be given ZERO.