Draw a data model for the following:

A travel agency is frequently asked questions about tourist destinations. For example, customers want to know details of the climate for a particular month, the population of the city, and other geographic facts. Sometimes they request the flying time and distance between two cities. The manager has asked you to create a database to maintain these facts.

Design Of Database System Course

True or False

1. In MySQL, it is possible to create a table by using the definition of another table.

2. {(t.lname) | s ∈ Student, s.stuId = t.stuId, t ∉ Graduate_Student, s.major = ‘CS’} is a safe relational calculus expression.

3. In SQL, it is possible to insert multiple rows into a table using a single INSERT statement.

As a volunteer at a local library, you see that library uses a system which stores member, books and other data in text files. This system was commissioned long ago, developed by one of the staff members. You are asked by the librarian to explain the limitations of file-based approach to a committee to evaluate implementation of a system that uses a database to store information.                                                  

Database - Relational Theory

The state of a table or relation relates to its current content. Consider the formal terminology of the relational model. 1) Which descriptive term of a relation applies to the state of a relation? 2) Which descriptive term of a relation is not affected a change in the state of the relation? 3) In addition to identifying these terms, provide a brief definition of each of term.

If your customer states that there is a system requirement that the System of Interest (SoI) must perform a task to navigate to specific named locations in a store, which leads to another requirement (unstated by the customer) that the system must access a database that contains the names of the locations and their respective locations (grid coordinates). What type of relationship exists between the two requirements?

[Big Data concept] (10) Give one example of Big Data application you know. Use the detailed example to explain each of the five Big V’s. If you are required to design a database system for this application, what are the best data models (relational, XML, RDF, among others) you would use to represent the data and why?

PHP

Review

For the Programming part:

1. Where (Which directory) you store the database connecting information? parallel to htdocs folder why? no one can access except the admin

2. difference between GET and POST methods

3. Include multiple files: include, include_once, require, require_once

4. what is a sticky form?

Letter Separated Numbers (C++)

I've encountered a corrupted database that has a series of important numbers, but instead of being separated by a space, the spaces have been randomly changed in alphabetic characters. Write a function named "my_numbers" that can take a string like "18y5638b-78" and return a vector of ints {18, 5638, -78}.

Thanks!

Develop a function to read a document in the MongoDB database “city” in the collection “inspections.” Be sure it can handle error conditions gracefully.
a. Input -> arguments to function should be the key/value lookup pair to use with the MongoDB driver find API call
b. return -> result in JSON format if successful else MongoDB returned error message

1. You work for Mooney’s Consulting. They have assigned you to an engagement with Anavrin a healthfood café based in Los Angeles. The company currently only produces and sells organic sandwiches, pastries, coffee, and smoothies. They currently spend anywhere from $5,000 to $25,000 per year on marketing with the majority of this being on billboards and viral media targeted at the Los Angeles market. They maintain all their records within an Access database. They have provided you with access to their database which contains the last eight years of data about the company, including all sales, spending, customers, vendors, and employees. Anavrin has hired Mooney’s Consulting (You) to determine if their advertising budget and approach is optimal.

Required: Below, write each step of the IMPACT cycle then determine the steps you would take pertaining to this specific engagement for each step of the cycle. Be specific on what actions you would take, writing at least 3 sentences describing your actions for each step.