1

Solved Assighnments

AIOU

 

 

 

 

 

 

 

Course: Databases-I (3410) Semester: Autumn 2015

Level: Associate Degree in Commerce Total Marks: 100

Pass Marks: 50

(Unit 1–4)
Note: All questions are compulsory. Each question carries equal marks.

ASSIGNMENT No. 1

Q-1   a) What is meant by database? define and explain it with the help of proper examples 

examples

b) briefly  explain the different types of database with the help of suitable examples


Q. 3 The figure below shows a class list for AIOU. Convert this user view to a set of 3NF relations. Assume the following: (20)
a) An instructor has a unique location.
b) A student has a unique major.
c) A course has a unique title.

Allama Iqbal Open University
Class List – Spring 2015
Course Code: 1431
Course Title: Fundamental of Computers
Instructor Name: D.EF
Instructor Location: A-0002
Student ID
Student Name
Major
Grade
25210
AA
SE01
A+
23735
BC
DF02
B+
27265
CD
SE03
C+
27399
DE
DB04
D+
...
...
...
...
b) What are the major differences between primary key & foreign key? Explain it in detail with the help of suitable examples. (10)

Q. 5 Write short notes on the following terms:
c) Symbols (05)
d) Subtypes (05)

ASSIGNMENT No. 2
(Unit 5–8)

Total Marks: 100 Pass Marks: 50


Note: All questions are compulsory. Each question carries equal marks.

Q. 1 a) Define logical database model. What are its types? Explain it in detail with the help of suitable examples. (10)
Ans types
(1) physiacal data model
(2) conceptual data model
 
b) Define physical database design. Explain its main components and major objectives in detail. (10)

b) Explain briefly the four basic components of a report. (10)



Q. 5 Write short notes on the following terms: (20)





3410 Database-I
Credit Hours: 4 (3 +1)
Recommended Book:
Modern Data Base Management by Jeffery A. Hoffer and Oracle Developer/ 2000

Course Outlines:

Unit–1 Database Foundation
Introduction, Data and Information, Components, Advantages, Data Association, Entities, Keys and Its Types, Attributes, Data Associations, Data Structure Diagram

Unit–2 E-R Model
Basic Constructs (Symbols), Degree of Relationships, Cardinality, Gerund, Modeling Time Dependent Data, Super Types, Subtypes

Unit–3 Data Models
Hierarchical, Network, Relational, Comparison of All Data Models, Relation, Characteristics of Relation, Converting E-R Model into Relation

Unit–4 Normalization
1NF, 2NF, 3NF

Unit–5 Data Base Design
Conceptual Design, Physical Design

Unit–6 SQL Introduction
Introduction, Creating, Altering & Deleting Table, Inserting, Updating, & Deleting Rows, Querying The Tables, SQL Functions (Arithmetic, Group (Avg, Count, Max, Min, Sum), Date, Special Functions (In, Between, Like, Null)), Managing Multiple Tables

Unit–7 Introduction to Forms
Form Components, Form Module, Blocks, Items, Objects, Object Navigator, Properties Window, Layout Editor

Unit–8 Basic Form Design
Using Wizard for Form Design, Customizing a Form, Defining Items (Buttons, Check Boxes, Display Items, List Items, Radio Groups, Text Items), Creating LOV, Creating Master Detail Form

Unit–9 Introduction to Report
Report Design Considerations, Report Objects, Basic Report Design.



                                                   

 

Post a Comment

  1. please send 2015 data base solved assignment papers immediatly on my mail

    ReplyDelete

 
Top