DB Architecture Le el:01 Objectives: 1. Understanding of First Two-Level Databas

Question

DB Architecture Le el:01

Objectives:

1.Understanding of First Two-Level DatabaseArchitecture.

2.Preparing the students for implementing andrealizing the system for External

view of Database.

3.Finding of Entity Types,theirattributes,Relationships b/w them,Roles in ER i

System details.

4.Using of tools used for database SystemDevelopment like DFD,Context

Diagram,Level 0 Diagram.

5.Understanding of Semantic data model.

6.Development of Conceptual Database design inE-R Data model.

DB Architecture Le el:01

I this course we are going to develop Database of LearningManagement

System (LMS).Our DB architecture includes all the features thata moder

LMS should have.We will focus mainly on following module’s DB design.

a.Content Management System.

b.Assignment Management System.

c.GMBD.

d.Exams

e.Quizzes

f.Grade Book System.

I coming DB Architecture levels we shall develop or implementthe physical

design of GradeBook System (optional).So in DBarchitecture Level 1,you shall

have to give full attention to External view and Conceptual orlogical view of all

above mention modules of LMS.

Need to Do..

PART A:10

Design and dra an Detaile DFD that captures theinformation about the

learning Management System (LMS).

PART B:15+15

Design and dra an Context Level diagram an Level 0Diagram(from b to f )except

Content Management System that captures the information aboutthe learning

Management System (LMS).

Virtual University of Pakista

DB Architecture Le el:01

PART C (Not this time)

About Coming Extended DB ArchitectureLevel:01 (due date soon be

declared)&be ready for it

In Coming level you shall have to Design and dra an ERdiagram.

Use only the basic ER model here,thatis,entities,relationships,and

attributes.Be sure to indicate any key and participationconstraints.

Note:

Don ’t forget to assume the administration side ofLMS along with

client side entity types,their attributes and theirrelationship with

each other.

Database De elopment Process:(approach2)

Ref.page #43(cs403 vu handouts)

1 st STAGE (AnalyzeUser Environment)

What shall you have to do?

Nothing special as Our Customer has liked VULMS system.Now you

should have to analyze your Environme t and draw well modifyConceptual Design of

above mention Modules of System.

You can find the entity types and their attributes by browsingmodule relate WebPages.

Relationship in ER Data Model:

Using your visioning power and common se se after analyzing theuser environment

develops the relationship b/w different Entity types.Along withmin,max cardinality

types,Roles in Relationship,find Dependency and Constraints

Virtual University of Pakista

Explanation / Answer

i can understand all VU students. now complety youerassignments youer self. VU students not try for anyassignment they post on cramster and wate for solution.. it's notgood. I request all students first they try tosolve assignment then post.
best regarded Syed Aqeel Abbas Gillani. syed_gillani95@yahoo.com and i am student BS (CS)

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.