Q1: Data Modelling is the primary step in the process of database design. Compare and contrast Conceptual data model versus Physical data model. Illustrates with help of example to list down data (entities), relationship among data and constraints on data.

Q2: What strategic competitive benefits do you see in a company’s use of extranets?

Answer these questions using the Federal Reserve Bank of St. Louis's database.

Calculate the 12-month percentage increase in the consumer price index, and plot this, along with the unemployment rate. Do you observe a positive correlation, a negative correlation, or a correlation that is essentially zero? Can you find a Phillips curve relation or reverse Phillips curve?

: Pam Tarver just opened an information technology consulting company and has thought for a long time about what to name it. She finally settled on the fictitious name Infoxx. Search the USPTO database to determine if the name Infoxx is available. Is it? If it is available, describe how Pam would go about obtaining a trademark on Infoxx or any other name.

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?