Category: Databases

You need to submit a power point presentation (20 to 22 slides) and Summary (600 words) of a technical paper.
Details of Summary.
The summary should provide in depth description and analysis of the paper. Each summary should have the following content when appropriate:
Motivation and background. What is the problem that the authors attempt to solve? Why is this problem important? Has this problem being dicussed or addressed before?
Key contributions. Summarize the main points of the paper. What is their approach and how is it original and innovative? How is the appoach evaluated? What are the results and impact of the research? Please keep in mind, you do not have answer these questions. They may not be even relevant for some papers. They are just here for general guidelines.
Your Evaluations. What are the strengths and weaknesses of the paper? What constructive criticism can you give to the author(s)?
Each summary should be about 500-600 words in length (no more than 800 words please). Your summary will be submitted via SafeAssign feature of the Blackboard. “SafeAssign compares submitted assignments against a set of academic papers to identify areas of overlap between the submitted assignment and existing works.” For an eligible submission, the matching score should be below 25%.

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. Question One
Using your own world, differentiate between database schema and database state with examples.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.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.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 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 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 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 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 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 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 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:
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