Database Design Document: Personal Music Library

Submitted By wclong8600
Words: 683
Pages: 3
Open Document
Associate Program Material

Appendix B

IT/260 Database Design Document

Personal Music Library

Prepared By:
Date Modified: 02/23/2014
Week: nine

Part 1: Introduction (due Week in Two)

a) Application Summary: I chose the Personal Music Library, were I will use a program and database manager to download and save all my music in alphabetical order so I have easy access to my music and I will be able to search by artist or song title.

b) Database Software: I will use a desktop database because I am the only user on this computer and the files I am saving is for my own personal use, I will also use Microsoft excel to make a listing of all my songs separately from my music folder which will have all my songs in alphabetical order by artist name. I am choosing the desktop database design because it is quick and easy to use and allows me to do everything I need to do.

c) Database Design Elements: I will have my music folder, my music player connected to one another so my music is in both places for play I will use excel to make a listing of all my music by artist name in alphabetical order that way I can search for a specific artist or song title without having to go through the entire list. My design will allow me to edit or change entries without having to make a new document.

Part 2: Database Design (due in Week Three)

a) Entities and Attributes: My entities are music titles, music by artist.
My attributes for these are albums, alphabetical order, total time of album length

b) Normalization artist Albums title
Album length in time
Def leopard
Hysteria
1:18
Metallica
Ride the lightning
1:04
Oingo boingo
Dead mans party
1:22
Queensryche
Empire
1:24
Reba mcentire
Rumors
1:02

Part 3: Relationships, Components, Features, and Requirements (due in Week Four)

a) Define what an ERD is and why it is important as a tool in the database design process. The ERD represents the conceptual database as viewed by the end user. ERDs depict the database’s main components: entities, attributes, and relationships. Because an entity represents a real-world object, the words entity and object are often used interchangeably.

b) Entity-Relationship Diagram

c) Components and Features: Well for my database features will be artist, song title, genre of music, and length of time for song.

Part 4: Queries and Forms (due in Week Five)

a) Queries: Artists by name, song title by name, a search feature by genre
Show More

Related Documents: Database Design Document: Personal Music Library

Bat Diploma 1 Essay

1180 Computer Graphics and Design BUSN 1300 Introduction to Business BUSN 1340 Customer Service Effectiveness BUSN 1420 Database Applications BUSN 2170 Web Page Design BUSN 2180 Speed and Accuracy Keying BUSN 2230 Office Management BUSN 2240 Business Administrative Assistant Internship I BUSN 2300 Medical Terminology BUSN 2310 Anatomy and Terminology for the Medical Administrative Assistant BUSN 2320 Medical Document Processing/Transcription BUSN 2330 Advanced Medical Document Processing/Transcription…

Words 774 - Pages 4

Essay about IT230LAN Topology Design Final

LAN Topology Design and Cabling Specifications for ABC Widgets Network Design Computer Networking, IT230 February 28, 2010 Executive Summary The network design will be star topologies for all locations. Windows servers are located at one location in Pennsylvania, additional Windows servers are located in SLC and Europe. Connections between sites are utilized with Remote Desktop directly to various servers. VPN remote access servers will support the company Sales Department and internal employee’s…

Words 4451 - Pages 18

Computer crime involves Essay example

Computer crime involves:  Theft by computer (including identity theft and phis hing)  Software piracy and intellectual property misuse  Software sabotage (malw are- including worms, viruses, Trojan horses, e tc.)  Hacking and electronic trespassing. The computer crime dossier  Computer crime: any crime accomplished through knowledge or use of computer technology  Businesses and government institutions lose billions of dollars every year to computer criminals  The majority of crimes is committed…

Words 7422 - Pages 30

Essay on Advanced Computer Application

(4) advanced level credits is equivalent to the SUNY ESC Advanced Computer Application course. My essay will cover the following computer applications: Operating Systems, a variety of Software applications, Graphic Design, Antivirus Protection, Desktop Publishing, Utilities and Database Management. In these areas, I will describe the learning experience that resulted from each. 2. Sources of the Learning: Within the past 15 years, I have gained valuable advanced computer experience from several…

Words 925 - Pages 4

Essay about Hello World

Requirements Specification for Academic Payroll System Version 0.1 Prepared by: Himanshu Kumar, Georgia Kitt & Monish Mohan 21/04/2009 Copyright © 2002 by Karl E. Wiegers. Permission is granted to use, modify, and distribute this document. This document has been modified for use in courses at AUT, February 2009. Software Requirements Specification for Page ii Table of Contents 1. Introduction.....................................................................................…

Words 1738 - Pages 7

Describe The Background To The Organisation Of An Organisation

Create a Word document that describes the background to the organisation. Information that should be included:  The name of the organisation  The name of the manager/owner  What they do e.g. what they sell, what services are offered  Where they are located  How long they have been around for  How many employees there are Task 2 – Identify and Analyse Existing Documents to Determine Image, Ethos and House style (2 marks) Select three different types of existing documents currently…

Words 1886 - Pages 8

Week 2 Assignment Lan Topology Essay example

Pittsburgh that are four miles apart. Each site consists of a large factory with office space for 25 users at the front of the factory and up to 20 workstations in two work cells on each factory floor. All office users need access to an inventory database that runs…

Words 1324 - Pages 6

Essay about Cis Final Project

as well as Apple’s own OS, the MacBook provides operating system flexibility alongside a solid hardware design and exceptional customer support. The starting price of $1299 may seem hefty for this machine, but it’s important to note that you can also purchase them refurbished for cheaper. For in-office setup, I recommend the Apple iMac with retinal display. The iMac is an all-in-one desktop that combines the computer with a built-in monitor and speakers. It has everything an employee would need…

Words 1601 - Pages 7

Email Marketing Essay

FlyReply 2.0 Overview Document Version: 1.0 Date: March 2013 XiUnited, FlyReply, TwitYap, LeadRevolution, MovieSocial are Trademarks of Xhibit Corporation. All Rights Reserved by Xhibit Corp Tuesday, March 12, 13 FLYREPLY 2.0 An Interactive Marketing Software Suite That Changes Everything. FlyReply™ is a next generation interactive marketing software suite. FlyReply™ is all cloud-based to help companies communicate with and monetize their consumers over email, mobile and social media…

Words 736 - Pages 3

Essay about Client Technology Tracking System

Analysis and Design [Type the abstract of the document here. The abstract is typically a short summary of the contents of the document. Type the abstract of the document here. The abstract is typically a short summary of the contents of the document.] 2011 Client Technology Tracking System (CTTS) System Analysis and Design [Type the abstract of the document here. The abstract is typically a short summary of the contents of the document. Type the abstract of the document here. The abstract…

Words 5795 - Pages 24