The Creation of a Relational Database Using Microsoft Access
I will be using Microsoft access to create a relational data base.
This will let me to make tables that contain data on a specific topic.
I will make a relational database my creating multiple tables and
linking them together through if they both a particular fields By
doing this it will allow my end user to find certain data from
different tables., for example they could type in the CD name which
would be in one table and it would then tell them the songs on that
album which would be stored on another table.
Now that I know what I'm using to create my database I need to know
where and how I'll get my information.
I will need the information that my end users wants to put on to their
database such as: Artist name, album name, number of songs, Album
rating, artist rating and the length of each CD. I will collect this
data from CD's that my end user wants me to add to the database. I
will do this by keying in the necessary information I need from each
CD since I have no other means of inputting the data.
I will sort all of my information in alphabetical order by artist name
because I believe this will make it the easiest way of using the
database and it will help lower the amount of errors. Other ways I can
sort my data is ascending or descending by the number of songs or by
the length of the album but this would cause great confusion because
it would mean that you would need to know the time of the album (or
number of songs) to find the particular album or artist you are
looking for.
Input
Data Item
Data Type
Data source
Source Format
Entry Method
CD name
Text
CD
Paper
CD artist
Text
CD
Paper
Music is sorted by labels. Because of the low costs in digital recordings it was
hotbeds for sharing of online music files by a variety of methods for many years. All
unrestricted version of a song. With the New Age of media there is the availability of the internet
materials. The song pluggers could improvise and transpose a song on the spot to fit a
regular CD. For all practical purposes, mp3 files can be exact, near-perfect digital copies of the
The company has self organizing team and use groupware, emails and blogs to communicate with the customers.
looking to do when I am writing a report. Instead I intend to inform and at
A database management system, or DBMS, gives the user access to their data and helps them transform the data into information. Such database management systems include dBase, Paradox, IMS, and Oracle. These systems allow users to create, update, and extract information from their databases. Compared to a manual filing system, the biggest advantages to a computerized database system are speed, accuracy, and accessibility.
We use forms to enter and manage data. Each table in our database has an input form and an output form. An input form displays one record at a time. We use an inpu7t for to enter, view, and modify information in a single record. An output form displays several records as a list. We use an output form to browse through records, select and sort records, and print a selection of records.
The leading competitor in the digital field is Apple’s iTunes database to organize and play music. We found that “iTunes-purchased son...
A CD is a fairly simple piece of plastic, about four one-hundredths (4/100) of an inch (1.2 mm) thick. Most of a CD consists of an injection-molded piece of clear polycarbonate plastic. During manufacturing, this plastic is impressed with microscopic bumps arranged as a single, continuous, extremely long spiral track of data. Once the clear piece of polycarbonate is formed, a thin, reflective aluminum layer is sputtered onto the disc, covering the bumps. Then a thin acrylic layer is sprayed over the aluminum to protect it. (Brian 1)
As fans, as lovers of music and as admirers of the creative process, we often want to be in the room when the artist laid it down on paper, canvas, film or tape. There’s a reason behind the scenes features exist.
You're sitting at home planning a party. You've got your list of invitees down. A cupboard full of chips and dips, and a cooler full of beer. You go to your computer and start putting together some mix Cd's of your favorite music. As you gather the songs you notice yourself singing along with one, and your eyes widen, lit up as you a struck with an idea.
of multiple types of end users. The data is stored in one location so that they
A database is an ordered collection of data that usually can be accessed through many different ways. A databases most important function is retrieving information. But Databases also have many other functions pertaining to information, including being able to sort, store, and locate information. The easier a database can access information the more effective the database is. Most of todays complex databases are found on a computer.