Reference no: EM132601224

Assignment - Database Management System

Question # 01
Make an ERD for the Following:
a) BOOK and AUTHOR
b) HIGHWAY and EXIT

Question # 02 Difference between following points
a) Data, Information and Metadata
b) Structured Data and Unstructured Data
c) Repository and Database
d) Data Warehouse and ERP System

Question # 03. For a driver's license bureau maintains a database of licensed driven. State whether each of the following represents data or metadata. If it represents data, state whether it is structured or unstructured data. If it represents metadata, state whether it is a fact describing a property of data or a fact describing the context of data.
a. Driver's name, address, and birth date
b. The fact that the driver's name is a 30-character field
c. A photo image of the driver
d. An image of the driver's fingerprint
e. The make and serial number of the scanning device that was used to scan the fingerprint
f. The resolution (in megapixels) of the camera that was used to photograph the driver
g. The fact that the driver's birth date must precede today's date by at least 16 years

Question # 04. Draw ER Diagram that represents the following business rules.
Suppose you are given the following requirements for a simple database for the Pakistan Super League (PSL):
• PSL has six teams namely Quetta Gladiators, Peshawar Zalini, Karachi Kings, Lahore Qalanders, Islamabad United, and Mahan Sultans.
• Each team has a name, a coach, a captain, and a set of players,
• Each player belongs to only one team,
• Each player has a name, age, a playing role (such as batsman or bowler or all-rounder), and season performance,
• A team captain is also a player,
• A match has a match number, match date (such as Feb 14th, 2019), ground (such as Dubai Cricket Stadium), a score (such as 171/8 to 177/5), and result.
• A match is played between exactly two teams (referred to as host_team and guest team) and a team plays many matches,
• A player may play many matches and for each played match his performance (e.g. 65 run, or 2/24, or 37,4/29) is tracked.
Construct a clean and concise ER diagram for the PSL database containing all primary keys, attributes, relationships, connectivities, and cardinalities.

Question # 05 Show the Business Rules:

Question # 08. Answer the following questions briefly:
a. How are relationships between tables expressed in a relation database?
b. Explain the differences between user views, a conceptual schema, and an internal schema as different perspectives of the same database.
c. State a rule that says when to extract an attribute from one entity type and place it in a linked entity type.
d. State two conditions that indicate when a database designer should consider using Supertype/Subtype relationships.