Database Management Systems: Exam Questions and Solutions
Database Exam Solutions
2025 Q&A
(a) Q: A minimum cardinality of 0 specifies ______ type of participation.
Ans: Partial participation
(b)
Q: Let E1 and E2 be two entity sets with relationships R1 (1:M) and R2 (no attributes). What is the minimum number of tables required?
Ans: 2 tables
(c)
Q: Stud has 120 tuples and Enroll has 8 tuples. What are max and min tuples in Stud NATURAL JOIN Enroll?
Ans:
- Maximum = 8
- Minimum = 0
(d)
Q: Which normal form is considered adequate for normal relational database design?
Read MoreReconciling Evolutionary Biology and Biblical Scripture
Reconciling Faith and Evolutionary Biology
I’ve been thinking about our conversations regarding evolution and faith. In my university science and religion class, we recently studied the Galileo Affair. It’s remarkable how his clash over astronomy mirrors our modern debate over biological evolution. Galileo was a devout Christian who found total harmony between his faith and his science. Based on his views, here is why I believe it is possible to accept both evolutionary biology and the Bible:
Read MoreEnvironmental Law and Sustainability: Core Principles
1.1 What is Environment?
The word “environment” derives from the ancient French word “environner,” meaning to encircle. It refers to all surrounding conditions — natural, social, and cultural — that influence life.
Section 2(a) — Environment (Protection) Act, 1986
Environment means and includes:
- Water, Air, and Land
- The inter-relationship which exists among and between water, air, and land
- The inter-relationship which exists among and between water, air, land, human beings, other living creatures,
Modern Banking Systems and Financial Technology
Core Banking Solutions (CBS)
Core Banking Solutions (CBS) refers to a centralized, real-time banking system where all branch servers are connected to a central data center. It allows customers to access accounts, deposit, or withdraw money from any branch or channel (ATM, internet) 24/7. Key features include 360-degree customer views, automated processing, and enhanced security.
Vacuumlabs
Vacuumlabs
Key Aspects of Core Banking Systems
Definition: “CORE” stands for Centralized Online Real-time Exchange.
Read MoreCanadian Civics: Rights, Government, and Democracy
Civics Basics
- Study of: Rights, responsibilities, decision-making, and the common good.
- Thinking Model: What? So What? Now What?
Rights, Freedoms, and Responsibilities
- Rights: Legal entitlements (e.g., religion, expression, language, equality).
- Freedoms: The ability to act or think without interference (within legal limits).
- Responsibilities: Obeying laws, voting, jury duty, protecting the environment, and helping the community.
Common Good and Civic Action
Civic actions: Voting, volunteering, protesting,
Read MoreEssential Accounting and Corporate Finance Concepts
Foreign Currency Transaction Conversion
Conversion of foreign currency transactions refers to the process of converting transactions carried out in a foreign currency into the home currency of a country. This is necessary because businesses involved in international trade deal with multiple currencies (e.g., dollars, euros), but their accounting records must be maintained in a single currency. Due to fluctuations in exchange rates, the value of foreign currency changes; therefore, conversion ensures
Read MoreEssential Aircraft Maintenance and Ground Handling Procedures
Aircraft Jacking
Jacking an aircraft is a critical maintenance operation requiring strict adherence to the manufacturer’s specified equipment and instructions to ensure safety and prevent structural damage. Always consult the aircraft manual for specific procedures and ensure the aircraft is in the correct configuration with necessary doors closed and stressed panels installed.
Use only the specified jacks and jack pads, which protect the airframe. Most aircraft need 3 or 4 jacks, with jacks placed
Read MoreIntegrated Marketing Communication: Planning, Strategies, and Tools
UNIT 1. IMC Planning Model and Communication Process
1. Introduction
Integrated Marketing Communication (IMC) is a strategic approach that ensures all forms of communication and messages are carefully linked together to deliver a clear, consistent, and compelling message about the organization and its products.
The IMC planning model provides a structured framework for developing and implementing effective communication strategies.
2. Concept of IMC Planning Model
The IMC Planning Model refers to a systematic
Read More3 pillars of negotiation
Lecture 1: The Individual at the Heart of Global Issues
This lecture defines our modern world through the lens of interdependence and the multi-dimensional nature of globalization.
Definition of Globalization: A complex process of increasing integration of economies, cultures, and societies characterized by a rise in trade, financial flows, and transnational communication.
The Butterfly Effect: Interdependence means a factory closure in China can empty shops in France.
The 4 Pillars of Economic Globalization:
Read MoreAll gust lines in the V-n graph originate from a point where the
- Fractions
Add/subtract: make the bottom number the same first
Multiply: top × top, bottom × bottom
Divide: keep, change, flip
Example:
1/2 + 1/4 = 2/4 + 1/4 = 3/4
2/3 × 4/5 = 8/15
2/3 ÷ 4/5 = 2/3 × 5/4 = 5/6
- Sig fig and decimal places
Decimal places: count digits after the decimal point
Significant figures: start at first non-zero digit
If next digit is 5 or more, round up
Example:
3.456 to 2 decimal places = 3.46
0.00456 to 2 sig fig = 0.0046
- Factorization
Common factor: take out the biggest factor
Quadratic: