An intelligent tool to support requirements analysis and conceptual design of database design

With the rapid development of network technology, music websites gradually become a popular, and the emergence of pop music website is to meet the people's strong demand for popular music, because database plays an important role in the design of website, studying the database design of pop music website development is important. From the conception of database design, firstly, this paper studies conceptual design for the database design, conceptual design is mainly reflected in the form of an E-R diagram; then conducted logical in the database design, logical design is expressed by the pattern of table structure; finally, studies the security design of database design, describes the security policy of database. The studied content of this paper plays a supporting role for popular music website design, promotes the combination of music and websites, and enriches people's leisure life.

Download Full-text

Advanced Aircraft Electrical System Control Technology Demonstrator. Phase I. Requirements Analysis and Conceptual Design.

10.21236/ada103922 ◽

1981 ◽

Author(s):

G. L. Dunn ◽

P. J. Leong ◽

I. S. Mehdi

Keyword(s):

Phase I ◽

Conceptual Design ◽

Requirements Analysis ◽

System Control ◽

Control Technology ◽

Electrical System ◽

Technology Demonstrator

Download Full-text

The Analysis of Database Based on Road Disease Detection

Applied Mechanics and Materials ◽

10.4028/www.scientific.net/amm.533.456 ◽

2014 ◽

Vol 533 ◽

pp. 456-459

Author(s):

Wan Jun Ji ◽

Xu Qiao ◽

Kai Zhu ◽

Feng Yang

Keyword(s):

Statistical Analysis ◽

Detection System ◽

Database Design ◽

Requirements Analysis ◽

Disease Detection ◽

System Implementation ◽

System Database ◽

User Management

Road disease detection system is the process of obtaining road subgrade information detected by geological radar to consider user management. at the same time, the user can carry on the statistical analysis to obtain information. In the process of system implementation, Database is the foundation. Database design must be combined with the requirements analysis, in this way can the database design more reasonable. Thus, to establish a reasonable, feasible database is crucial for the realization and application of the system, this paper mainly discusses the system database.

Download Full-text

Experimental study on the effectiveness of a teaching approach using barker or Bachman notation for conceptual database design

Computer Science and Information Systems ◽

10.2298/csis180322008k ◽

2018 ◽

Vol 15 (2) ◽

pp. 421-448 ◽

Cited By ~ 1

Author(s):

Aida Kamisalic ◽

Marjan Hericko ◽

Tatjana Welzer ◽

Muhamed Turkanovic

Keyword(s):

Experimental Study ◽

Conceptual Design ◽

Learning Process ◽

Data Model ◽

Relational Databases ◽

Education Institution ◽

Database Design ◽

Teaching Approach ◽

Logical Design ◽

Logical Data

Relational databases are one of the pillars of information systems and as a consequence conceptual and logical design can be seen as the foundation of almost every application regardless of the platform. Nevertheless, little research has been done so far on the effectiveness of teaching approaches to database basic concepts and design. This paper introduces a multi-level experimental study developed to examine the effectiveness of learning database fundamentals, depending on the notation used for conceptual design. The main experiment was carried out at a higher education institution. We developed different experimental instruments to evaluate the effectiveness of a teaching approach using Barker or Bachman notation for conceptual database design. In contrast to Barker notation, Bachman notation incorporates elements of logical design (i.e. foreign keys) in the conceptual design level. Students? achievements were examined with regard to influencing factors throughout the learning process. Introducing the Bachman notation and a manual transformation from a conceptual into a logical data model, could increase students? understanding of conceptual, logical and relational data model concepts. We found that the notation used during the learning process has an impact on students? achievements. Moreover, students achieved better results when solving tasks presented with a notation that incorporates elements of logical design into the conceptual level. Finally, we required the use of manual transformation from a conceptual into a logical data model and the results confirmed an increase in students? understanding.

Download Full-text

Analisis dan Perancangan Sistem Basis Data Catatan Waktu Kerja dan Proyek Karyawan pada PT Rekayasa Engineering

ComTech Computer Mathematics and Engineering Applications ◽

10.21512/comtech.v4i2.2540 ◽

2013 ◽

Vol 4 (2) ◽

pp. 983

Author(s):

Rhio Sutoyo ◽

Franky Hadinata Marpaung

Keyword(s):

Conceptual Design ◽

Database Design ◽

Database System ◽

Physical Design ◽

Working Time ◽

Working Model ◽

Logical Design

The purpose of this research is to analyze and implement a system for recording employee working time and project time, leave request, overtime request, proposal submission, and paperwork revisions registration at PT Rekayasa Engineering. Collecting information is conducted by surveys to the company, interviews with several employees in the company, and examining documents and procedures used by PT Rekayasa Engineering. The database design is created using lifecycle methodology, namely: conceptual design, logical design, and physical design. The result of this research is a database system which is designed and can be used to process operational procedures of the company and to record the working time and project needed by the PT Rekayasa Engineering. Furthermore, this research also produces a prototype application that can be used as a working model for the system. Using the new database system and the application, information needed by the company is fulfilled. Thus, it allows the company to work more effectively and efficiently.

Download Full-text

Database Design on Warehouse Information System of College Music Equipment

Applied Mechanics and Materials ◽

10.4028/www.scientific.net/amm.543-547.4593 ◽

2014 ◽

Vol 543-547 ◽

pp. 4593-4596

Author(s):

Xin Xin Lv

Keyword(s):

Conceptual Design ◽

Database Design ◽

Active Role ◽

Requirement Analysis ◽

Equipment Management ◽

Warehouse Management ◽

Basic Work ◽

College Music ◽

Process Database ◽

Music Class

With the national efforts to increase investment for quality education and an increase in the number of college enrollment music class students, so the college needs more music equipments. The college always faces challenge of the comprehensive information management for music equipments. This paper bases on requirement analysis for warehouse management of music equipment to conduct database design. Requirement analysis uses UML to conduct use case modeling and describes management process; database design conducted conceptual design and logical design; conceptual design represents by E-R; logic design bases on convert rule to design and represents by ten table structure. Content of this paper is the basic work of software development and provides support for the development of warehouse management system of music equipment, will play an active role in promoting the construction of college music equipment management information.

Download Full-text