Category: Databases

Do your own research on 5 or more distinct database models that are reported to be most popular (excluding Multi-modal) on . Go deeper in your comparative research using other up-to-date information you can find on the web beyond the summary descriptions provided on the above website. Finally, put together and submit your own pros/cons comparison table that can guide you in selecting the best database model given a specific database application in the future. Attached will be a word doc of how the hw should be please use the same 5 database in the world doc and add more research , compared them pro and cons of each

I’m e-commerce student. I’m training in IT support department.I want to write second periodic report. I want it include more about cybersecurity. I will attach the first report.
and this is responsibilities I should learn
1. Identify and fix technical problems that may
have an impact on the operation, user experience,
and transactions of websites.
2. Cybersecurity procedures.
3. Software management, which includes customer
support platforms and content management
systems.
4. User support and communication.
5. Maintenance of networks and systems.

I’m e-commerce student. I’m training in IT support department.I want to write second periodic report. I want it include more about cybersecurity. I will attach the first report.
and this is responsibilities I should learn
1. Identify and fix technical problems that may
have an impact on the operation, user experience,
and transactions of websites.
2. Cybersecurity procedures.
3. Software management, which includes customer
support platforms and content management
systems.
4. User support and communication.
5. Maintenance of networks and systems.

I’m e-commerce student. I’m training in IT support department.I want to write second periodic report. I want it include more about cybersecurity. I will attach the first report.
and this is responsibilities I should learn
1. Identify and fix technical problems that may
have an impact on the operation, user experience,
and transactions of websites.
2. Cybersecurity procedures.
3. Software management, which includes customer
support platforms and content management
systems.
4. User support and communication.
5. Maintenance of networks and systems.

I’m e-commerce student. I’m training in IT support department.I want to write second periodic report. I want it include more about cybersecurity. I will attach the first report.
and this is responsibilities I should learn
1. Identify and fix technical problems that may
have an impact on the operation, user experience,
and transactions of websites.
2. Cybersecurity procedures.
3. Software management, which includes customer
support platforms and content management
systems.
4. User support and communication.
5. Maintenance of networks and systems.

It has to be an 8 page paper, with 10 references. It can be on any of these topics:
Anonymization/Pseudonymization, Data Hiding, Metadata and Security, XML Security, Authorization and Access Control, Data Integrity, Privacy Preserving Data Mining, Statistical Database Security, Control of Data Disclosure, Private Information Retrieval, Secure Stream Processing, Secure Auditing, Data Retention, Search on Encrypted Data, Digital and Enterprise Rights Management, Multimedia Security and Privacy, Private Authentication, Identity Management, Privacy Enhancing Technologies, Security and Semantic Web, Security and Privacy in Ubiquitous Computing, Security and Privacy of Health Data, Web Service Security, Trust Management, Policy Management, Applied Cryptography
APA style format

Use the Image attached below to answer the questions. (these are two different modules so please provide the answers seperately) so it is easy for me to turn in.
1st.
Individually, using the physical ER model, write the SQL to create the database. Share your physical ER model and the SQL with the group. The SQL should
Create the database
Tables with all columns
Primary and foreign keys
Any unique constrain
——————————————————————————————————————–
2nd question.
Individually, write the SQL to insert the sample data from Module 1.
Identify hypothetical scenarios that would require updates and deletes on your records and write SQL appropriately. For example: phone number for a contact changes; someone is no longer your contact.

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.