Task 1: Distributed Database DesignThe assignment will entail reading a range of academic papers, journals and books. You will be writing reports and designing Distributed Database Systems and Data Warehouse Systems. Happy Cruise Lines is a cruise company with several ships and a variety of cruise itineraries, each involving several ports of call. The company headquarters is in New York and has regional offices in the cruise port cities...
Part 1: Software Requirements SpecificationPart 1: Software Requirements Specification One of the first tasks in the development of a software application is to gather and document the requirements. The requirements will be used in all other phases of the project so they are vitally important. For this assignment, you will be creating the Software Requirements Specification (SRS) for your Software Development Plan you started in Module 1 (you...
Student-GPA Table QueriesPlease write the Sql to answer the following questions. You may use subquery but all questions need to be completed in One Sql. You also need to use the following tables (Student and GPA) to answer Q1— Q3. Student_ID Student_Name Ad dre ss_1 Ad dre ss_2 City State Zip Country ...
What software development process model would you select for the project?The development team working on this project has 9 experienced members/ developers, who have worked together on several projects. Many of them, however, havenât deployed products on AWS. Based on the above information answer the following questions: 1) What software development process model would you select for the project? Briefly explain ...
Part 1 - The DataStudents will design and implement their own database based on publicly available data. Students will model the database using the models learned in class, apply techniques learned in class, and use SQL to formulate and run some queries. Group Setup Projects may be done individually or in groups of up to five. Students are free to select their own group. ONE member per group should leave a message stating all group members in ...
Overview of the Final ProjectThe final project for this course is the creation of a System Proposal Document.In any modern enterprise, it is crucial that all of the different stakeholders, users, inputs, and outputs that relate to the businessâs IT systems coalesce in a logical and cohesive way for the systems to be effective. As a member of an IT team, your overarching goal is to ensure that the IT systems ultimately do what...
DataMy project is "image captioning using attention mechanism" using the models cnn and lstm to implement the project. write methodology of image captioning project. for example data collection software and libaries used methods used to implement the project image captioning. please use relevant references. am attaching two files please use as reference to write the methodology which is almost similar. Technology being an integral part of o...
Project BackgroundRetail chosen: Clothing retail store Choose a retail business that sells products to its customers and create a database to store data and register different daily transactions. Â Consider the following in your design: Â 1. The retail business should register information about the products it sells. 2. The details of its customers including their billing and delivery address and the product suppli...
Dimension Selection and Fact IdentificationQuestion: Having established the online transaction processing database, Ms. Heritage wants more intelligence information from the available data and she is looking for a potential data warehouse for MT. As the first step in this process, she expects to setup a data mart for ticket sales as the first step. The data mart should satisfy the following analysis requirements: ⢠Yearly total...
Query Design View for Customers Table1.Personal Insurance, Inc. is a national company that insures homeowners and renters. It also offers umbrella policies that provide additional coverage. As a regional manager, you need to be able to query the database to help make decisions and to answer questions from other employees. Create a query based on the Customers table in Query Design View with the following options:Add the CustomerI...
Tasks to be undertakenTasks to be undertaken: An Activity Diagramfor the process of managing a âNew Online Orderâ. This should include the registering of the new customer online; creation of customer record online; creation of payment details; the delivery schedule with HECO; allocation to driver and recording delivery. A Use Case Model for the Swift Distribution Ltd. N.B. a Use Case Model comprises ...
About High Liner Foods Inc.High Liner Foods Inc. is a processor and marketer of value-added frozen seafood products, including the popular High Liner, Fisher Boy, Mirabel, Sea Cuisine, Royal Sea, FPI, and Viking brands. Originally founded in 1899 as a salt fish operation in Lunenburg, Nova Scotia, the publicly-traded company has additional locations in Canada, as well as in Massachusetts and New Hampshire. With revenues of $585 million, this com...
Mission statementYou should submit two files. The first file is a Word document that contains your ER Diagram, Relational Model, and SQL queries. For the SQL queries, screenshot the input (20 SQL queries) and the output ( Mission statement: The purpose of the NU Hospital database application is to maintain the data that we generate and to provide an efficient, effective, and friendly health care provision service for our elderly patients. Miss...
Part 1 – Understanding the dataIn this assignment, you are given a set of data encoded in some file format. The objectives are:1) Understand the data using the file descriptions and the knowledge graph in this document. 2) Design the schemas for data storing and manipulation in two database management systems (DBMS): Oracle SQL and MongoDB (NoSQL).3) Insert the data into the DBMSs.4) Write queries to answer specific questions.5) Observe t...
ObjectiveObjective:The objective of this assignment is to create a simple PHP application to perform CRUD (Create, Read, Update, Delete) operations using a flat-file (no database). This will enable students to practice using arrays, iterations, conditional statements, and user-defined functions. Students will also have the opportunity to use Bootstrap in their application to present their content/pages responsively.Operations:Implement a user-fr...