Data Analysis

A University wants to keep track of its students. Answer the following questions: (25)

 

• Check whether the following is data or metadata:

 

1. Student’s Name.

 

1. Student’s Contact information.

 

1. Student’s Birth Date.

 

1. Contact Information is a long integer.

 

1. Student name is a string of not more than 50 characters.

 

2)   The following are some data checks whether the data is structured or unstructured

 

1. Image of Student’s ID.

 

1. Student Name, contact information, and age.

 

1. Students score information.

 

1. Messages using their chatbot service.

 

1. Fees Invoice Information

 

 

       3)     Identify the following Attribute Data Type or Instance.

 

1. Students ID is integer.

 

1. Student name is Robert.

 

1. Birthdate should be Date type.

 

1. The student gender is Male.

 

4. Student’s overall GPA is 4.

 

 

      4)    Identify the data type of the following and give examples of one instance each:

 

1. Student Name

 

1. Student admit number

 

1. Student Birthdate

 

1. Student Email Address

 

1. Student Red ID

 

 

 

 

      5)  Complete the following table:

 

 

 

Attribute	Required or Optional	Simple or Composite	Single-Valued or Multi-Valued	Stored or Derived
Student ID	Required	Simple	Single Valued	Stored
Student Name
Student Address
Student Contact
Student Birthdate
Student age

 

 

 

 

 

2)  Draw an ER diagram for the following problem. You can use any software or online tools or draw it by hand. (15)

 

Wikipedia is interested in creating a database to manage its website. Wikipedia works in several different languages, each of which has a language code and common name. Wikipedia has many pages, each of which have a name, text, and date created. Each page can exist in several languages. Wikipedia has users that edit each page, each of whom have a legal name, username, email address, and one primary language.  Each user can edit multiple pages, and a page can be edited by multiple users.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

3) Regarding the entity-relation diagram below answer the questions. (10)

 

 

 

1. An airport can have many Airlines?

 

1. Can SSN be a Multivalued Attribute? Why or why not?

 

1. How many flights can be assigned to a Pilot?

 

1. Can there be zero airlines at the airport?

 

1. Identify strong entities and weak entities for all the entities.

 

1. Can an Airline be assigned to multiple Airports (give an answer according to the ER diagram)?

 

1. Add an entity passenger and give its attributes.

 

1. Which of the attributes in Pilots can be considered as a multivalued attribute?

 

1. How many flights can be assigned by the airlines?

 

1. Write all the relationships in the ER diagram.

 

 

 

4) Give difference between the following in your own words:                                                              (5)

1. Data and information.

 

 

 

 

1. Data and Metadata.

 

 

 

 

 

1. Structured data and Unstructured data.

 

 

 

 

 

1. Data Dependence and Data Independence.

 

 

 

 

1. Strong Entities and Weak Entities.

 

 

 

 

5) Define Data Warehousing.                                                                                                              (5)

 

 

 

 

 

6) Explain File Processing systems and the Database Approach. What are the advantages of Database Approach over the File Processing Systems? Give examples for the same.                                                 (5)

 

 

 

 

 

 

 

 

7) Explain System Development Life Cycle.                                                                                    (5)

 

 

 

 

 

 

 

8) Explain different types of relationships.                                                                                                       (5)