Please wait, while we are loading the content...
Please wait, while we are loading the content...
Content Provider | ACM Digital Library |
---|---|
Author | Bergin, Joseph |
Abstract | In a course in Database Concepts, students design a database of their own choice. They use the Entity-Relationship approach to high level design. Students may be too free in expressing their designs with the ER approach, drawing connecting lines where inappropriate (between relationship figures), as paper and pencil do not sufficiently constrain their enthusiasm. This is similar to what is seen too often in the design of software generally.The diagram indicates that “dependent” is a weak entity set with defining relationship “Parent”, that “ssn” is the key to “employee” and that “supervision” is one-to-many from “supervisors” to “employee”. “Manages” is a one-one relationship.The software will also output a list of data definition templates for SQL, a popular relational database front end. A portion of the output for the above ER diagram is:CREATE TABLE employee ( ssn (), name (), managesdno (), supervisionssn () );CREATE TABLE worksFor ( percentTime (), ssn (), dno () ),I have recently developed an application for Entity-Relationship modeling on a microcomputer. The software permits the database designer to sketch an ER diagram and to indicate several important properties of the design (weak entity sets, cardinality, categories, etc.). The software was developed using Object Pascal and runs on the Macintosh.An example appears below.This technique has a potentially greater impact, however, on the design of software systems generally. I have been exploring the idea of using the ER technique for logical design of abstract data types modeled on entities of the problem space. In object-oriented programming it is very useful to model such entities as objects in the system. Generally, these entities have some variable state and may exhibit some actions. This is highly consistent with the notion of an object in the sense of Smalltalk. As an example of the use of this technique in the early design of a software system consider the following example ER diagram which is an overview of the data types within the Entity-Relationship program itself.The program has two major data types. These items are commands and screen_shapes. Screen_shapes are composed of lines and other shapes and these have different properties. Three kinds of commands are needed, to modify screen_shapes and text_streams.The relationships (diamonds) show the necessary interactions between the entities. Early knowledge of these interactions aids the designer in choosing appropriate representations of the state variables of each data type. One may take the view that the relationship “modifies” between key_handlers and text_streams may be defined in terms of actions such as “enter”, “cut”, “paste”, “select”, “move”, and “undo”. These must be specified early on as a means of defining the user interface. We are a long way toward knowing what a text_stream must look like, as well as a key_handler.This technique, of modeling the data with ER diagrams, is most useful if the development will be undertaken using an object-oriented system, as the state and procedure information may be encapsulated within the objects themselves. Thus, the above mentioned software has objects to model screen_shapes and objects to represent commands and these encapsulate the ideas made visible in the ER diagram. |
Starting Page | 708 |
Ending Page | 709 |
Page Count | 2 |
File Format | |
ISBN | 0897912608 |
DOI | 10.1145/322609.323170 |
Language | English |
Publisher | Association for Computing Machinery (ACM) |
Publisher Date | 1988-02-01 |
Publisher Place | New York |
Access Restriction | Subscribed |
Content Type | Text |
Resource Type | Article |
National Digital Library of India (NDLI) is a virtual repository of learning resources which is not just a repository with search/browse facilities but provides a host of services for the learner community. It is sponsored and mentored by Ministry of Education, Government of India, through its National Mission on Education through Information and Communication Technology (NMEICT). Filtered and federated searching is employed to facilitate focused searching so that learners can find the right resource with least effort and in minimum time. NDLI provides user group-specific services such as Examination Preparatory for School and College students and job aspirants. Services for Researchers and general learners are also provided. NDLI is designed to hold content of any language and provides interface support for 10 most widely used Indian languages. It is built to provide support for all academic levels including researchers and life-long learners, all disciplines, all popular forms of access devices and differently-abled learners. It is designed to enable people to learn and prepare from best practices from all over the world and to facilitate researchers to perform inter-linked exploration from multiple sources. It is developed, operated and maintained from Indian Institute of Technology Kharagpur.
Learn more about this project from here.
NDLI is a conglomeration of freely available or institutionally contributed or donated or publisher managed contents. Almost all these contents are hosted and accessed from respective sources. The responsibility for authenticity, relevance, completeness, accuracy, reliability and suitability of these contents rests with the respective organization and NDLI has no responsibility or liability for these. Every effort is made to keep the NDLI portal up and running smoothly unless there are some unavoidable technical issues.
Ministry of Education, through its National Mission on Education through Information and Communication Technology (NMEICT), has sponsored and funded the National Digital Library of India (NDLI) project.
Sl. | Authority | Responsibilities | Communication Details |
---|---|---|---|
1 | Ministry of Education (GoI), Department of Higher Education |
Sanctioning Authority | https://www.education.gov.in/ict-initiatives |
2 | Indian Institute of Technology Kharagpur | Host Institute of the Project: The host institute of the project is responsible for providing infrastructure support and hosting the project | https://www.iitkgp.ac.in |
3 | National Digital Library of India Office, Indian Institute of Technology Kharagpur | The administrative and infrastructural headquarters of the project | Dr. B. Sutradhar bsutra@ndl.gov.in |
4 | Project PI / Joint PI | Principal Investigator and Joint Principal Investigators of the project |
Dr. B. Sutradhar bsutra@ndl.gov.in Prof. Saswat Chakrabarti will be added soon |
5 | Website/Portal (Helpdesk) | Queries regarding NDLI and its services | support@ndl.gov.in |
6 | Contents and Copyright Issues | Queries related to content curation and copyright issues | content@ndl.gov.in |
7 | National Digital Library of India Club (NDLI Club) | Queries related to NDLI Club formation, support, user awareness program, seminar/symposium, collaboration, social media, promotion, and outreach | clubsupport@ndl.gov.in |
8 | Digital Preservation Centre (DPC) | Assistance with digitizing and archiving copyright-free printed books | dpc@ndl.gov.in |
9 | IDR Setup or Support | Queries related to establishment and support of Institutional Digital Repository (IDR) and IDR workshops | idr@ndl.gov.in |
Loading...
|