Database Analysis and Database Design Project - 4121 Words

TABLE OF CONTENTS TABLE OF CONTENTS 2 ASSIGNMENT 3 INTRODUCTION 6 REQUIREMENTS OF THE NEW SYSTEM 6 ADVANTAGES OF COMPUTER BASED SYSTEM 7 MOVING IMAGES DATABASE DESIGN 8 ENTITY RELATIONSHIP DIAGRAMS Ââ€" CONCEPTUAL MODEL 8 ENTITY RELATIONSHIP DIAGRAM Ââ€" LOGICAL MODEL 9 DATABASE SCHEME 10 MOVING IMAGES DATA DICTIONARY 13 IMPLEMENTATION 16 RELATIONSHIP BETWEEN THE TABLES 22 PROTOTYPES OF USER INTERFACE 23 VERIFYING AND EVALUATING MY DESIGN 25 MOVING IMAGES 25 TESTING BUTTONS 26 TESTING THE QUERIES 29 TESTING REPORTS 34 REPORT BASED ON QUERIES 37 EVALUATION 42 ASSIGNMENT Moving Images operates a DVD library. The library has a large number of titles, each title having at least†¦show more content†¦The database must be rigorously tested with specifically designed test data that demonstrates the effective use of validation and the resulting error messages. You should have at least 20 records in all tables to ensure that the validation checks are effective. The following activities must be performed: • Design the tables and identify Primary and Foreign Keys • Define the relationships between the tables • Create suitable data entry forms • Enter Test Data • Create at least five relevant queries to interrogate the database • Create and print reports that present a consistent and professional image which are accurate and complete INTRODUCTION I have been given the task to design a database for a company call Moving images. Moving images is a company that rents out DVDs for their register member, each member can take a DVD and that information will be store in to the system until the DVD has been return. REQUIREMENTS OF THE NEW SYSTEM Moving images is a DVD shop (to rent DVDs), as we been informed the company is growing and so are the numbers of DVDs and the number of customers which means the staff need access to this information faster than before. The management of Moving Images is requesting prototypes from different designers. Database will allow the user to enter new and view existing information inShow MoreRelatedData Base On Banking Files1147 Words   |  5 PagesTitle: CMP 553-Analysis, ModelingDesign. Date: Feburary-07-2015. â€Æ' Scope and Vision: The project is to create a data base for the bank this gives an idea about the daily, weekly, and monthly details. For this we have to design a data base to the extent of required by the user. Project is clear to understand and also helps the employer to access easily. Errors are negligible. In each phase of developing this project we achieve what the user really need and we satisfy the user. In our project user canRead MoreProject : Online Workflow System Essay761 Words   |  4 PagesProject Charter Project initiation Project name: Online Workflow System Approval Date: 9th October 21, 2015 Project sponsor: Chief executive officer Project Manager: Managing Director of the information technology department Primary customers/partners Users Our organization Staff/employees Our organization Project Core members Role Delivery Ownership Project manager Responsible for planning, communications, budget planning, schedule progress and change management. Database administrator DatabaseRead MoreProposal for Online Book Selling System1481 Words   |  6 PagesThis project proposes to develop web application in Nguyen Van Cu Bookstore. With the Internet is becoming the worlds largest communication, it has provided an environment where everyone can be online at any given time. Under this environment, Online Book Selling can be useful to sell books on the Internet. Customers can purchase or get all books information without going through a bookstore. This proposal includes planed research, its benefits, qualifications to conduct the research, and costRead MoreThe Advantages Of Database Management Systems1577 Words   |  7 Pagesb) Critically evaluate the advantages of database management systems Advantages of DBMS Data independence: - the separation of data structure of database from the application program that uses the data is called data independence in database management system; you can easily change the structure of database without modifying the application program. For example you can modify the size and data type of a data items ( fields of a database table).data independence is usually consider from two pointsRead MoreDatabase Design Concept1054 Words   |  5 PagesApply the database development cycle to a given data set Database development creates enterprise data modeling, which forms the range and wide-ranging contents of organizational databases. There are 5 phases in Database Development Cycle: Planning; Analysis; Design; Implementation and Maintenance. Planning In Planning Stage, the organization needs to know why do they need the database; what do they want the database to do; and how are they going to make the database. This is also where theRead Moreâ€Å"Why Is the Waterfall Model Valuable in the Management of Information Technology Projects?†1450 Words   |  6 Pagesplanning, mistake free calculations, and a foolproof strategy a project leader and his/her team can really set the tone for the entire project. The project leader makes all the final decisions and his /her team research, gather, review and compile the information. The information is organized by using a feasibility analyses in four different areas. These four areas are the schedule, which includes project timelines and deadlines, a project calendar, and other specifics. The other three areas are technicalRead MoreLessons Learned As A Transfer Student Essay1152 Words   |  5 Pagescourses that did I take at Campbell University were (ITS-345) Database Management , (ITS-410) System Analysis Design Dev, and (ITS-410) Networking Telecommunication. In taking these courses, I felt these courses taught me relevant concepts and examples that I used and applied in my project. These courses also helped me learn about concepts such as time management in project and how management is an important aspect in any project development. These courses were also helpful in that the conceptsRead MoreData Modeling Concepts1133 Words   |  5 Pagesand the importance of data model. Building a good data model helps organizations in software development, data base design and product maintenance. The document explains the theory, even if it looks like the organizations are spending substantial amount of resources on developing data models, but still it helps organization, keeping the costs low and build a better product. Database constitutes of data structures and is represented by conceptual data structures. Data models are abstract models whichRead MoreTop Highest Pay Jobs For Information Technology Grads Essay1074 Words   |  5 Pagesactivities and project completion. Computer programmers conduct comprehensive tests during every stage of the product cycle. They work with other teams and attend client meetings to obtain necessary information and share relevant findings. Computer programmers may modify existing software to meet new client needs. For example, they may debug code to ensure minimal downtime and maintain maximum performance. 2. Computer Systems Analyst A computer systems analyst analyzes data, systems and projects to determineRead MoreCs251 Fundamantals of Database Systems Ip 1 - 51676 Words   |  7 PagesCS251-1301B-03 Fundamentals of Database Systems Phase 1 -5 Individual Project Robert March 24th, 2013 Table of Contents Project Outline 3 Description of the Database Design Life Cycle 4 The Entity Relationship Diagram 7 The Logical Model and Normalization 9 The Microsoft Access Database 11 The Microsoft Access Database Application 14 References: 18 Project Outline    My idea for a project concept is for a granite fabrication and installation company called MasterStoneWorks