here you have the data base with table and formulary
here you have it in excel format
miércoles, 8 de junio de 2016
martes, 24 de mayo de 2016
DATABASES
A database is a structured collection of records.
We use it to:
-add, remove, update records
-retrieve data that match certain criteria
-cross-reference data in different tables
-perform complex aggregate calculation
Data bases are use to store data that has any relation (books: author, themes, genre, editions...)
Databases consist of colums and rows (records).
![](https://lh3.googleusercontent.com/blogger_img_proxy/AEn0k_vJ0l5E2eattgSBadeUm6p3am44H8RNI7WOltGs9XACCSSwfgLOgFVbkXCpQynmLg4j5CClpEQUg0voH4e4eidaXq-SaYD2cJxAZRYGZlIZzR8ssFxc59wSc3eQ0QlYKTaXXVCVFJjQpIpE=s0-d)
Relational databases:
A relational database is a digital database whose organization is based on the relational model of data, as proposed by E. F. Codd in 1970. The various software systems used to maintain relational databases are known as a relational database management system (RDBMS).
A primary key uniquely specifies a list of ordered elements within a table. In order for an attribute to be a good primary key it must not repeat.
A foreign key is a field in a relational table that matches the primary key column of another table.
![](https://lh3.googleusercontent.com/blogger_img_proxy/AEn0k_uwSXMcBV6jLOzN-VYe_X4sSea2qTw1G8HkduSXGIh9r8G4hF9x-oF8Ce9vtRtPxudR7IIu0nSmW00b-Uc-eu2ur4ZrMa_0LdSWofnQkytM55XJOehFKiP-gmXmPkikcNsCyMLASjPd14WokCn7QZeExm6rN0zU1otooAXoxNYJDZOhIA=s0-d)
![](https://lh3.googleusercontent.com/blogger_img_proxy/AEn0k_vhORSJTqFGJYvUcM3wJaJ_Ap5SheYOGZ5QCAy8kgHXMAkSV25mgu7pYLG8gppoFZmGN-kSwzwStfJtyRqvFpI_eDJMR0b7b4sgSEbfCAwxjIiKHTPfR5wY_SJZQVmr-jPu3pqphCMRdn0MkiG3O47uK8yCuFkh2bNvo-q8PlYeoLiD_7fxMDBVYW-2BVTq0wMPOQo1MA=s0-d)
We use it to:
-add, remove, update records
-retrieve data that match certain criteria
-cross-reference data in different tables
-perform complex aggregate calculation
Data bases are use to store data that has any relation (books: author, themes, genre, editions...)
Databases consist of colums and rows (records).
Relational databases:
A relational database is a digital database whose organization is based on the relational model of data, as proposed by E. F. Codd in 1970. The various software systems used to maintain relational databases are known as a relational database management system (RDBMS).
- Primary key / Unique key:
A primary key uniquely specifies a list of ordered elements within a table. In order for an attribute to be a good primary key it must not repeat.
- Foreign key:
A foreign key is a field in a relational table that matches the primary key column of another table.
martes, 10 de mayo de 2016
DIGITAL SOUND
- DIGITAL SOUND VS ANALOG SOUND
Digital one is the one that catches original sound and tranfer it to digital idiom (binary system).
Sound is naturally an analog signal. An analog signal is continuous, meaning that there are no breaks or interruptions. One moment flows into the next. If you were to hum a descending note, people hearing you would be able to detect the change in pitch, but not point to specific moments when the pitch jumped from one note to the next.
Digital signals are not continuous. They use specific values to represent information. In the case of sound, that means representing a sound wave as a series of values (0 or 1) that represent pitch and volume over the length of the recording. In a primitive digital recording of that descending note you hummed, you'd hear a single long sound as a collection of shorter sounds.
Digital sample rate:
In developing an audio sound for computers or telecommunication, the sample rate is the number of samples of a sound that are taken per second to represent the event digitally.
The more samples taken per second, the more accurate the digital representation of the sound can be. For example, the current sample rate for CD-quality audio is 44,100 samples per second. This sample rate can accurately reproduce the audio frequencies up to 20,500 hertz, covering the full range of human hearing.
Bit depth is the number of bits of information in each sample, and it directly corresponds to the resolution of each sample.
![Resultado de imagen de bit depth music](data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAQsAAAClCAMAAAB86ihKAAABJlBMVEX///8AAACRkZGmpqbQ0NDh4eHHx8f7+/tubm5ISEgAar3r6+uwsLDw8PCGhoZRUVEAesO0zeex1OsAdcGhzunv9/ynzOfN5vSYxOTL3O5sp9aRxeUAb7+Vut4Abb5+stvl8vlJnNAoQVgAf8YthMdHk810tN3B2+7b29uHuN7c7vdZmM+5ubnN5PM/Pz9fqNdra2szMzMtisoiIiKkwuJ8fHyZmZkAM1NsbGwqKioQEBBhYWFaWlp7qtdOTk4WFhYAZakAcrYaKzsnND8AITcKRGlNSEI8e7BicnwMX5UlkM4AS3kAO2QAHjCOttwAYrq2xc6cvNA/h7h9rclek7wAFjOWrbsAUpNtkq5Lg6iuuMBRXmcAK1B9oLU+YHVEVmI3Q0oAGy8B0UU3AAANLklEQVR4nO2daYOiOBqAiRcqYNFG1NYUwqAilEdJtXaXZR3d07O97ezUHDvnzsxOz///ExvwAJVw2F1S1ZvnQx0CL/ExCYHEhBEKeYF5TPTH06ROzYGbx+WCB6WkTs2BE+piBXXhQl24UBcu1IULdeFCXbhw4MOzIEzyobXAA58phyUoSRezn+QiEVmukA9tFlHAkcXnhyVoz4XSul5xH/DBBKOvQ1y3AmLgfFEtExnBIBewSz6yIX8qFyaEyAZCa3BYSIapoGUMBEWdvFdwfVEPdlElb6x+snxhwobpsPgIF9BYxhhpCbiof0IX18s/Oh/jor78o5tEvqAuPEdSF+6R1IV75EO4qB0W8vNxobguysuLgSnFDeq60ALy1uN1cd1esXEBtRVGVBmNVQht4wJqq5fq7N7ej9dFA3ZW3C9faJ2tQK2oLs42MVZJba7/R8aTciHWlCU775wtRnfR3okhrf4dFJ+WC41w6yDFcUGIoTwxFyJ1QV1soC5cItUXUYMFudh/EbvgWBKOC+JG2wXxUNsFcePyeJKLr9p2G6Itaqb/gZJsqUtGiv8eg9FqB61NiKFsYqibGAw3uzjPE/nr5V+Hbvzjd/JGzHmKkB158OaLFYSEvVpvf/nyyn+P31++DIlxvonxxyrGqxTOF8N+jsif7/88dOMvP5M32mQIGYMH55ngIzf89v4//ht+fv9b1Bi//rKOkXkCz7XIjDTFf4PeHkWNYRTdGI+37gyFHZFq1+guWOrCjUFduDGoCzfG5+NiIK1YvbL8hy1rMVysY7BP2oWK1l1+y7cuNdaddii6i02M7pN2UWktaYhrF2j1SisgZduUNzGetItNkdC1Tb5g16/Fj/G0XawZuC4OOyeGunChLlyoC5fPyIVdBbLKx7h40OuILgVDOPAgF+3lw5v2R7hoh7tonBI5E4NcoLNGMIr/gYe4WLSX/WltMe6hGyTdDHOBggZzBeeLECChY/MAF6yyIe6hWwS7UGqBxO7jjQAd3+lCXbhQFy7UhQt14UJduFAXLtSFC3XhQl24JOpimMskArFvOd9LJD097CIpMiQXCTFjhFRScP4uMkmlJ7Gv0VMoFMoTJ+O0bfgJbnLlCo+g3ZVL5fDP7LyHf5byxz31BbB/peeZLJNNC1dJTxmTmUxv+9jFOJcVmFw/d9E/3rlZfuniMn+ZyZz3ZuN+5D7qh2Kcxu3hYf5kwqYnU3ByxDP3gf1Z8IVefp4Dwjyxu4ENuVmOL02H/R7IlW56s9wRT41dZPlces6mbjIz4Sp1xFP7krtIMTm+P+4xoF866c16Rzx3f1lGbktjPnchpIbHPLcPmYvLNL5VyRbm51dcac6Nj/nhZNP2z16/32c4nhXS2SOe24cen55iF0Kuj1OS6eMskmx6KBQKhUKhUCgUCoVCoVAojxJuRseirKHjclyoCxfqwuUpuRCy/GQyyaezwsN07T0dF73p5Xpo1UWJNPLto3gqLrjpGICrdB/Dv5qB29IDdOM8CRc1s3cDwH+5VUqF7BSAA/v3gqa89HPBbmZB+EhCvnLoy44LVjEWEN4B8PbOO3cBdwVA7E5nSR9BB8tQ/N6bnwvlW9mZ7Tzg+5jRzt1Zfs3uLM5B2y4GDRFB693f4OVrqCqeD5UtEUeIEmDLC4S0ztnZmQWRaPhMI7LrQqqfnrZgp2UYKhxVq5HnTtjj+f3pvaXhOA2xg+NEnvLd64KtWkhUn+m/YxWiqNnzbqrrOWqFEjghDBH1RWnh/HCqm4qkDKojiDr7n/SuC0VDRVk2JHtaNQhFGONs27yQURG1JZatiTiOWI56nMeF1BLRQpeYHABYhSji5EDNDTQE6ejJMVUIu8omsr7AWWN3ny0XrCIN2qo+aNrfHR00m80FYuOV9vW5FOkFatbKFVwspUqzooqVqNWG60JZpVe4BO/FNR4XHIg+NmOgwfbWrMeSIcLWTqWx5UKHchGpbpqVDrQs7QAZjWIRyZ6sYEDN0pqRDt24sE/uhOiDL9p+LpgUiDpueSDCs91SWoVwZ67GbRfawmhV3R3Mrqpa8gEurmHX8K7oUFXVBexGOnTtAmdqa/lJzsGvFty48Hy6GXARLTlmB54pe6/WIdye8HHLhT15gncCRVxAlFbxIBc1xuscB6rul09fVi6kFlxPXz0rfK8uMJojQ+1ilpdXbg4iXfalBvSduxLL2KrGXBfVxcLa/+xYA426o1gTtuOEa3Dv3GVx0R1VwtO+ctFC6+o2A1aDPA0nczgNhNV8BqlobQwD7ifHhjXg1nThrou62O4s9j471hA1UQ6YbH2ftmh1OvsuLE1Eo6guykhcX/P6YLL8o7spKKK8fCUdqcLQoUhoKUkq9NSO3nwBDbOm7O1v6nor3roqbUs3a3tvWtH1apQpwBwXZtut5NNgNXrN4wLtbAqCtfYuGG6iRG/9uXJhVirkNWiqcrdSUcLPalOuVLQOYV9TW1QqYWsCOC4a0I2RXl9YDnRhIIvc0KvKnnkvVy6aRdyQIbrAJTRoPRcvbQQh0YUlQvlFSADbRd1bjt36wpn+3qlB0fI2ZwrCB/npWlA7jx3BxeaflYsKbnDXSfrMerXTjujCsox6mXDlkapVA52GBMAucCPLU4dzYL5sa+PSqutl1c4d0JkSxpiA0Dt3fA0JLJgDS97cZ2xcBN95BK7z48UiZYol4fPfYxdNZHmDXF54rhb4vW2uJu/+AULTo4so+FbIcLOx7YKtmcZ6IQYCI63iU6/uwpo1a/8KsrVHcVQLThsP/qmhrVw98d53rFw4vAdXoSlSUUgTT7E2b912ge/RUZgLhIrh7caaJaMwF1BeBO2AXfwLjrbyjgDGblHwuHj9Tfhde1luK2G7oPV6N9gFK8md+/vgy2b1vhGhDT2w2qfPgsvA/bWmBu6AXezUTezEcxvvcfE1uAp7JMcudu85fNjsw80+1A0UoXmMb2BD96lZUfax6vWA9id20djZ2rt0rxdSt21hnBJyEdrqrIRkU4cyXOUdbvb2NW5whB7A1BbBedvZJ5IL/MEGhOLBV3vVNA8uNqXBuZoOcAl5G964kDohRX+517pO4Waz4XBYCOfDm7dvvgzZA+9yExpoOMShCoUJ4aEUft97MW4KAKS9mcXEuQJ8E3quN39HSA9O0dufPhSGU1xfFDLZKHz37u7ux17QHv++u7v7gYsQKvPDuyzHEb/bP9mPwaUAmHgqyu++BuDl6+/Dkxy2i0Pvx7sfs1khep+A2R3BRmC92ISdUaRnFIqqXV8/I7rw7R/pX4KLCe/oyPKlMbhNN2Aj5DxVGPE5VFlr25eS6P0jrFm8DnFRJa4esYWiQohIXkn9ZsLU7jDD5Xlod5/hElYLXPMSI2koQm3hoDpPdWL0FdWK99LuOkobWFMxQtqu7r6KWZNJXsn9qWw6f2K7ODlPO0nuouA27sj7uDKYGrLb1XFc2Gt2kEybGr5ritGD8G3cfOHA2sV7nfc8LUY/Bt5n5mGoqBE2P/gWNc3SiA0uU7ZGo+iPfFijHK++8KMKScv4MM5zmt12SgADDZZj9afaE7ITXRQNKVptEUIMF1IDdYgbT/2fcZIw5LC5THcpa2q1vp/z9NFIjVxPhRBnLMrAIrYSy1rQlLT7KGpsF1CW0X6j8ZksaloCLuyrpn+dgC2FXXF3MOOVEWzv+fOq5eeiORgo8c5NIt4YpQbyXVRVspAaNz2x6s4le/clpl4z5Og1dhjxXOA7Dp+FN/AdRoR7sj3iu7BQsehtz13jYlNMyoXdbttbElW3kBWrF2NFbBem0Wi0LXO58iSLfzWg8eL04FXk94g7jg/LsKretoo9UKFziIoDxihJkqmKnbMz+wHIQD07a/t3Sh1K7DGNuEBoI7enQW+ISD0sRYeM15JU++lrR9f1pt3bG9DgOYD44zvt4QOaWrGbN4PmAv/ts2RuJA4du2aPWbEXgInWeR6DQ8a61hpthGQbBC3SJOzhHOpCqr5wOKhgBnHYuF/9tNFpa1an9ezgtbqfyJjGKEjKYHDACt1ePhsXnwDqwoW6cKEuXKgLF+rChbpwoS5cqAsX6sKFunDhZuNpOgl44vrscz6RBGWwi0QmaQePb974PCNMk5qmnTD+opdQelJHnEuXQqF8NrAZuy7rJTzB7TZszr7uZo85AXHvhmcY4SRnjyqdMJmkm179eZoRJnNn/mNbw+SKeZBv8vshDO1v5wiFNJ9lBLYPJsnOlS6kLkpCoWQnIjvu8xwjCEdrirKl6XjKCtzNvDTrla54cJ50xiik+IvJJCsIveF5fsxNhmlwpGUFMrPpbT51zt/0GZBOnQu38b4l/gAMU+nLzDxfyvPDDAtypXn29kjVWG6eB1eZbLbAM4BPXQkxvzH/AAxT/IzBGYPLjHMCdnHSC//KzKc7eRoX01fDywmTmrD5xO9b51N2Mj7B1Wb2qnBZYnBevZof7eTOHBucgOVzHMNmk607l8lxEsE6aRLsNCWcJMr/Mf8Dv/HVHC2lI94AAAAASUVORK5CYII=)
Bit depth is the number of bits of information in each sample, and it directly corresponds to the resolution of each sample.
Processing
Suscribirse a:
Entradas (Atom)