KEMBAR78
Advance Data Week 2&3 | PDF | Databases | Computer Data
Scribd
Upload
61 views3 pages

Advance Data Week 2&3

1. The document defines key terms like data, information, entity, ERD, business rule, table, fields, and records. Data becomes information when analyzed and meaningful. An ERD diagrams entities, properties, and interactions. A business rule restricts database components. A table has rows and fields of different data types. A record contains specific data. 2. The document provides examples of queries on a student database table, asking for counts of students by last name or course, and the student ID of one student. It notes the number of records and fields seen. 3. The document evaluates different statements about databases, entities, attributes, and relationships between entities like one-to-one, one-to

Uploaded by

Mercy Abejo
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
61 views3 pages

Advance Data Week 2&3

1. The document defines key terms like data, information, entity, ERD, business rule, table, fields, and records. Data becomes information when analyzed and meaningful. An ERD diagrams entities, properties, and interactions. A business rule restricts database components. A table has rows and fields of different data types. A record contains specific data. 2. The document provides examples of queries on a student database table, asking for counts of students by last name or course, and the student ID of one student. It notes the number of records and fields seen. 3. The document evaluates different statements about databases, entities, attributes, and relationships between entities like one-to-one, one-to

Uploaded by

Mercy Abejo
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 3

Abejo, Mercy G.

Advance Database System


BSIT-2Z Week 2 & 3

ENGAGE
1.How we define data?what about information?is there any difference between data and information?
= Data is just some raw facts while information is when you start to process data and it makes sense
Or meaningful.There is a difference between the two because data becomes an information when
We started analyzing it.
2. Explain the differences or the relationship among data,information,and a database.
= Data is consists raw facts .Information is the result of processing the data while database is where
We will store the data.
3. What is an entity?What is an ERD?
= Entity are data’s being collected and stored. An ERD displays the connections between entity
Sets in a database.An ERD diagram depicts the logical structure of databases by describing
Entities,their properties,and the interactions between them.
4. what is a business rule?
=A business rule is a statement that puts a restriction on a specific component of the database,
Such as the items inside a field definition for a certain field or the characteristics of a given
Relationship.
5. What is a table? Describe what is a Table?What are fields? What are records?
= A table has a records(rows) and fields have different types of data,such as text,numbers,
Dates, and hyperlinks. A record contains specific data,like information about a particular
Employee or a product.

ENGAGE
1. How many students whose last names(lname) are Reyes?
= Two(2) students have last names are Reyes.
2. How many BSIT students are there?
=3 students.
3. What is the student id (studID) of a student whose course is ACT?
=115
4. How many records can you see?What about fields ?
=5 records & 6 fields.
5. How many rows can you see?What about columns?
=6 rows & 6 columns.
6. TRUE / FALSE. All students are second year students?
= TRUE
7. TRUE/ FALSE. Cristy Reyes is the oldest student.
= FALSE

EVALUATE 1
1. Information is produced by processing data.
2. The word RAW indicates that the facts have not yet been processed to reveal their meaning.
3. Metadata or data about data, through which the end-user data is integrated and managed.
4. Database exist when different versions of the same data appear in different places.
5. The Derived attribute need not be physically stored within the database;instead,it can be derived by
Using an algorithm.
6. A Required attribute is an attribute that must have a value; in others words,it cannot be left empty.
7. Business Rule is a detailed description of an organization’s help to create and enforce actions within
That organization’s environment.
8. Record is a logically connected set of one or more fields that describes a person, place, or thing.
9. An Entity in the ERM corresponds to a table – not to a row –in the relational environment.
10. A Single Value attribute is an attribute that can have only a single value.

EVALUATE II
1. A vehicle can have many colors

Vehicle Colors

2. The primary key of a car is plate Number

Car PlateNumber

3. An employee has many addresses

Employee Address

4. A Computer has many speifications

Computer Specification

5. The TotalPrice of all items

Total Price Items

EVALUATION III
1. Teacher entity and student entity.
Ans=C. many-to-many
Teachers Hass Student

2. Stuent entity and Room entity


Ans= C. many-to-many

Student Has Room

3. Bus entity and passenger entity


Ans= B. one-to-many
Bus Has Passenger

4. Dean Entity and College Entity


Ans=A. One-to-one
Dean Has College

5. Book Entity and Borrower entity


Ans= B. one-to-many
Book
Has Borrower

You might also like