Premium Essay

Database Design Project 7

In:

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 records...

Words: 1847 - Pages: 8

Premium Essay

Bsa 375

... | | |College of Information Systems & Technology | | |DBM/380 Version 9 | | |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...

Words: 3236 - Pages: 13

Premium Essay

Application of Mis on Statistical Analysis

...levels by developing an understanding of the differences between various types of information systems 2. Understand how information systems are developed 3. Understand the computer revolution and its impact on the way business is conducted 4. Become familiar with critical-thinking skills in identifying information systems problems and how to investigate existing literature about hardware and software solutions to problems. 5. Know the components and functions of computer systems, both hardware and software. 6. Become familiar with the advances in networking, data communications and the Internet and how they affect the way business is 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...

Words: 3623 - Pages: 15

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, Marketing...

Words: 1166 - Pages: 5

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, 2012 Business: ...

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, including...

Words: 4780 - Pages: 20

Premium Essay

Online Course Reservation

...Statement 2 3. Stakeholder and User Descriptions 2 3.1 Market Demographics 2 3.2 Stakeholder Summary 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...

Words: 1769 - Pages: 8

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 Database Environment...

Words: 2854 - Pages: 12

Free Essay

With the Development of Technology, More and More Robots Are Used in Various Fields,

...University of Mumbai B.E Information Technology Scheme of Instruction and Evaluation Third Year -Semester VI Scheme of Instructions Sr. Subjects Lect/ No 1 Information and Network Security Middleware and Enterprise Integration Technologies Software Engineering Data Base Technologies Programming for Mobile and Remote Computers Information Technology for Management of Enterprise TOTAL Week 4 Scheme of Examinations Theory T/W Practical Oral Total Hours Marks Marks Marks Marks Marks 3 100 25 -25 150 Pract/ Week 2 Tut/ Week -- 2 4 2 -- 3 100 25 -- 25 150 3 4 5 4 4 4 2 2 2 ---- 3 3 3 100 100 100 25 25 25 --25 25 25 -- 150 150 150 6 4 24 10 1 1 3 -- 100 600 25 150 -25 25 125 150 900 INFORMATION AND NETWORK SECURITY CLASS T.E. ( INFORMATION TECHNOLOGY) HOURS PER LECTURES : WEEK TUTORIALS : PRACTICALS EVALUATION SYSTEM: THEORY PRACTICAL ORAL TERM WORK : SEMESTER VI 04 -02 HOURS 3 ---- MARKS 100 25 25 1. Introduction What is Information Security? Security Goals. 2. Cryptography Crypto Basic, Classic Cryptography, Symmetric Key Cryptography: Stream Ciphers, A5/1, RC4, Block Ciphers, Feistel Cipher, DES, Triple DES, AES, Public Key Cryptography: Kanpsack, RSA, Defiie-Hellman, use of public key crypto- Signature and Non-repudiation, Confidentiality and Non-repudiation, Public Key Infrastructure, Hash Function: The Birthday Problem, MD5, SHA-1, Tiger Hash, Use of Hash Function. 3. Access...

Words: 3868 - Pages: 16

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 spread...

Words: 1582 - 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 • Lead...

Words: 1246 - 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 Management 3. Gas Agency...

Words: 1572 - Pages: 7

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 Project...

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

Premium Essay

Computers

...[pic] Quality Assurance Plan For WAN Solutions Date: 5/26/2012 Revision Sheet |Release No. |Date |Revision Description | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |[pic] | | | ...

Words: 5473 - Pages: 22