Category: Databases

Convert the infix expression to a postfix expression.(Write all the steps by dra

Convert the infix expression to a postfix expression.(Write all the steps by drawing a stack)
A. 90+7 * 3/6
B. 8/(4-3+5)*6+10

Thus far in the quarter, you have primarily been making maps to showcase pattern

Thus far in the quarter, you have primarily been making maps to showcase patterns in data. In this module, we turn our attention to the analytical capabilities of a GIS. In Module 7, you learned about vector analysis tools. In this lab, you will practice using those tools while considering the placement of ballot dropboxes in Seattle and King County. Specifically, we will be exploring the question:
How well distributed are the King County ballot dropboxes?
In this lab, you will be given multiple shapefiles and two tables with spatial, electoral and demographic data relating to King County voters. The lab will walk you through the various analytical tools discussed in Module 7 as we analyze the data.
This lab should take approximately 3 hours to complete. This lab is worth 70 points.
Evidence of skill development will be assessed on:
Submit answers to the lab questions and two maps made using QGIS. (Required – 70 points)

1-
List the three main types of constraints in the relational model and explai

1-
List the three main types of constraints in the relational model and explain each in your own words. List the Basic operations for changing the database and explain why the DELETE operation may violate only the referential integrity and not the entity constraint.?
2-
inventory management system. They need a database schema to track product inventory, suppliers, and orders efficiently. Design an Entity-Relationship (ER) diagram to represent this system, considering the following entities and their attributes: • Product: Attributes may include ProductID, Name, Description, Price, and Quantity. • Supplier: Attributes may include SupplierID, Name, Contact, Address. • Order: Attributes may include OrderID, Date, and TotalAmount. • OrderDetails: This is a relationship entity representing the details of each order, such as the quantity of each product ordered. Consider the relationships between these entities and ensure that your ER diagram reflects these connections accurately. Your diagram should illustrate how products are supplied by suppliers, how orders are placed, and the details associated with each order. Answer?
3-
Identify and explain the various types of database users and their roles in a database system. Choose one type of user (e.g., end-users, database administrators, application programmers) and elaborate on the specific tasks and responsibilities associated with that user role. Discuss how the interaction of different user types contributes to a database system’s overall functionality and efficiency. Finally, provide a real-world example or case study where the collaboration of different types of database users played a crucial role in the success or failure of a database project. Ensure your response reflects a deep understanding of the roles and responsibilities of database users.
4-
You are tasked with designing a conceptual database schema for the King Fahad General Hospital. The system needs to store information about Patients, Doctors, Departments, and Medicines. Explain in detail the fundamental database concepts you would consider during the design phase. Discuss the importance of entities, attributes, and relationships. Additionally, outline your proposed database architecture’s potential challenges and benefits, considering factors such as scalability and data integrity?

Competency
In this project, you will demonstrate your mastery of the following c

Competency
In this project, you will demonstrate your mastery of the following competency:
Analyze the results of queries constructed to address data requirements
Scenario
The product manager of Quantigration has asked your data analytics team for a report summarizing your analysis of the return merchandise authorizations (RMAs) that have been received. These are the same data sets that you’ve already been working with. Your report should focus on summarizing the analysis and presenting your findings to the product manager.
Directions
RMA Report
In your report, respond to the manager’s requests: to summarize the data you’ve been working with and to identify key information that will help the company streamline operations. Remember, not everyone who reviews this report will have a technical background.
Begin by writing SQL commands to capture usable data (which you’ve preloaded into Codio) for your analysis.
Specifically, the product manager wants you to analyze the following:
Analyze the number of returns by state and describe your findings in your report.
Analyze the percentage of returns by product type and describe your findings in your report.
In your report, clearly summarize your analysis of the data for stakeholders. Include screenshots of the results of each query. When summarizing results, you may want to consider the following questions:
How does the data provide the product manager with usable information?
What are the potential flaws in the data that has been presented?
Are there any limitations on your conclusions, or any other ways of looking at it that you haven’t considered? Clearly communicate your findings to stakeholders.
What to Submit
To complete this project, you must submit the following:
Data Analysis RMA Report
Submit a report for the product manager summarizing the results of your analysis. Your report will address the analysis that you’ve conducted. Provide screenshots of your SQL queries and their resultant output following the same instructions for capturing screenshots that you were given in previous assignments. Lastly, provide a brief report that summarizes your analysis. Any references must be cited in APA format.

This assignment is done on netlab.
You have to connect it to the Lenox and windo

This assignment is done on netlab.
You have to connect it to the Lenox and windows server, the teacher said ”You will need to research how to set your assigned static IP address on each server. On Linux you will need to research netplan and modify config yaml file. While on windows, you will need to go network settings.” but I will set u both labs for you so we can work on them together. I will know and the teacher will know if you don’t use the actual application because you just can’t use any server or ip address I’m going to give all the information to the selected tutor.

What different types of data make up “big data” for your chosen company? Describ

What different types of data make up “big data” for your chosen company? Describe the big data (what it is and how it is used). Big is a term that describes extremely large data sets that may be analyzed computationally to reveal patterns, trends, and associations. Examples of big data may include data in a company’s customer service department used to solve customer problems or a company’s use of stock market or competitive intelligence data to predict the future (Hint: You can find examples of big data used by the organization by reviewing data reports on the “Investors” or “Our Investors” tab of the organization’s website). Justify your answers.
The company selected is Toyota.
Please attach the article used.

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

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.
2 Marks
Learning
Outcome (1):
Explain the concepts and
architectures involved in the database development.
Question One
List
the three main types of constraints in the relational model and explain each in
your own words. List the Basic operations for changing the database and explain
why the DELETE operation may violate only the referential integrity and not the
entity constraint.
Answer:
2 Marks
Learning Outcome(4): Instructors: Create Entity-Relationship model, Relational model, and write SQL queries.
Question Two
Your client, a retail company, has approached you for assistance in optimizing their inventory management system. They need a database schema to track product inventory, suppliers, and orders efficiently. Design an Entity-Relationship (ER) diagram to represent this system, considering the following entities and their attributes: Product: Attributes may include ProductID, Name, Description, Price, and Quantity.
Supplier: Attributes may include SupplierID, Name, Contact, Address.
Order: Attributes may include OrderID, Date, and TotalAmount.
OrderDetails: This is a relationship entity representing the details of each order, such as the quantity of each product ordered.
Consider the relationships between these entities and ensure that your ER diagram reflects these connections accurately. Your diagram should illustrate how products are supplied by suppliers, how orders are placed, and the details associated with each order. Answer
2 Marks

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

Question Three
Identify and explain the various types of database users and their roles in a database system. Choose one type of user (e.g., end-users, database administrators, application programmers) and elaborate on the specific tasks and responsibilities associated with that user role. Discuss how the interaction of different user types contributes to a database system’s overall functionality and efficiency. Finally, provide a real-world example or case study where the collaboration of different types of database users played a crucial role in the success or failure of a database project. Ensure your response reflects a deep understanding of the roles and responsibilities of database users.
Answer:
2 Marks

Learning Outcome(5):
Instructors: Design a database starting from the conceptual design to the implementation of database schemas.

Question Four
You are tasked with designing a conceptual database schema for the King Fahad General Hospital. The system needs to store information about Patients, Doctors, Departments, and Medicines. Explain in detail the fundamental database concepts you would consider during the design phase. Discuss the importance of entities, attributes, and relationships. Additionally, outline your proposed database architecture’s potential challenges and benefits, considering factors such as scalability and data integrity.
Answer:

Competencies
In this project, you will demonstrate your mastery of the following

Competencies
In this project, you will demonstrate your mastery of the following competencies:
Create a structured database through the use of relational concepts
Implement basic processing functionalities to create new structured database environments
Step One: Scenario
You’re working as a database administrator for Quantigration, a networking equipment manufacturer. The company has grown quickly, and it’s still figuring out its internal business processes. Customer return merchandise authorizations (RMAs) are used to track shipments for defective or incorrect parts. The company has identified RMAs as a specific problematic area.
Your supervisor at Quantigration asked you to create a database for a new software application that will be used for processing RMAs. Because there are several locations where merchandise can be taken in, the application must also record where items are received. This system will also capture where the equipment is going next: repair, scrap, or refurbishing and resale. The warehouse shipping and receiving employees at your company will be using this application; they are considered your “end users” for the application. Part of their job is to process customer return shipments. This involves the following steps:
Assess the quality of the items being returned for defects
Identify missing parts
Identify signs of obvious wear and tear (such as dents or scratches to the equipment)
Step One: Directions
Create a Database
The data architect on your DevOps team has come to you with a logical database diagram referred to as an entity relationship diagram (ERD). This is documentation of the tables, their relationships to each other, their attributes, and any primary or foreign keys on those attributes. These elements are required to create the new database.
Prior to beginning, review the example ERD in the Quantigration RMA Diagram document in Supporting Materials.
Create your three tables, named Customers, Orders, and RMA, in the QuantigrationUpdates database based on the example you‘ve been given. To do this, complete the following steps and place your work in the provided Database Documentation Template:
Navigate to your online integrated development environment (IDE). The next set of steps will help you write SQL commands to create tables that demonstrate relationships based on the ERD.
Create a database schema called QuantigrationUpdates that will hold tables by using SQL commands. List it out to the screen.
Using the ERD as a reference, create the following tables with the appropriate attributes and keys:
A table to store customer information with a primary key of Customer ID
A table to store order information with a primary key of Order ID and a foreign key of Customer ID
A table to store RMA information with a primary key of RMA ID and a foreign key of Order ID
STOP: Make sure to save your work before moving on to Step Two of this process. You’ll continue to work in Codio and use the documentation you started in Step One.
Step Two: Scenario
Now it’s time to populate the database with records and run some basic queries against those tables. You’ll be using the QuantigrationUpdates database and the three tables you created in Step One to do the following:
Import data from the CSV data files into the tables
Perform queries against those tables
Create an output listing to the screen of the query results
The shipping and receiving team that you are working with has been keeping records of their RMAs in spreadsheets, and your team has been creating its database in MySQL. The information that they have is detailed and won’t need cleaning. The data in the tables can be exported to CSV files. The data should also align with the columns and data types in your tables.
Step Two: Directions
Load and Query the Data
In Step One, you created a customer RMA database using SQL to create tables and placed your work in the database documentation template. To complete your objectives in this step, continue to place your work in the database documentation template and follow these directions:
Please note before you begin that the three data files being used for this project are preloaded into Codio:RMA.csv
Customers.csv
Orders.csv
Import the data from each file into tables.Use the QuantigrationUpdates database, the three tables you created, and the three CSV files preloaded into Codio.Use the import utility of your database program to load the data from each file into the table of the same name. You’ll perform this step three times, once for each table.
Write basic queries against imported tables to organize and analyze targeted data. For each query, include a screenshot of the query and its output. You should also include a 1- to 3-sentence description of the output.Write an SQL query that returns the count of orders for customers located only in the city of Framingham, Massachusetts.This query will use a table join between the Customers and Orders tables. The query will also use a WHERE clause.
How many records were returned?
Write an SQL query to select all of the customers located in the state of Massachusetts.Use a WHERE clause to limit the number of records in the customers table to only those who are located in Massachusetts.
Record an answer to the following question: How many records were returned?
Write an SQL query to insert four new records into the orders and customers tables using the following data:
Customers TableCustomerIDFirstNameLastNameStreetAddressCityStateZip CodeTelephone
100004 LukeSkywalker17 Maiden LaneNew YorkNY10222212-555-1234
100005WinstonSmith128 Sycamore Street GreensboroNC27401919-555-6623
100006MaryAnneJenkins2 Coconut WayJupiterFL33458321-555-8907
100007JanetWilliams58 Redondo Beach BlvdTorrenceCA90501310-555-5678
Orders TableOrderIDCustomerIDSKUDescription
1204305 100004ADV-24-10C Advanced Switch 10GigE Copper 24 port
1204306100005ADV-48-10F Advanced Switch 10 GigE Copper/Fiber 44 port copper 4 port fiber
1204307100006ENT-24-10F Enterprise Switch 10GigE SFP+ 24 Port
1204308100007ENT-48-10F Enterprise Switch 10GigE SFP+ 48 port
In the Customers table, perform a query to count all records where the city is Woonsocket, Rhode Island.How many records are in the customers table where the field “city” equals “Woonsocket”?
In the RMA database, update a customer’s records.Write an SQL statement to select the current fields of status and step for the record in the RMA table with an OrderID value of “5175.”What are the current status and step?
Write an SQL statement to update the status and step for the OrderID, 5175 to status = “Complete” and step = “Credit Customer Account.”What are the updated status and step values for this record? Provide a screenshot of your work.
Delete RMA records.Write an SQL statement to delete all records with a reason of “Rejected”.How many records were deleted? Provide a screenshot of your work.
Because of a new company branding initiative, you’ve been asked to change the name of the “Customer” to “Collaborator.” Update your existing table using SQL based on this change in requirements. Copy and paste the SQL you write to do the following:Rename all instances of “Customer” to “Collaborator.”
Create an output file of the required query results. Write an SQL statement to list the contents of the Orders table and send the output to a file that has a .csv extension.
What to Submit
To complete this project, you must submit the following:
Database Documentation
Complete and submit the Database Documentation Template. This will be where you capture the work that you’ve done in both Step One and Step Two. Follow the specific instructions for the directions outlined here and within the template itself.
Supporting Materials
The CSV data files that you’ll be working with can be found in Codio. They are listed vertically in the left pane of your Codio web interface. The following resource(s) may support your work on the project:
Document: Database Documentation Template Example
As you complete your database documentation template, refer to this document for an example of how to insert screenshots to capture your work.
Document: Quantigration RMA Diagram
This ERD shows the relationships of entities in the database. Download this ERD and use it to support your work on this project. A text version of the diagram is available: Quantigration RMA Diagram Text Version.

Discussion Board
Purpose:
Learning to design the database.
Discussion Topic:
As

Discussion Board
Purpose:
Learning to design the database.
Discussion Topic:
As we explore the world of database systems, let’s investigate the various phases involved in the process of database design. What are the key steps and considerations in each phase, starting from conceptualization to implementation? Please share examples or case studies that illustrate the significance of each phase in creating a well-structured and efficient database. Moreover, how do these design phases contribute to the overall success of database systems in terms of performance, scalability, and data integrity?
Submission Instructions
Post your responses on this topic on the blackboard.
You are required to write at least ONE original post and ONE response commenting on the posts uploaded by your friends.
Total Marks Allotted: 4 Marks

Fundamentals of Databases (IT-403)
Discussion Board

Purpose:
Learning to de

Fundamentals of Databases (IT-403)
Discussion Board

Purpose:
Learning to design the database.
Discussion Topic:
As we explore the world of database systems, let’s investigate the various phases involved in the process of database design. What are the key steps and considerations in each phase, starting from conceptualization to implementation? Please share examples or case studies that illustrate the significance of each phase in creating a well-structured and efficient database. Moreover, how do these design phases contribute to the overall success of database systems in terms of performance, scalability, and data integrity?
Submission Instructions
Post your responses on this topic on the blackboard.
You are required to write at least ONE original post and ONE response commenting on the posts uploaded by your friends.
Total Marks Allotted: 4 Marks
Due Date: 13th, February 2024

Marking Criteria
For your Original Post, including examples: 1.5 post + 1.5 examples
For your one response: 1 (for meaningful feedback to at least one classmate)