USE cluelesspc; /*tbluser*/ insert into tbluser (loginid, password, firstname, lastname) values ('pepper','pepper0','david','pepper'), ('spencer','spencer0','erich','spencer'); /*tbllanguage*/ insert into tbllanguage (name) values ('English'), ('Latin'); /*tbluserdlanguage*/ insert into tbluserlanguage (userid, languageid, sortorder) values (1,2,1), (1,1,2), (2,1,1), (2,2,2); /*tblDocumentType*/ insert into tbldocumenttype (name) values ('Horizontal Nav'), ('Vertical Nav'); /*tbldocument*/ insert into tbldocument (documenttypeid,name,filename) values (1,'About','index.php'), (1,'Contact','index.php'), (1,'Login','login.php'), (1,'Privacy','index.php'), (2,'Input Devices','index.php'), (2,'The Display','index.php'), (2,'Software Applications','index.php'), (2,'The Operating System','index.php'), (2,'The File System','index.php'), (2,'Memory','index.php'), (2,'The Network Environment','index.php'), (2,'The Internet','index.php'), (2,'Search Skills','index.php'), (2,'Computer Specifications (Hardware Overview)','index.php'); /*tblcomponenttype*/ insert into tblcomponenttype (name) values ('Text'), ('File'), ('Graphic'), ('Question'), ('Answer'), ('In-line Heading'), ('Non-paragraph Text (
)'), ('Unordered List Items'); /*tblcomponent about 1*/ insert into tblcomponent (componenttypeid,name,content,filename,path,size) values (1,'about p1','CluelessPC is a website that is designed to pave a path for novice computer users which leads to intermediate-level knowledge of the personal computer (PC).',NULL,NULL,NULL), (1,'about p2','To help users learn, we have analyzed the sets of skills which distinguish intermediate computer users and identified ways in which these skill-sets build on each other and are related to one another.',NULL,NULL,NULL), (1,'about p3','This set of information has been assembled into 10 core content areas. These content areas are someone heirarchical, but also somewhat independent of each other.',NULL,NULL,NULL), (1,'about p4','At the end of each content section is a quiz which will test your mastery of the content on each page. Your Successful test results will be reflected in the clue pyramid logo at the top left corner of each screen.',NULL,NULL,NULL), (1,'about p5','You may establish a login for the site if you want the site to remember your progress going forward. You may also establish language preferences, and CluelessPC will attempt to serve content in your preferred language.',NULL,NULL,NULL), (1,'about p6','Thank you for using CluelessPC to make progress as a novice personal computer user. We''d love to hear from you about the way you use the site and what you''ld like to see out of future developments.',NULL,NULL,NULL), (1,'about p7','Also, if you are bi-lingual in English and any other language for which we need content, and you are willing to translate ClueelessPC content please contact us to get started.',NULL,NULL,NULL), (1,'about sincerely','Sincerely,',NULL,NULL,NULL), (1,'about david pepper','David Pepper',NULL,NULL,NULL), (7,'about pepper title line 1','CluelessPC Editor',NULL,NULL,NULL), (7,'about pepper title line 2','Permanent Novice',NULL,NULL,NULL); /*tblcomponent contact 2*/ insert into tblcomponent (componenttypeid,name,content,filename,path,size) values (1,'contact pepper','David Pepper',NULL,NULL,NULL), (7,'contact title','CluelessPC Editor',NULL,NULL,NULL), (1,'contact email','dave.pepper@verizon.net',NULL,NULL,NULL); /*tblcomponent login 3*/ insert into tblcomponent (componenttypeid,name,content,filename,path,size) values (1,'login p1','This obsolete data not used but record must exist for data integrity due to autonumber and whatnot.',NULL,NULL,NULL), (1,'login p2','This obsolete data not used but record must exist for data integrity due to autonumber and whatnot.',NULL,NULL,NULL), (1,'login p3','This obsolete data not used but record must exist for data integrity due to autonumber and whatnot.',NULL,NULL,NULL); /*tblcomponent privacy 4*/ insert into tblcomponent (componenttypeid,name,content,filename,path,size) values (7,'privacy p1','CluelessPC collects the following user-specific information:',NULL,NULL,NULL), (8,'privacy collection list','
  • login information
  • content quiz score results
    • ',NULL,NULL,NULL), (1,'privacy p2','All other information gatherred is aggregate information with no uniquie identifying information. We do not sell or distribute access to our data. You can trust us.',NULL,NULL,NULL); /*tblcomponent input 5*/ insert into tblcomponent (componenttypeid,name,content,filename,path,size) values (1,'input p1','Input devices are what we use to interact with the computer. These are mainly the mouse and the keyboard.',NULL,NULL,NULL), (6,'input mouse header','The Mouse',NULL,NULL,NULL), (1,'input p2','The mouse controls the location of a visual token on the compuer''s screen, called the mouse pointer. This token switches appearance depending on what it is hovering over. In most cases it is either an arrow, or a vertical line (indicating that the use can type).',NULL,NULL,NULL), (1,'input p3','Most computer mice have two or three buttons. The top left button is the default. The top-right button is an alternate which often presents alternative functionality.',NULL,NULL,NULL), (1,'input p4','Additional buttons sometimes exist; among the most important of these is the scroll wheel which controls the position of documents which are too big to fit their entire content on screen at the same time. Scroll wheels are hard to master and often create accidental input. Luckily the scroll wheel can be turned off.',NULL,NULL,NULL), (6,'input keyboard header','The Keyboard',NULL,NULL,NULL), (1,'input p5','The keyboard has a lot of buttons, more than 100 in fact. The main buttons are the 26 characters of the English alphabet which are arranged in a pattern that is recognizable, and is named "QWERTY" for the position of the first five alphabet letters reading from left-to-right.',NULL,NULL,NULL), (1,'input p6','The top of the keyboard has the "Escape" (Esc) in its top left position. This is used to back out of or cancel activities. The rest of the top row of keys are called "Function Keys". These are numberred and they are used by software developers to assign unique functionality. The most common use of the function keys is "Help" which is often called by the F1 key.',NULL,NULL,NULL), (1,'input p7','The right hand side of the keyboard has a group of number keys often called the "keypad". Using the keypad is complicated by the fact that a special key called "Num Lock" (number lock) determines if hitting a number key types the number or something else entirely. The "Num Lock" key is often confusing to users because of this.',NULL,NULL,NULL), (1,'input p8','Many of the keys in the number pad actually duplicate keys in another section of the keyboard, which most users call "the keys between the number pad and the regular keys". This group of keys is like the F-Keys in that they control the behavior of software, but they are all preassigned and have been assigned to specific purposes.',NULL,NULL,NULL); /*tblcomponent input 5.1*/ insert into tblcomponent (componenttypeid,name,content,filename,path,size) values (1,'input p9','Among these, home moves the cursor to the top of the screen or to the left of the screen. End moves it to the end of the line or the bottom of the screen. Insert toggles between a mode of typeing that overwrites text, versus one which inserts new characters between those already on a line. Delete removes characters and pulls the characters already on the line backwards the same amount of spaces (the opposite of insert).',NULL,NULL,NULL), (1,'input p10','"Page Up" and "Page Down" move the page up and down, and scroll lock reverses the normal behaviors of scroll wheels.',NULL,NULL,NULL), (1,'input p11','The break key (sometimes called "Pause"), is designed to control software by interrupting it.',NULL,NULL,NULL), (1,'input p12','At the top of the main bank of keys is a row of numbers. On the number keys there are also various punctuation characters. These alternate characters are typed by holding-down either of the "shift" keys at either side of the keyboard, and hitting the key at the same time.',NULL,NULL,NULL), (1,'input p13','This "shifted" status can be toggled on and off by using the "caps lock" key on the left hand side of the keyboard.',NULL,NULL,NULL), (1,'input p14','In the bottom right hand corner and bottom left hand corner of the keyboard are "Control" keys which are yet another way of modifying the use of other keys which are programmed by software developers.',NULL,NULL,NULL), (1,'input p15','Finally, there are two windows-specific buttons on either side of the space bar at the bottom of the keyboard. On the left is the "Windows" key which activates the windows "Start Menu". On the right is a "Windows" key which activates the "File" menu. Both of these keys are often struck accidentally taking control away from users and confusing them. Striking either of these keys can be reversed by hitting the escape key.',NULL,NULL,NULL); /*tblcomponent diplay 6*/ insert into tblcomponent (componenttypeid,name,content,filename,path,size) values (1,'diplay p1','Computer displays show on screen what is going on in the computer. Along with the input devices (mouse and keyboard), the display is among the most important parts of the computer to learn about. Diplays are often called "monitors", or "screens" interchangably.',NULL,NULL,NULL), (1,'display p2','Displays are mainly of two types (CRTs) which are big like a television, or flat-panel displays (typically LCD) which are much thinner and lighter.',NULL,NULL,NULL), (1,'display p3','The screen is made up of tiny dots called "pixels" which change color according to instructions sent by the computer. Mainly you look at the display and use it to interact with the computer, but occasionally you may need to consider how they work.',NULL,NULL,NULL), (1,'display p4','The size of the image shown screen and the amount of pixels used to create that image have an inverse relationship. These settings are configurable, and are used to fine-tune the user''s experience. The main thing that users do is change the amount of pixels visible (making the image bigger vs. smaller) and inversely affecting the amount of detail visiable.',NULL,NULL,NULL), (1,'display p5','These trade-offs become very intuitive over time, but can be confusing to novice users. The thing to remember is that if you are unhappy with the size or detail of what is on screen, chances are there is a way to change the display settings to address this.',NULL,NULL,NULL); /*tblcomponent software 7*/ insert into tblcomponent (componenttypeid,name,content,filename,path,size) values (1,'software p1','Software is the "What" of the personal computer. Software in short establishes what we do and experience using the computer. Software goes by many names, "applications", "programs", "utilities", and many more specific names, which are really names of specific applications, like "Microsoft Word", or "Internet Explorer".',NULL,NULL,NULL), (1,'software p2','Software is commonly defined partly by what it is not (it is not the operating system). In truth the operating system is actualy made up of many individual software programs which have evolved into a larger interrelated system.',NULL,NULL,NULL), (1,'software p3','Software then is a collection of instructions or rules which are interpretted in reponse to the user''s input and make something happen.',NULL,NULL,NULL); /*tblcomponent operating system 8*/ insert into tblcomponent (componenttypeid,name,content,filename,path,size) values (1,'operating system p1','The Operating System (OS) is the "How" of the personal computer. The OS in short establishes how we can do anything using the computer. It''s main purpose is to allow applications, like "Microsoft Word", or "Internet Explorer" to be used by us. But, in fact the OS is also busy translating user input into actions, and communicating the results of these actions back to the user by updating the display, playing sound, etc.',NULL,NULL,NULL), (1,'operating system p2','The operating system is commonly defined partly by what it is not (it is not "software"). However, the operating system is actualy made up of many individual software programs which have evolved into a larger interrelated system.',NULL,NULL,NULL), (1,'operating system p3','The purpose of this "Operating System" is to be the glue that connects the input devices, the software, and the display together and have desirable things happen. It''s a hard job!',NULL,NULL,NULL); /*tblcomponent file system 9*/ insert into tblcomponent (componenttypeid,name,content,filename,path,size) values (1,'file system p1','The file system is where the information that makes the computer work are stored when the computer is off. Currently, this "data" is encoded as a series of ones and zeros in an unimaginably recursive and complex encoding system that has evolved over the last hundred years.',NULL,NULL,NULL), (1,'file system p2','Currently these ones and zeros are written on a magnetic media known as a hard drive which is like a little teeny record player and record (in one device). Consider how the same recording of music can be played on many different media (cassette tape, reel to reel, CD, etc.), but still sounds the same. Similarly, the file system contains units of information (like songs on a record) which can be renderred on different media but are still effectively the same.',NULL,NULL,NULL), (1,'file system p3','The file system of the computer stores a set of files which effectively and amazingly are the entire working set of information required to run any number of software programs, and do all the things the operating system may be required to do.',NULL,NULL,NULL), (1,'file system p4','The file system isn''t just "like" a giant hierarchy of nested containers each one containing units of information which are either individual files or folders which may contain files -- It IS a giant hierarchy of nested containers each one containing units of information which are either individual files or folders which may contain files.',NULL,NULL,NULL), (1,'file system p5','By convention, files are described by various properties which the operating system grants access to. The most basic is the file''s name. By rule, no two files with exactly the same name may be in the same folder. File names have historically been structured by a string of characters (with or without spaces) followed by a period (.), followed by a shorter group of characters which classify the file into a "type" which helps software and the operating system know what to do with the file and how to display it.',NULL,NULL,NULL), (1,'file system p6','This set of characters at the end of the file is known as the extention. As you can imagine, it is very important. Unfortunately, the display of file extentions is turned off by default, and instead the operating system shows a picture (known as an "icon") which shows the type of file it is.',NULL,NULL,NULL), (1,'file system p7','The Windows operating system also defaults to suppresses the diplay of certain other commonly used file attributes (modification date, size, and "type" which the OS calculates by evaluating the file''s extention). It is a good idea to configure these settings to give yourself more access to information about the file system, because understanding the file system is a critical skill which will greatly enhance your ability to operate the computer successfully.',NULL,NULL,NULL); /*tblcomponent memory 10*/ insert into tblcomponent (componenttypeid,name,content,filename,path,size) values (1,'memory p1','The term "memory" is used interchangably to three distinctly different parts of the working computer. As you might expect, the file system (currently stored in magnetic media on the hard drive) is one type of memory. The other main type of memory is "RAM".',NULL,NULL,NULL), (1,'memory p2','"RAM" stands for "Random Access Memory". RAM is volitile memory that is immediately available for the operating system to work with, rather than the hard drive which is comparatively slow. When the computer is off the RAM is empty. RAM is relatively expensive compared to hard drive memory. Much if not most of what we wait for when the computer is running is data being copied from hard-drive (file system) to RAM or back again.',NULL,NULL,NULL), (1,'memory p3','There are many other uses of the term "memory" which can be confusing. Sometimes memory is used interchangably with "storage". This suggests that a CD-ROM or a flash drive are a type of memory. This is actually true, but it tends to challenge the historical idea of what memory is to the working computer.',NULL,NULL,NULL); /*tblcomponent network 11*/ insert into tblcomponent (componenttypeid,name,content,filename,path,size) values (1,'network p1','"The network environment" is the collective world of computers around yours, connected by some form of communications networking. Historically, networked communications for PCs have been limited to telephone data networks (such as through a modem), and to hard-wired "ethernet" networks which are connected to through a cable, such as DSL or cable-modem. More recently, wireless ethernet has become common, and there will surely be new forms of networking in the future.',NULL,NULL,NULL), (1,'network p2','The purpose of networking is to allow communications to flow from one computer to another. This communications process is necessary to for many functions we think of as essential, for example: email, instant messaging, file sharing, and printing to remote printers, all depend on networked communications.',NULL,NULL,NULL), (1,'network p3','Among the primary things to understand about network computing is that it depends on a hardware interface (historically known as a "network" card), which must be present in some fashion for the network to work. This "card" appears on the network around it through a unique "network address", typically this is known as an "IP" address, which exactly like a phone number, allows communications with other parties on the network (who each have their own IP address).',NULL,NULL,NULL), (1,'network p4','The use of computer networks also depends on a software and operating system "layer" which are part of how networks are used. The software layer are the applications which make use of networks, for example email, web browser, and instant messenger. In the world of networking, among the primary responsibilities of the operating system is to allow authorized access and prevent unauthorized access to resources. Because networks are the vehicle of communication to and from remote computers, networking computers together -- even just for file sharing and simple communcations -- has always carried with it certain risks, specifically viruses and hackers.',NULL,NULL,NULL), (1,'network p5','Viruses are software that do bad things to your computer''s operating system, software, or your data. Hackers are people who exploit weaknesses in network security to illegally gain access to networked computers for a range of purposes (from banal to sinister).',NULL,NULL,NULL), (1,'network p6','Minimizing the risk associated with networking has driven it to evolve a great deal in a very short amount of time. For novice uses, networking has often been among the most complicated and challenging learning curves. And since advances in networking and network security are evolving in response to new threats (i.e. viruses and hackers), this has often required users to make changes and adjustments from day-to-day. In short, networking has driven changes in the user-experience more than perhaps any other part of the world of personal computers.',NULL,NULL,NULL), (1,'network p7','To put this in perspective, many (if not most) of the benefits of personal computers have depended on networking and evolved directly from granting users access to the interconnected network of computers across the globe known as "the internet".',NULL,NULL,NULL); /*tblcomponent internet 12*/ insert into tblcomponent (componenttypeid,name,content,filename,path,size) values (1,'internet p1','The internet is a global network of computers linked with unique IP addresses which allows communications over great distances. In many ways the internet works exactly like a local computer network, except by definition the internet''s network is external, owned by noone (or everyone) and all communications over it has to be secured or must be treated as if it is public.',NULL,NULL,NULL), (1,'internet p2','A great deal of smoke and mirrors obscures how the user''s computer connects to the internet. The two main environments that novice users connect to the internet from are work and home. At work, administrators typically create a local network (with a local set of IP addresses) and "route" traffic to and from the internet through a "router" which exposes a single IP address to the internet. This point is where most security is imposed and is known as the "firewall". In the work milieu, only certain resources are permitted to have an inside and an outside exposure through the firewall, typically these are servers which enable inbound and outbound email. One major exception to this are instant messenger clients.',NULL,NULL,NULL), (1,'internet p3','In the home environment, typically the internet service provider (ISP) maintains the relationship between a user''s computer and the internet. The ISP assigns an external (internet) IP address to the user''s computer, and typically maintains the inbound and outbound mail servers. At times, this means that the rest of security responsibilities are shouldered by the user.',NULL,NULL,NULL), (1,'internet p4','Some users make use of a hardware firewall/router which does the same thing for the home network that it does for the work envirnment. Namely, the firewall/router creates an internal IP address space and exposes only one IP address to the internet. Other users make use of what is called a "software firewall". Software firewalls really only make sense if there is only one computer connecting to an ISP. Even then, software firewalls have earned a reputation for being challenging to set up and maintain, and many people consider relying on them for the primary layer of security as a last resort.',NULL,NULL,NULL), (1,'internet p5','Beyond security, the main thing to understand about the internet is that it is like a highway with many different kinds of traffic on it. The world-wide-web is a network of computers which publish information through a network protocol "HTTP", where each "web site" has claimed a unique human-readable name (a domain, like http://www.cluelesspc.com) which allows users world-wide to forget about the IP address and access the resources by name alone. The servers which keep track of all the web site names and their corresponding IP addresses are called "domain name servers" (DNS), although really this is a misnomer, because they respond to requests (with come with a domain name) by returning the corresponding IP address. Thus DNSs might be better called "IP Address Servers".',NULL,NULL,NULL), (1,'internet p6','Beyond HTTP the internet''s "information superhighway" also routes email traffic, IM traffic, FTP (file transfer protocol) traffic, and much more. However, web browsing using HTTP, email, and IM currently represent the vast majority of what novice users make use of when they use the internet.',NULL,NULL,NULL); /*tblcomponent search 13*/ insert into tblcomponent (componenttypeid,name,content,filename,path,size) values (1,'search p1','When people talk about using the internet they really mean two things. The first is that they visit known web sites and follow links presented to them purely, by reading and clicking. The other thing people do is interact with web sites that specialize in directing people to information based on their input. These web sites are called "search engines", and they are among the most important resources on the internet, because they shape the user experience unlike any other.',NULL,NULL,NULL), (1,'search p2','Among the most dominant search engines are Google and Yahoo. AOL probably deserves mention also, because it is often the first search engine that many users user (since many novice users begin using the internet through AOL as their ISP). But if you really think about it, we often browse sites that present content which allows us to search, or which changes often, which in turn allows us to browse into the rest of the world wide web. These sites in many ways function like content-specific search engines.',NULL,NULL,NULL), (1,'search p3','A classic example of this is news sites. News sites focus on current events. Search engines focus on things that have historically proven of interest to users based on the searches they have submitted and the links they hav chosen to click on. The larger point is that users don''t just rely on search engines to shape and direct their browsing experience. They evaluate each quest for information and services individually, and they often contrast known (non-search) web sites along-side search engines. For information that is up-to-date, known web sites are often the strongest choice.',NULL,NULL,NULL), (1,'search p4','Having said that, searches are typically "key-word type", meaning that uesrs submit a space-delimited list of works and links are passed back whose content contains most if not all of the words. Some search engines use various kinds of logic, either by having a special syntax supported by the search string, or by presenting to the user a interface for submitting more complicated parameters (like "does not contain"). Researching the search engine is a wise strategy because it can help you overcome challenging search problems (like homonyms where one definition dramatically outweighs another). To see an example of this problem try to craft a search to return information about how spiders choose where to make spider webs. One solution (which seems to work at Google) is: "spider and web and arachnid and spiderweb (not site)".',NULL,NULL,NULL); /*tblcomponent hardware 14*/ insert into tblcomponent (componenttypeid,name,content,filename,path,size) values (1,'hardware p1','Periodically throughout our journey of being a computer user we must evaluate whether to buy a new computer or to attempt an upgrade of some kind. The question of what kind of computer to buy, how much to spend, and what strategy to use to get it is endless and unanswerrable in absolute terms. Simply put, everything is changing. In order to make sound decisions as novice consumers we need to understand the basics. The analogy of comparing cars and computers is sometimes a very helpful comparison. For example, we don''t need to know a lot about how a car''s transmission works, but it is extremely helpful to know when buying a car that there are two main types of transmission (standard and automatic).',NULL,NULL,NULL), (1,'hardware p2','This content is last for the simple reason that buying a computer is often the most complicated task that novice computer users do. Never mind that it is often the first. What follows is intended to provide a broad overview of hardware specifications and how to read them. Since the technology changes so rapidly, advice and wisdom from one period of time can become inaccurate very quickly. Instead, here is an overview intended to help you understand what is being communicated about computers when they are described in terms of their hardware specifications.',NULL,NULL,NULL), (1,'hardware p3','Other CluelessPC content has described input devices and the display. At a glance, that leaves the computer case and its contents. The case is sometimes mistakenly referred to as the "hard drive", and occasionally it is still referred to as a "CPU" or central processing unit (which is also incorrect).',NULL,NULL,NULL), (1,'hardware p4','The case has historically contained a power supply, floppy and optical drives, hard drive(s), a "mother" or "main" board, and any number of "cards" which may augment what the motherboard does, and the processor. As computer designs have evolved, more and more features that have traditionally been managed on cards have become integrated into the motherboards themselves. At this point it is very common to have a computer with no cards, with the display and all periferal devices connected directly to the motherboard. However, conceptually the architecture is the same whether it is contained in a single board or over several.',NULL,NULL,NULL), (1,'hardware p5','Motherboards are designed to work with a range of processors and types of RAM. The motherboard''s features and limitations govern whether and how other subordinate components can work with the board. In this respect, it is the most important part of the computer system. Since different families of motherboards (and processors) have very different features, comparisons between them on the basis of limited specifications can be very misleading. No part is as hard to understand, difficult to compare, and important as the processor. Naturally, it is also the most expensive.',NULL,NULL,NULL), (1,'hardware p6','The processor (the real "CPU") is a big "chip" that is attached to the motherboard and which processes most operating system and software level activities of the computer. The processor chip is described primarily by the speed it runs at (which is the product of two factors, "clock speed" and "front-side bus" speed). The processor''s speed establishes how many times per second it can go through a cycle of interpretting instructions, and which in turn establishes a (theoretical upper-limit) constraint on the speed of communications from individual devices to the operating system and software layers.',NULL,NULL,NULL); /*tblcomponent hardware 14.1*/ insert into tblcomponent (componenttypeid,name,content,filename,path,size) values (1,'hardware p7','Confusingly, within the processor are several other parts which are also described in terms of their speed. Among these is the "bus" speed (always less than clock speed) which refers to an interface for moving information to and from devices such as cards, i.e. input devices, display, storage devices, etc. The computer/chip''s bus speed is often used interchangably with "front side bus" which is basically a measure of the same thing, but is actually a factor of the bus speed (such as 2x). ',NULL,NULL,NULL), (1,'hardware p8','The chip also has several "caches" integrated into it (often described as "L1" (for "level 1"), "L2" and "L3". Caches are mechanically used to transfer information. Bigger is typically better. Since video cards and sound cards (real or virtual) have evolved into processors of their own right, they also tend to be described in terms of how fast their processors go and how much RAM and/or cache they have.',NULL,NULL,NULL), (1,'hardware p9','Hard drives are described by how much storage they have, how fast they spin, and how much cache RAM they have.',NULL,NULL,NULL), (1,'hardware p10','Optical drives are typically described by the type of drive they are, how fast they transfer information. Consumer optical media have gone through several obselescences, each yeilding to larger and larger storage sizes, and trending from read-only, to write-once-read-only, to re-writable. CD-ROMs have a capacity of about 650Mb. DVD-ROMs have a capacity of about 4.7GB. Hi-density (HD) DVDs have a capacity of about 8GB. When each new media type comes out it sets a baseline for the speed of that media. Subsequent improvements to the speed of the optical devices is described as a factor of that individual baseline. Thus a "4x" DVD drive may be much faster than a "24x" CD drive. Write speed is the primary means of comparing writable optical drives.',NULL,NULL,NULL), (1,'hardware p11','This brings into focus how difficult it can be to compare specifications; things which seem to be identical (but which are not) may lead to spurrious conclusions. This has led to the creation of published benchmarks which strive to isolate individual system components and compare them to one another. When in doubt, read everything you can about a technology to understand the choices, and try to choose wisely.',NULL,NULL,NULL), (1,'hardware p12','Many companies and individuals have developed a strategy to buy on a pre-determined cycle, at a given price-point, and/or from a single vendor to simplify the shopping process. I would recommend that novices try to imitate this strategy. However, buying a computer is often like weighing whether to fix an old car or buy a replacement, where neither choice is really desirable, and either one may in fact be the most expensive.',NULL,NULL,NULL), (1,'hardware p13','Furthermore and in conclusion, CluelessPC is a multi-lingual web site serving a community of novices world-wide. While it may seem to an individual that there is a conventional wisdom about how to by a system and what kind of system to buy, any convention or assumption about what to spend, how to buy it, and so on breaks down as you enlarge the universe you are trying to generalize to.',NULL,NULL,NULL); /*tblcomponent hardware 14.2*/ insert into tblcomponent (componenttypeid,name,content,filename,path,size) values (1,'hardware p14','What we can say for sure is that upgrading (and for that matter buying, building, installing and configuring) hardware within the case is not the purview of novices and should not be attempted outside of a specialized class or setting designed for this purpose.',NULL,NULL,NULL), (1,'hardware latin p3','Other CluelessPC con...it amet, consectetur, adipisci velit, sed quia non numquam eius modi tempora incidunt ut labore et dolore magnam aliquam quaerat voluptatem. Ut enim ad minima veniam, quis nostrum exercitationem ullam corporis suscipit laboriosam, nisi ut aliquid ex ea commodi consequatur? Quis autem vel eum iure reprehenderit qui in ea voluptate velit esse quam nihil molestiae consequatur, vel illum qui dolorem eum fugiat quo voluptas nulla pariatur?',NULL,NULL,NULL), (1,'hardware latin p5','Motherboards are designed...qua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.',NULL,NULL,NULL), (1,'hardware latin p7','Confusingly, within the pr...am voluptatem quia voluptas sit aspernatur aut odit aut fugit, sed quia consequuntur magni dolores eos qui ratione voluptatem sequi nesciunt. Neque porro quisquam est, qui dolorem ipsum quia dolor sit amet, consectetur, adipisci velit, sed quia non numquam eius modi tempora incidunt ut labore et dolore magnam aliquam quaerat voluptatem. ',NULL,NULL,NULL), (1,'hardware latin p10','Optical drives are typ...Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.',NULL,NULL,NULL), (1,'hardware latin p12','Many companies and indi...Nemo enim ipsam voluptatem quia voluptas sit aspernatur aut odit aut fugit, sed quia consequuntur magni dolores eos qui ratione voluptatem sequi nesciunt. Neque porro quisquam est, qui dolorem ipsum quia dolor sit amet, consectetur, adipisci velit, sed quia non numquam eius modi tempora incidunt ut labore et dolore magnam aliquam quaerat voluptatem. Ut enim ad minima veniam, quis nostrum exercitationem ullam corporis suscipit laboriosam, nisi ut aliquid ex ea commodi consequatur?',NULL,NULL,NULL), (1,'hardware latin p13','Furthermore and in concl...Sed ut perspiciatis unde omnis iste natus error sit voluptatem accusantium doloremque laudantium, totam rem aperiam, eaque ipsa quae ab illo inventore veritatis et quasi architecto beatae vitae dicta sunt explicabo. Nemo enim ipsam voluptatem quia voluptas sit aspernatur aut odit aut fugit, sed quia consequuntur magni dolores eos qui ratione voluptatem sequi nesciunt. Neque porro quisquam est, qui dolorem ipsum quia dolor sit amet, consectetur, adipisci velit, sed quia non numquam eius modi tempora incidunt ut labore et dolore magnam aliquam quaerat voluptatem.',NULL,NULL,NULL), (1,'hardware latin p14','What we can say for sure...Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.',NULL,NULL,NULL); /*tbldoccom*/ insert into tbldoccom (documentid,componentid,languageid,sortorder) values (1,1,1,1), (1,2,1,2), (1,3,1,3), (1,4,1,4), (1,5,1,5), (1,6,1,6), (1,7,1,7), (1,8,1,8), (1,9,1,9), (1,10,1,10), (1,11,1,11), (2,12,1,1), (2,13,1,2), (2,14,1,3), (3,15,1,1), (3,16,1,2), (3,17,1,3), (4,18,1,1), (4,19,1,2), (4,20,1,3), (5,21,1,1), (5,22,1,2), (5,23,1,3), (5,24,1,4), (5,25,1,5), (5,26,1,6), (5,27,1,7), (5,28,1,8), (5,29,1,9), (5,30,1,10), (5,31,1,11), (5,32,1,12), (5,33,1,13), (5,34,1,14), (5,35,1,15), (5,36,1,16), (5,37,1,17), (6,38,1,1), (6,39,1,2), (6,40,1,3), (6,41,1,4), (6,42,1,5), (7,43,1,1), (7,44,1,2), (7,45,1,3), (8,46,1,1), (8,47,1,2), (8,48,1,3), (9,49,1,1), (9,50,1,2), (9,51,1,3), (9,52,1,4), (9,53,1,5), (9,54,1,6), (9,55,1,7), (10,56,1,1), (10,57,1,2), (10,58,1,3), (11,59,1,1), (11,60,1,2), (11,61,1,3), (11,62,1,4), (11,63,1,5), (11,64,1,6), (11,65,1,7), (12,66,1,1), (12,67,1,2), (12,68,1,3), (12,69,1,4), (12,70,1,5), (12,71,1,6), (13,72,1,1), (13,73,1,2), (13,74,1,3), (13,75,1,4), (14,76,1,1), (14,77,1,2), (14,78,1,3), (14,79,1,4), (14,80,1,5), (14,81,1,6), (14,82,1,7), (14,83,1,8), (14,84,1,9), (14,85,1,10), (14,86,1,11), (14,87,1,12), (14,88,1,13), (14,89,1,14), (14,90,2,3), (14,91,2,5), (14,92,2,7), (14,93,2,10), (14,94,2,12), (14,95,2,13), (14,96,2,14);