Category: Databases

Purpose
In this discussion board, you will post your answer to the question. You will also read and respond to other classmate’s postings. This is an excellent way for you to interact with your colleagues and to share your thoughts about the question answer in a critical way.
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 the difference and application of Two Tier and Three Tier Client-Server DBMS Architecture.

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 19/Sep/2023 @ 23:59
Grading Criteria (4 Mark)
2 marks: for your original post.
2 marks: for each response to another classmate posting (2 marks maximum)
*An example of unacceptable replies: “I agree with you”, “good post I like it”, “I think your post it good” or any similar are not acceptable replies.

You will need to install and use Microsoft SQL Server Express and Microsoft SQL Server Management Studio (SSMS) for this course. You can download the latest versions of these free software products here:
Microsoft SQL Server Express
Microsoft SSMS
Before completing the Assignment, please watch the Unit 3 videos covering facets associated with physical database modeling. Navigate to the Academic Tools area of this course and select Library then Required Readings to access your texts and videos.Based on the established database design diagram and the data contained in the Movies Dataset:
Identify the elements to be included in the physical data model.
Using SQL Server Management Studio Designer tools, create the database.
Using SQL Server Management Studio Designer tools, create the tables (convert entity names to table names).
Using SQL Server Management Studio Designer tools, associate column names (convert attribute names to column or field names), datatype, and number of characters for each attribute (field).
Using SQL Server Management Studio Designer tools, establish the primary keys for each of the tables.
Using SQL Server Management Studio Designer tools, establish any foreign keys for each of the tables (here you are converting your relationships to foreign keys).
Create a screenshot of your SQL Management Studio showing the database and tables you have created; embed this screenshot into your Word document.
Please use the following guidance document to help you complete this assignment: Instructions for Using the Microsoft SSMS Designer Tools to Generate the Movies Database
You will need to use the established database design diagram and Movies Dataset for this assignment. Download and use the diagram and data for your analysis.
Assignment Requirements
Microsoft SQL Server Express and SQL Server Management Studio (SSMS) MUST be installed to complete this Assignment.
Compose your Assignment in a Word document and be sure to identify yourself, your class, and unit Assignment at the top of your paper. Embed the screenshots from SQL Server Management Studio showing the work performed for the creation of the database and tables.
Also review the university policy on plagiarism. If you have any questions, please contact your professor.
The assignment is due by the final day of the Unit 3 week.

You will need to install and use Microsoft SQL Server Express and Microsoft SQL Server Management Studio (SSMS) for this course. You can download the latest versions of these free software products here:
Microsoft SQL Server Express
Microsoft SSMS
Before completing the Assignment, please watch the Unit 3 videos covering facets associated with physical database modeling. Navigate to the Academic Tools area of this course and select Library then Required Readings to access your texts and videos.Based on the established database design diagram and the data contained in the Movies Dataset:
Identify the elements to be included in the physical data model.
Using SQL Server Management Studio Designer tools, create the database.
Using SQL Server Management Studio Designer tools, create the tables (convert entity names to table names).
Using SQL Server Management Studio Designer tools, associate column names (convert attribute names to column or field names), datatype, and number of characters for each attribute (field).
Using SQL Server Management Studio Designer tools, establish the primary keys for each of the tables.
Using SQL Server Management Studio Designer tools, establish any foreign keys for each of the tables (here you are converting your relationships to foreign keys).
Create a screenshot of your SQL Management Studio showing the database and tables you have created; embed this screenshot into your Word document.
Please use the following guidance document to help you complete this assignment: Instructions for Using the Microsoft SSMS Designer Tools to Generate the Movies Database
You will need to use the established database design diagram and Movies Dataset for this assignment. Download and use the diagram and data for your analysis.
Assignment Requirements
Microsoft SQL Server Express and SQL Server Management Studio (SSMS) MUST be installed to complete this Assignment.
Compose your Assignment in a Word document and be sure to identify yourself, your class, and unit Assignment at the top of your paper. Embed the screenshots from SQL Server Management Studio showing the work performed for the creation of the database and tables.
Also review the university policy on plagiarism. If you have any questions, please contact your professor.
The assignment is due by the final day of the Unit 3 week.

Critical Thinking
Hi, looking forward assist with the following:
Improving Data Governance
Corporations are increasingly moving their data to the cloud. Select an organization, national or international, that has used or should consider using cloud technology. Then, address the following requirements:
Explain details (e.g., mission, vision, values, industry) about the organization that you selected. ( You have to selected Saudi Aramco )

Outline some of the advantages and disadvantages of your selected company using the cloud. ( You must highlight your response in red )
Explain industry practices. Do other organizations in your selected organization’s industry use the cloud? Why or why not? ( You Must highlight your response in blue )
What are some of the factors that must be considered before any organization uses the cloud? ( You Must highlight your response in yellow )
Instructions for the writing:
Your well-written report should be 5-6 pages long, not including the title and reference pages.
To make it easier make sure you clearly delineate each section of your answer so it can be matched with the relevant question.
Use academic writing standards and APA style guidelines, citing at least two references in support of your work ( See the attached slide ) and below sources. You must use them.
in addition to your text and assigned readings. You must provide only academic references.
Plagiarism Must not exceed 10% otherwise the paper cannot be accepted it. I’m going to check it from the different web software to ensure the required quality and plagiarism percentage prior to accepting the paper.
You should organize the work in the best quality.
https://www.sciencedirect.com/science/article/abs/pii/S0167739X17321489?via%3Dihub
Elzein, I. A., & Kurdi, M. (2019). Analyzing the Challenges of Security Threats and Personal information in Mobile Cloud Computing Infrastructure. 2019 International Conference on Digitization (ICD), Digitization (ICD), 2019 International Conference On, 202–206.

Assignment Instructions
It’s very important that you watch the Unit 1 videos associated with conceptual database modeling prior to completing the Assignment. Navigate to the Academic Tools area of this course and select Library then Required Readings to access your texts and videos.
Given a Movies Dataset, you will conceptualize a database solution using three or more tables. Based on the data analysis, you will then create a conceptual model using Microsoft® Visio®, which can be obtained at no cost from the Microsoft Azure Dev Tools for Teaching site.
Download and use the Movies Dataset for your analysis.
Identify the entities for the conceptual data model, and then determine which entities are related.
In a Word document, write a list of the entities, and explain your choices. In this same document, describe the relationships that exist between these entities, and using a few sentences, explain why they are related.
In Visio (or within the same Word document), create a conceptual database model that shows the entities and their relationship. Refer to the Unit 1 learning activity for an example.
If you created the conceptual model in Visio, embed the Visio diagram in the Word document so that you have a single document for submission.
What sources did you refer to while working on this Assignment? Cite these sources within the body of the paper and annotate those as your references at the end of the paper.
Assignment Requirements
Generate the conceptual design diagram using the Microsoft Visio application. Microsoft Visio can be obtained at no cost from the Microsoft Azure Dev Tools for Teaching site.
Compose your Assignment in a Word document and be sure to identify yourself, your class, and unit Assignment at the top of your paper. Copy the design diagram(s) into your Word document. Be sure to use appropriate APA format and cite your textbook or other sources that you used in the assignment. For more information on APA style formatting, go to Academic Writer under the Academic Tools area of this course.
Also review the university policy on plagiarism. If you have any questions, please contact your professor.
The assignment is due by the final day of the Unit 1 week.

1.
my_var = 3
my_var = “foo”
my_var = len
Explain this above code is allowed to not allowed? What is the typy of my_var at the very end?
def double_plus_y(x, y=4):
return 2 * x + y
for value in map(double_plus_y, [1,2,3,4]):
print(value)
Predict the output without running the code.
Use list comphresion the questions from this point on.
In [ ]:
hogwarts_emails = [‘weasley6@hogwarts.edu’,
‘hpotter@gmail.com’,
‘hgranger@gmail.com’,
‘longbott@hogwarts.edu’,
‘dmalfoy@hogwarts.edu’,
‘dthomas@gmail.com’,
‘ppatil@hogwarts.edu’,
‘lunalovegood@quibbler.com’
]
Hogwarts staff want to use the first part of each email as a username. Make a list of these usernames
In [ ]:

Let’s make a dictionary where the keys are the usernames and the values are email addresses
In [ ]:

To read a file, we use the open function. Using with avoids having to remember to close the file. The file path depends on your google drive folder structure. Write python code to find how many countries will be visited.
In [4]:
with open(‘/content/drive/MyDrive/datamining/travel.txt’, ‘r’) as md:
for line in md:
print(line)
This summer I will be travelling.
I will go to…
Italy: Rome
Greece: Athens
England: London, Manchester
France: Paris, Nice, Lyon
Spain: Madrid, Barcelona, Granada
Austria: Vienna
I will probably not even want to come back!
However, I wonder how I will get by with all the different languages.
I only know English!

PreparationIn this assignment, you will be drawing an Entity Relationship Diagram (ERD) or Database Design Diagram.
ScenarioSuppose a local college has tasked you to develop a database that will keep track of students and the courses that they have taken. In addition to tracking the students and courses, the client wants the database to keep track of the instructors teaching each of the courses.
Instructions for the Database Design DiagramUse any drawing package or any other application you know such as Visio, Word, PowerPoint, or another tool to create the Database Design Diagram. Otherwise, you may draw the diagram by hand with a pen and paper. If you draw the diagram by hand, then take one or more pictures of the diagram with your cell phone or laptop camera, place the images into a Word document, and submit the document. Otherwise, if you use software to create the Database Design Diagram, then take one or more screen captures of the diagram, place the screen captures into a Word document, and submit the document. Submissions that are not in .doc or .docx format will not be graded. Include the following in the document:
Draw the entities of the database and the attributes of each entity, based on your research and/or common knowledge of a college and the information tracked by a college.
Create the appropriate relationships between each entity within the diagram.
Describe any assumptions that you had to make about the business rules in order to create the diagram and the associated relationships.

This course is designed for placement preparation and will mainly cover data structures and algorithms using C and C++. Even if you do not know C++, you will still be able to follow along easily. The notes will be made available as a PDF in the description below.
Data Structures and Algorithms
Data structures are used to arrange data in main memory for efficient usage while algorithms are a sequence of steps to solve a given problem. In this course, we will cover arrays, linked lists, and graphs as examples of data structures and dive into solving problems using different algorithms.
Programming Languages
C and C++ will be the primary languages used in this course but Java can also be used to implement the algorithms. I do not recommend Python or JavaScript for beginners but rather suggest learning C to get a solid foundation in programming.
Conclusion
Learning data structures and algorithms is a responsibility and I will teach this course in a way that is easy to understand for beginners. Don’t worry if you make mistakes or have trouble at first, just follow along step by step and everything will become clear.
Data Structures & Algorithms for Placements
This course is primarily for those preparing for placements or job interviews.
Time is limited when preparing for placements, so this course is structured to value your time. A 15-hour video on C with notes is available on the channel, which will be covered first. If you’re an advanced Java user or can program algorithms in Python, then it’s possible to do so. However, it’s recommended to learn C and C++ first.
Data structure is an arrangement of data in main memory, which refers to RAM (Random Access Memory) of 2, 4, 8, 16, or 32 GB. The sequence of RAM usage is important when loading a program like “chrome.exe” for Windows. Fiddling with data occurs in main memory, which must be arranged optimally using data structures to minimize RAM usage.
The theory of databases is not covered in this course, but you should know their basic concepts. When opening a new tab, a large amount of data is stored in a database that must be retrieved and updated regularly. Data warehouses store data permanently for faster retrieval and updation for analysis purposes. Legacy data needs to be stored separately from the main system.
Sorting Algorithms
The example used here is sorting arrays in ascending or descending order. An algorithm is a series of steps to create a process. When sorting an array, steps must be taken to sort in ascending or descending order. The steps taken to sort an algorithm into an array d
efine the algorithm.

Tell me about your experience with ServiceNow modules: Incidents, Service Catalog, Knowledge, Agent workspace, Change Management and SPM including demand management.
Tell me about your experience building/configuring end-user Service Portals, workflows, upgrades, inbound email notifications, configuring SLAs and form fields
Tell me about your experience with ACLs, UI policies and business rules
Tell me about your experience with CMDB, Mid server and flow designer
Tell me about your experience with ITIL and IT ServiceNow Management principles

Data analytics is a process in which data is collected from various sources, cleaned by removing irrelevant information, and transformed into meaningful insights. This involves the use of technologies, tools, and frameworks to analyze the data and extract valuable information.
The data generation process is constant and only expected to increase in the future. With the advent of newer technologies, the data analytics domain holds paramount importance in every sector. Companies are constantly looking for professionals who can convert data into crucial insights.