Database design process case study

Since all phases are computer generated, they all contribute in part to the final documentation.

erd case study examples with solutions pdf

A revised data dictionary is required, with sensible field names ensuring column types reflect system requirements, ensure union compatibility and naming consistency for like fields between tables.

During this phase, they develop their understanding of how the system might look, what services may be offered within the system and the general 'look and feel'.

database case study examples with solutions pdf

Therefore, your focus should always be on the concept or technique being presented, not on the example itself. Students are required to provide documentation on two levels: User documentation involves language aimed at the end-user of the system.

Experience has shown that students will believe they can tackle anything, given enough time.

Database case study pdf

It is when students want to do something out of the 'ordinary' that Access proves difficult, with students being forced to descend into Access BASIC modules instead of Macros and simpler structures. This enables me to present the process with some degree of continuity. Technical documentation requires a more formal form of communication, suitable for another system developer. This is seen as advantageous as students not only learn about the database design process, but are forced to put that theory into practise immediately for marks. Students that are going to propose an 'unknown' topic are generally asked to pre-propose ie. The following marking scheme and weightings have been applied to the assignment: Phase. The 'user manual' includes instructions for use, system application and limitations. Undaunted, Mike has decided to hire a database consultant to design the database for him. Using them in this manner allows me to demonstrate that once you learn how to apply a particular concept or technique generically, you can then apply it to any other database you're designing. Using the 'primary data sources', students identify what will be stored in the system, and the relationships that bind them. The assignment is timed to coincide within 2 weeks to actual content coverage in class and complements the theoretical work being done in class. This phasing or staging of the assignment forces students to consider a production time line. Ideally, upon implementation of this database, a systems analyst would have been assigned the task of designing a module dedicated to special scholarship billing; this has not been the case. This phase requires students to identify their target audience - this will be important later as they produce their View Definition and Menu system, as well as their User Documentation. I provide only a few details about the company in this chapter, but I'll supply more as I present each new concept or technique.

Each object to be used in the system is formally defined in a data dictionaryand all relationships are listed and instantiated.

If students have difficulty finding 'primary data sources', they are generally discouraged from pursuing the system.

Database design case study examples

He records sales on preprinted forms, maintains employee and vendor information on sheets of paper storing them in manila folders , and writes information about his regular customers on index cards. Summer II June - August for various scholarships. I've drawn these examples from a variety of databases and used them in an arbitrary fashion. Experience has shown that students will believe they can tackle anything, given enough time. During this phase, they develop their understanding of how the system might look, what services may be offered within the system and the general 'look and feel'. Using MS Access, students create tables, forms, queries, reports and macros necessary to present database services to the end-user. Students unable to complete a phase are welcome to forego the marks in order that the phase is completed for them in consultation with their teacher. This enables me to present the process with some degree of continuity. To do this, students draw on their experience of windows applications, previous assignments and a little common knowledge. As you learn new concepts or techniques, Mike will supply you with the information you need to complete the design of his database.
Rated 6/10 based on 63 review
Download
Fidel A. Captain