4.10: section 11: databases and software development

-a piece of information which determines the properties of a field or tag in a database or a string of characters in a display.

-an attribute that provides an unique identifier for every entity in a database table

-a primary key made up of more than one attribute

• links tables via a shared attribute - the attribute must be a primary key in one table

• the process of coming up with the best possible design for a relational database to allow faster searching and sorting • no data is duplicated • data is consistent across tables • flexible structure allowing as many entries as desired • user is able to make complex queries

• no repeating attributes or groups of attributes - the database data is atomic (meaning no single column contains more than one value)

• no repeating attributes or groups of attributes - no partial dependencies

• no repeating attributes or groups of attributes • no partial dependencies • no non key dependencies • all attributes are dependent on the key

• easier to maintaining and modifying the database • faster sorting and searching • accidental deletion of records is prevented

SELECT attribute FROM table WHERE condition ​ORDER BY ASC/DESC

UPDATE table SET attribute = value WHERE = attribute = value

DELETE FROM table WHERE condition

INSERT INTO table (column1, column 2 , …) VALUES (vaule1, value2 , …)

CREATE TABLE Artworks (Title VARCHAR(225), Artist VARCHAR(255), Date YEAR, PRIMARY KEY (Title, Artist))

SELECT * FROM table1 INNER JOIN table2 ON table1.column_name= table2.column_name;