Premium Essay

Database Design Project 7

In: Computers and Technology

Submitted By roadrageisfun
Words 344
Pages 2
Module 7 - Project 2

Your assignment is from the text.
• Complete Cases #65, 68, 69, 70, and 71 at the end of Chapter 7.
Your assignment must be submitted to the Dropbox no later than Sunday 11:59 PM EST/EDT.

CASES
EliteVideo is a startup company providing concierge DVD kiosk service in upscale neighborhoods. EliteVideo can own several copies (VIDEO) of each movie (MOVIE). For example, the store may have 10 copies of the movie “Twist in the Wind”. “Twist in the Wind” would be one MOVIE and each copy would be a VIDEO. A rental transaction (RENTAL) involves one or more videos being rented to a member (MEMBERSHIP). A video can be rented many times over its lifetime, therefore, there is a M:N relationship between RENTAL and VIDEO. DETAILRENTAL is the bridge table to resolve this relationship. The complete ERD is provided in Figure P7.65.

65. Write the SQL code to create the table structures for the entities shown in Figure P7.65. The structures should contain the attributes specified in the ERD. Use data types that would be appropriate for the data that will need to be stored in each attribute. Enforce primary key and foreign key constraints as indicated by the ERD.

MEMBERSHIP
Mem_
Num Mem_
Fname Mem_
Lname Mem_Street Mem_City Mem_
State Mem_Zip Mem_
Balance

RENTAL
Rent_Num Rent_Date Mem_Num

DETAILRENTAL
Rent_Num Vid_Num Detail_Fee Detail_Duedate Detail_Returndate Detail_Dailylatefee

VIDEO
Vid_Num Vid_Indate Movie_Num

MOVIE
Movie_Num Movie_Name Movie_Year Movie_Cost Movie_Genre Price_Code

PRICE
Price_Code Price_Description Price_Rentfee Price_Dailylatefee

68. Write the SQL command to change the movie year for movie number 1245 to 2010.

UPDATE Movie SET MOVIE_YEAR = 2010 WHERE MOVIE_NUM = 1245;

69. Write the SQL command to change the price code for all Action movies to price code 3.

UPDATE Movie SET…...

Similar Documents

Premium Essay

Website

...Desserts and Shawarma Project Charter 1. Project Background 2.1 Problem/Opportunity Description My desserts and Shawarma is a food business specialized in desserts and drinks. It is located at San Antonio Village, Barangay Culiat Quezon City. They Opened Last July 2015. What inspires them to build this business is the passion of Sharlene Sandaan (one of the owner) to make desserts and blended drinks. And she also loves to eat Most of the people who visit the said business are students from different schools. For they offer foods and drinks in a reasonable price that ranges from 60 to 90 pesos. One of their best selling products is the shawarma and chocolate frappe. As of now, they already have 20 products in their menu and still looking forward to add more. As the said business grows, they experienced issues in their daily business transaction. One of these is the inconsistency of records. The order of the customer doesn’t match the list of orders the employee took. The business also experienced unorganized records due to manual life processing system. They used paper to list the orders of the customer. Sometimes it is hard to avoid erasures and tampering when the customer suddenly changes their mind in th eir orders and it’s what makes harder to understand. At the end of the day they will compile all the order papers and because of the rowdy Production area some of it is already missing. 2.2 Benefits Company This database design it will preserve......

Words: 1847 - Pages: 8

Premium Essay

Bsa 375

... |Database Concepts | | |July 16, 2012 to August 13, 2012 | | |Group KM11BIT13 | Copyright © 2012, 2010, 2008, 2007, 2006, 2005, 2003 by University of Phoenix. All rights reserved. Course Description This course covers database concepts. Topics include data analysis, the principal data models with emphasis on the relational model, entity-relationship diagrams, database design, normalization, and database administration. Policies Faculty and students will be held responsible for understanding and adhering to all policies contained within the following two documents: • University policies: You must be logged into the student website to view this document. • Instructor policies: This document is posted in the Course Materials forum. University policies are subject to change. Be sure to read the policies at the beginning of each class. Policies may be slightly different depending on the modality in which you attend class. If you have recently changed modalities, read the policies governing your current class modality. Course Materials Coronel, C., Morris, S., & Rob, P. (2013). Database systems: Design, implementation, and......

Words: 3236 - Pages: 13

Premium Essay

Application of Mis on Statistical Analysis

...conducted. 7. Identify which information technology tools are used to solve various business problems. 8. Develop proficiency solving business problems using modern productivity tools (e.g., spreadsheet, database) or creating custom programs.   MIS 301: Statistical Analysis for Business At the end of this course students should be able to: 1. Use data from a sample to make inferences about a population. 2. Apply probability theory in decision making situations. 3. Formulate hypotheses for decision making and research. 4. Analyze data using appropriate statistical techniques. 5. Interpret the results of statistical analysis. 6. Present statistical results using graphics, text, and the spoken word. MIS 302: Introduction to Operations Management At the end of this course students should be able to: 1. Define the role of operations and supply chain in an organization and its interactions with business functions such as accounting, finance, and marketing. 2. Develop the basic business and operations strategies for increased productivity and competitiveness for service and manufacturing. 3. Use descriptive and optimization models and incorporate cost drivers to improve general business decision making. 4. Identify issues in inventories and resources for an organization and use basic models to improve its management 5. Design quality management strategies, techniques and tools for improved customer satisfaction. 6. Plan the basic scheduling for project and its management 7. List......

Words: 3623 - Pages: 15

Premium Essay

Papers

...Description • Databases are used to store, manipulate, and retrieve data in nearly every type of organization. • Database technology is routinely used by – individuals on personal computers – workgroups accessing databases on network servers – enterprise-wide distributed applications. Course Description • Introduces the basic and fundamental concepts on databases and the management of databases in terms of the different applications. • Exposes the use of DBMS to create and maintain applications. – – – – table construction Forms queries and report generations Course Objectives • Trace the growth and importance of database application; • Identify the advantages and disadvantages of database systems; • Apply appropriate techniques and methodologies in building and maintaining database systems; and • Create database application for business processes. Value Aims • Values – Teamwork – Self-Esteem – Accuracy – Confidence – Patience • Skills – Analytical and Logical 1 11/11/2014 Course Requirements • • • • • • Lecture sessions Hands-on Activities Quizzes Assignments Periodic Examinations Individual projects COURSE ADMINISTRATION Grading Scheme (Prelim, Midterm and Endterm) • CLASS STANDING 40% – Assignments – Quizzes – Lab Activities Grading Scheme Percentile Distribution • Prelim 30% • Midterm 30% • Finals 40% • EXAMINATIONS • PROJECT 40% 20% PRELIM LECTURE • Basic Concepts and Definitions • Traditional File Processing System vs Database System • Components of the......

Words: 2854 - Pages: 12

Premium Essay

Ziggy's Suit Department Systems Analysis & Design

...Department Systems Analysis & Design Zachary Powe ITM 6000-Final Project Mrs. Constance Jolly March 8, 2012 TABLE OF CONTENTS Business: 4 Organizational Chart: 5 Preliminary Investigation: 5 Project Definition Document 6 Problem Statement: 6 Project: 7 Mandatory Objectives: 7 Desirable Objectives: 7 Priority of Project: 7 Project Scope: 7 Terms of Reference: 8 Time/Business Deadline: 8 Assumptions: 8 Systems Analysis: 10 Data Dictionary: Data Elements 12 Data Dictionary: Data Flows 15 Data Dictionary: Process Descriptions: 18 Data Dictionary: External Entities 21 Data Dictionary: Data Store 24 List of Constraints: 25 Forms and Reports: 26 Alternative Solutions: 29 E-commerce Web Design by Triad Web Design along with IntruGuard E-commerce Network Security 29 Maintain production in-store with implemented software upgrades and hardware installations: 30 My Recommendation: 31 System Design to Include 32 Input Screens for New System 32 Website Login Screen: 32 Website Contacts Screen: 33 Ziggy’s Suit Department Screen Report: 34 BOM (Bill of Materials) 35 Software Plan: 35 Hardware Plan: 35 Testing Plan for New System: 36 Training Plan: 36 Network Diagram: 37 Implementation: 38 A) Description: 38 B) Changeover Method: 38 C) Conversion Plan: 38 D) Gantt Chart: 39 E) Maintenance Contract Plan: 39 Zachary Powe ITM 5400-System Analysis and Design Mrs. Jolly January 12,......

Words: 2049 - Pages: 9

Free Essay

Database

...Student Database Management System Ajay Shankar Bidyarthy , Abhishek Kumar b.ajay@iitg.ernet.in kumar.ak@iitg.ernet.in November 13, 2012 Abstract: An organized and systematic office solution is essential for all universities and organizations. There are many departments of administration for the maintenance of college information and student databases in any institution. All these departments provide various records regarding students. Most of these track records need to maintain information about the students. This information could be the general details like student name, address, performance, attendance etc or specific information related to departments like collection of data. All the modules in college administration are interdependent. They are maintained manually. So they need to be automated and centralized as, Information from one module will be needed by other modules. For example when a student needs his course completion certificate it needs to check many details about the student like his name, reg number, year of study, exams he attended and many other details. So it needs to contact all the modules that are office, department and examination and result of students. With that in mind, we overhauled the existing Student Database Management System and made necessary improvement to streamline the processes. Administrators using the system will find that the process of recording and retrieving students information and managing their classes,......

Words: 4780 - Pages: 20

Premium Essay

Online Course Reservation

...2 3.3 User Summary 2 3.4 User environment 3 3.5 Stakeholder Profiles 3 3.5.1 3 3.6 User Profiles 3 3.6.1 3 3.7 Key Stakeholder / User Needs 4 3.8 Alternatives and Competition 4 3.8.1 4 3.8.2 4 4. Product Overview 4 4.1 Product Perspective 5 4.2 Summary of Capabilities 5 4.3 Assumptions and Dependencies 5 4.4 Cost and Pricing 5 4.5 Licensing and Installation 5 5. Product Features 6 5.1 6 5.2 6 6. Constraints 6 7. Quality Ranges 6 8. Precedence and Priority 6 9. Other Product Requirements 6 9.1 Applicable Standards 6 9.2 System Requirements 7 9.3 Performance Requirements 7 9.4 Environmental Requirements 7 10. Documentation Requirements 7 10.1 User Manual 7 10.2 Online Help 7 10.3 Installation Guides, Configuration, Read Me File 7 10.4 Labeling and Package 9 Introduction The purpose of this document is to collect, analyze and define high-level needs and features of the online course reservation It focuses on the capabilities needed by the stakeholders, and the target users, and why these needs exist. The details of how the online course reservation fulfils these needs are detailed in the use-case and supplementary specifications. By online course reservation we can study easily and in good manner. The purpose of this system is to make ease of learning instead of waiting for their turn in......

Words: 1769 - Pages: 8

Free Essay

Bsa.375.Sr.Rm.022

...advantage of a more sophisticated, state of the art, information systems technology for their Human resources database. We shall follow the five phases of the system development life cycle to upgrade the existing system with a new web application that employees can use to access and make changes to their employee records. The five phases are: Investigation, Analysis, Design, Testing, and Maintenance. Riordan Manufacturing Human resources Information System (HRIS) was installed in 1992. HR is currently responsible for: employee information( personal information, pay rate, personal tax exemptions, hire date, seniority date, department information, and Vacation hours), Training and development records, Resume files, workers compensation records, Employee file’s(currently with employee’s individual manager), Compensation files, and employee relations files. Currently the 7 HR records are scattered amongst the HR department and employee managers, these files need to be consolidated. It is time to upgrade and modernize the system. An integrated system will increase productivity, reduce the need for specialized highly paid positions and improve employee understanding of the HR benefit process. During the Analysis phase of the System development life cycle it is important to meet with the stakeholders, people and groups of people that have interest or concern in the project (“Business Dictionary”, 2013). I will need to meet with people in the following departments: Accounting,......

Words: 1166 - Pages: 5

Premium Essay

Project Info

...2011-SEPTEMBER 2011 NIPS COLLEGE OF IT AND MANAGEMENT ALL AHABAD [Synopsis and Project Guidelines] MCA-6th Semester BCA-6th Semester PGDCA-2nd Semester And MBA-4th Semester IMPORTANT DATE S ynopsis Approval Last Date Project S ubmission Date MBA S ynopsis Approval Last Date MBA Project S ubmission Date : : : : 20/05/2011 27/07/2011 30/05/2011 10/08/2011 IMPORTANT INFORMATION MCA-6th S em Project Coordinator PGDCA-2nd S em Project Coordinator BCA-6th Sem Project Coordinator MBA- 4th S em Project Coordinator : Mrs Seema S rivastava : Mr.Gangesh Kumar :Mr.Deepak Mishra Ph:9451686685 :Mr. Jitendra Kumar Keswani Ph: 8081313153 SYNOPSIS GUIDELINE SYNOPSIS AND PROJECT GUIDELINES MCA- BCA- PGDCAMCA -6 BCA-6 & PGDCA -2 Synopsis Format 1. Introduction Of Project 2. Objective Of The Project 3. Scope Of The Project 4. Project Plan 5. The Existing System 6. Background Of The Organization 7. Current Problems 8. Areas For Improvement 9. Proposed System 10. Input/Output Requirement 11. Hardware And Software Requirement 12. Database Requirement 13. System Design 14. Tables And Fields For Database 15. Database Dictionary 16. E-R Diagram 17. ‘0’ Level DFD 18. ‘1’ Level DFD 19. Security Control 20. Future Scope Of The Project 21. Conclusion NIPS COLLEGE OF IT & MANAGEMENT ALLAHABAD Ph: 0532-3291133 th th nd 1 SYNOPSIS AND PROJECT GUIDELINES 22. Reference Or Bibliography Some Suggested Project Title 1. Bank Transactions Management 2. Hotel......

Words: 1572 - Pages: 7

Free Essay

My Paper

...driven development manager with more than 7 years of experience with focus on promoting software solutions through design, architecture, and development. I bring extensive experience in team management and have contributed to multiple functional and management domains and across industry sectors. Extensive experience in various technical domains such as: • Microsoft Office SharePoint • B2B development and deployment • E-government solutions and portals • Microsoft Framework • Software processes and standards • Cross-Functional team Management My work spanned across two continents with an in-depth knowledge of Middle Eastern cultural and social traditions; supported by an excellent command of two languages. I have passion for people, and I am a highly effective mentor and coach, adept at inspiring confidence, leading by example, and building high-performance teams committed to quality and responsiveness. EXPERIENCE SUMMARY Project Management • Broad knowledge and experience with tools and techniques for planning, organizing, monitoring and controlling projects as well as industry best practices and methodologies of processes and techniques for project management. • Full awareness of CMMI standards and process development. • Team Self Process TSP/PSP approaches and coaching methodologies. • Experienced in projects’ Financial Management procedures and techniques to manage project budget and finance initiatives •......

Words: 1246 - Pages: 5

Premium Essay

Genrays Project Charter

...Project Charter HRIS System Project Charter GenRays Date: 6/29/2016 Contents Project Title 3 Problem/Opportunity Statement 3 Description 3 Objective 3 Success Criteria or Expected Benefits 4 Funding 5 Project Process Outcomes 5 Phase 1. Initiate, plan and research 5 Initiation of Project and initial planning 5 Business analysis 5 Infrastructure Preparation 5 Phase 2. Design and develop 5 Phase 3. End user training 6 Phase 4. Rollout 6 Acceptance Criteria 6 Phase 1. 6  Project Charter 6  Project Management Plan 6  Kickoff meeting 6  Business Requirements documents 6  Technology Report 6  Infrastructure report 6 Phase 2. 6 Phase 3. 7 Phase 4. Rollout 7 Milestone Schedule 7 Phase 2. Design and develop 7 Phase 3. End user training 7 Phase 4. Rollout 8 Approval Requirements 8 Project Manager 8 Role 8 Authorized By 8 Project Title GenRays Human Resources Information Systems with integrated Employee self-service modules Problem/Opportunity Statement After seeing significant returns from the new financial system, the company is looking for other areas to improve to see cost savings in more areas of the business. The Human Resources Information System has been identified as a zone that could streamline quite a few tasks through integration and automation. Finance, purchasing, logistics, and accounting will all be integrated. Description The data needed by Human Resources is currently......

Words: 1582 - Pages: 7

Premium Essay

Designing a  Database  Structure  System  for   Management  Hospital  Information.

... Research-­‐Based  Practice   Assessment  Item  3:  Detailed  Research  Project  Proposal       Section  A:  Administration   Name:  HA  Quoc  Tien   Student  number:  n08745871   Research  project  title:  Designing  a  database  structure  system  for   management  hospital  information.   Field  of  research:  Information  system;  database  structure;  hospital   information     Section  B:  Aims   This project is going to indicate a new database structure model used to manage information in hospital management with respect to utilizing information and communication technology. It will enhance hospital to retrieve, process and achieve all the information in specific health facilities in a security domain. In fact, the database structure is not really considered as an important aspect in patient informational management in hospital. From the synthesis of the results of current hospital, the management of information within the hospital will include: management of patient information, medical information, laboratory data, diagnostic results, treatments, financial, pharmaceutical, medical equipment and general operations of the hospital. There are numbers of documentation in the database, the problem is illustrated that a hospital database management does not have the same synchronization in all fields.......

Words: 1466 - Pages: 6

Premium Essay

Resume

...Excellent administrative, consulting and communication skills Awards: | |YEAR |AWARD |REMARKS | |1. |2011 |QCF Level 7 POSTGRADUATE Diploma in Business Management (PgDip) |ASSOCIATION OF BUSINESS EXECUTIVES | |2. |2003 |British Computer Society (Honours Degree) in Information Technology |BRITISH COMPUTER SOCIETY – Graduated on | | | |(Certificate PGM, Diploma PGM, Professional Graduate Diploma, |the 4th of October 2003 | | | |Professional Project) | | |3. |2001 |Advanced Diploma in Business Administration |ASSOCIATION OF BUSINESS EXECUTIVES | Further Studies: 1. MBA (TopUp) University of Sunderland (UK) - 2012 - Global Corporate Strategy - International Business Environment - Dissertation Education: | |YEAR |EXAMINATION LEVEL |BODY/INSTITUTION | |1. |2011 |QCF Level 7 Postgraduate Diploma in Business Management |ASSOCIATION OF BUSINESS EXECUTIVES | |2. |Apr 2003 |Professional Graduate Diploma (Hons. Degree), Information |BRITISH COMPUTER SOCIETY | | | ......

Words: 2182 - Pages: 9

Premium Essay

Project Charter

...Project Vision, Objectives and Scope The organization consists of a team of experienced accounting professionals providing clear and relevant advice in a timely and professional manner. Its approach is to deliver an integrated solution by tapping into various years of experience and expertise to deal with everyday challenges. Vision The vision of the project is to increase productivity, minimize errors and improve clients’ satisfaction by implementing an Enterprise Solutions that will help simplify the accounting processes and still have the ability to generate the information needed to make informed business decisions. The project is intended to support the planning, oversight, and implementation of QuickBooks Enterprise Solutions and to establish a structure to maintain the accounting functions and payroll with system/data interfaces, tables, and codes. The project will provide planning, analysis, programming, data updates, testing, documentation, software quality assurance and implementation support to ensure that this software provides continued relevance to the accounting department of the organization (Horne, 2011). Objectives The objectives of the project include the following 1. Support and improve the current operations in the organization. 2. Improve efficiency of delivery systems, 3. Reduce product costs. 4. Improve the company’s market position and future prospects. Scope Statements The......

Words: 3222 - Pages: 13

Premium Essay

Retail Store Database

...Fundamentals of Database Systems Individual Project: Retail Store Database Table of Contents Section 1: Project Outline 3 Project Overview 3 Section 2: Description of the Database Design Life Cycle 4 Database Design Life Cycle 4 Database Creation 7 Section 3: The Entity Relationship Diagram 9 TBD 9 Section 4: The Logical Model and Normalization 10 TBD 10 Section 5: The Microsoft Access Database 11 TBD 11 Section 6: The Microsoft Access Database Application 12 TBD 12 References 13 Section 1: Project Outline Project Overview This project will go over the process of designing a database. The database that will be designed will be a database for a typical retail store. The purpose of this database will be to manage and store the data produced or collected during normal day to day operations. Throughout the rest of this project the information and processes will be aimed toward the creation of this retail store database. This is to help provide an example of what is needed to create a database and how each process or step corresponds to each other. Section 2: Description of the Database Design Life Cycle Database Design Life Cycle In order to create a database you must understand that there are certain steps that are contained within the Database Design Life Cycle (DBLC). These seven steps help you design the database and they give a step by step process to guide you through the phases of development. These steps are listed as follows: ...

Words: 1683 - Pages: 7