Take a few minutes to explore Slave Voyages,,

Take a few minutes to explore Slave Voyages,,

Instructions:
1. Take a few minutes to explore Slave Voyages,,Links to an external site. the impressive database of over 900,000 slave ships voyages across the Atlantic Ocean over three centuries. Watch the short videos from the site: Time-lapse with narrativeLinks to an external site. and the Slave Ship in 3D VideoLinks to an external site..
2. Use the databaseLinks to an external site. to find answers to the following questions.
TIP: Make use of the 2 rows of Tabs (Summary statistics, Tables, Data Visiualization, Timeline…; First Row: Years Ranges, Ship, nation, owner, Itinerary).
For help with this database, watch this Tutorial:
For this RR, you can enumerate your answers.
What was the average length of the Middle Passage in days?
What percentage of enslaved peoples documented in this database were children?
What percentage of slaves embarked died during voyage?
Set the Itinerary (in Top Row tabs) to Place where captives were landed: Mainland North America. Then look at the results in Summary Stats, Tables, Data Visualization, Timeline, Maps, Timelapse. Using any of these data views, tell me:In which North American British colonies did most enslaved peoples land between 1651-1675. What were the totals for each colony? (Use Tables; click the 1651-1675 date range; Change Column to Principal place of Landing > now look for answer)
Between what years (year range) did most enslaved peoples land on the mainland North America. What was the total number for those years?
Select one slave voyage that landed in New York in the 18th century. Tell me everything you can about that voyage in a narrative paragraph. (Do not list this info. Imagine you were sharing what you learned about this voyage in a newspaper or textbook.)

List the three main types of constraints in the relational model and explain each in your own words.

List the three main types of constraints in the relational model and explain each in your own words.

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:
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 :
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:
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:

Reply to this post with a written entry will no less than 100 words and up to 25

Reply to this post with a written entry will no less than 100 words and up to 25

Reply to this post with a written entry will no less than 100 words and up to 250 words. Each entry must contain some reference to either the course book (page) or an external reference (URL for example). You also must reply to another post (at least a response with at least two sentences). Please click on the icon with the three vertical dots on the upper right of the Canvas page to see the rubric for this assignment.
Discussion question
Read Mini Case: American Airlines’ Sky-High Cash Flow Problem.
Answer the following:
Is there one or several statistical techniques for prescriptive analytics that could have been used to evaluate the long-term profitability of AAirpass?
Briefly explain your reasoning.

SOURCES ACTIVITY CODE list is your DOF Activity Code List Your GVI Listings is a

SOURCES
ACTIVITY CODE list is your DOF Activity Code List
Your GVI Listings is a

SOURCES
ACTIVITY CODE list is your DOF Activity Code List
Your GVI Listings is a spreadsheet to check for personnel on the inactive codes that we’ve identified.
vi.gov/wp-content/uploads/2022/06/2023-2024-final-budget-book.pdf – Your budget book may have verbiage discrepancies and information that isn’t placed in any of the files and should be utilized to cross reference as you work on your workbook
FY23 Consolation v3 File and PMU consolidation file- Both files are current and are being reported on. They should be cross-referenced and used while filling out your assigned workbook below. I have filed it out. Please make sure all data is filed and that nothing is missing. Please leave comments, place information if needed, and add data if required. ( i will have to email them to you as they to big
Directions for Assignment:
ACTIVITY CODES FILE should replicate the DOF report; each AC code should be in numerical order, color-coded as applicable in the AC List Draft, then from there you will use the GVI personnel listing spreadsheet to check for personnel on the inactive codes that we’ve identified.
Assignment:
AC List Draft is the workbook you’ll be working on. Please follow the color legend.

Similar to your assignment for Tableau, for this assignment you will be creating

Similar to your assignment for Tableau, for this assignment you will be creating

Similar to your assignment for Tableau, for this assignment you will be creating a dashboard in Power BI.
We will be using the data available in this module. Note: it will need to be cleaned.
Include at least 4 visualizations in the dashboard. At least one should information on the different job titles (the data will need to be cleaned for you to do this)
Include at least one “card” visualization.
Use a uniform color scheme
Add a title to the top and “Dashboard by: Your Name” at the bottom
Ensure your legend titles appropriately describe what they show
Make sure your overall dashboard is visually appealing, you’ll have to play around with resizing containers and tiled/floating boxes
Upload a PDF

Similar to your assignment for Tableau, for this assignment you will be creating

Similar to your assignment for Tableau, for this assignment you will be creating

Similar to your assignment for Tableau, for this assignment you will be creating a dashboard in Power BI.
We will be using the data available in this module. Note: it will need to be cleaned.
Include at least 4 visualizations in the dashboard. At least one should information on the different job titles (the data will need to be cleaned for you to do this)
Include at least one “card” visualization.
Use a uniform color scheme
Add a title to the top and “Dashboard by: Your Name” at the bottom
Ensure your legend titles appropriately describe what they show
Make sure your overall dashboard is visually appealing, you’ll have to play around with resizing containers and tiled/floating boxes
Upload a PDF

There are five questions 1. Download the dataset “Storedata.csv” from the midter

There are five questions
1. Download the dataset “Storedata.csv” from the midter

There are five questions
1. Download the dataset “Storedata.csv” from the midterm section on Canvas. This dataset contains sales data from a department store. Available information includes: Order ID, Order Date, Shipping method, Customer ID, Customer Segment, City, State, Region, Category of item sold, Sales totals, Quantity ordered, Discount (given as a decimal percent), Return (a binary variable indicating if the product was returned, the Profit from each order, and the Profit given as a percentage of sales.
a. Create a model to estimate Profit using the Segment, the sales Region, the Category of product, and the Discount. Describe this model – what is its predictive power, and is this model statistically sound? Do you think that this is a good model? Why or why not?