Data Management for BA Day I

What ERD building blocks can you extract from this sentence: “A physics textbook is co-authored by three scientists”.

• “Textbook” is an entity, “scientists” are attributes, and “authored by” is a relationship.

• “Textbook” and “scientist” are entities, “physics” is an attribute of the “textbook”, and “authored by” is a relationship.

• “Textbook” and “author” are entities, “scientist” is an attribute of the “textbook”, and “authored by” is a relationship.

• We cannot extract anything from this sentence.

At the end of an educational video, the students are asked to rate it on a scale from “Excellent”, to “Good”, “Just OK” and “Not useful”. How would you describe the data type that represents these ratings?

• Ordinal

• Nominal

• Quantitative

The instructor has received a report showing which students have watched the course video. What data type would you choose to capture whether each student has completed watching the video?

• String

• Integer

• Boolean

• Decimal

What is true about XML (eXtensible Markup Language)?

• All XML tags must be in lower case

• Spaces are allowed in the tag names, but not between the XML elements

• Closing tag must be the same as the starting tag

• All XML tags are case sensitive

Which is not a correct name for an XML element?

• TAX

• income_tax_2021

• 2021income

• _incometax

What key elements must be present in an ERD?

• Entities and their attributes.

• Entities, attributes, relations and dimensions.

• Facts and entities.

• Entities and relationships.

What is the most appropriate name for a data entity that will capture online academy users?

• StudentName

• Student

• Students

• Student0001

A restaurant's database stores all the recipes used. The database contains relations representing data entities Recipe and Ingredient. What do you think is the relationship between these entities?

• One to one

• One to many

• Many to many

• There is no relationship

What is true about XML?

• It is a proprietary language that requires licensing.

• It cannot be interpreted by a human without special translation software.

• It describes the format of datasets stored elsewhere.

• It allows storing the information itself and describing the structure of the information in the same file.

Which line shows proper nesting of XML elements?

• <tree>  <roots>  </roots>   <branches>  <twig> </twig> </branches>  </tree> 

• <tree>  <roots>  </roots>   <branches>  <twig> </branches>  </twig>  </tree> 

• <tree>  <roots>  <branches>  <twig> <twig> </twig> </branches>  </roots>   </tree>

• <tree>  <branches>  <twig> </twig> </branches>  </roots>   </tree>