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
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
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
someone can add words that rhyme to the instrumental that you have made. Over the years as
The leading competitor in the digital field is Apple’s iTunes database to organize and play music. We found that “iTunes-purchased son...
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.
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)
Determine how results are to be presented and shared. These steps can help you to create a database effectively.
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.
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.
The use of MySQL as the primary database for web applications is often integrated with PHP as an object-oriented scripting language. MySQL is one of the most important components of a web service solution stack like a LAMP, XAMPP, MAMP, WampServer, or AMPPS which is the open source web development platform. If you create a website using CMS like Joomla, Wordpress, or Drupal, you are using MySQL as its database solution.
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.
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.