Jag skulle vilja ha med både användare och kommentarer! Hittade en sida som verkar ganska bra: http://marcgrabanski.com/articles/create-blog-from-scratch
Slänger in kravspecifikationen, så förstår du vad de vill ha, svårt att förklara allt
B. Logical database design:
1. Create a set of normalized (3NF) relations for your
database.
2. Identify the primary key and any foreign keys for each
relation.
C. Physical database design:
1. Determine the appropriate data type for each field in your
database.
2. Determine data integrity controls for the fields in your
database (e.g., default values, range controls, and null
value controls).
3. Identify and describe any referential integrity constraints
needed to guarantee the integrity of your database.
4. Identify and describe any indexes needed for non-key
attributes.
5. Consider whether you should demoralize some of your
relations in order to reduce the time needed to retrieve
data from your database. Present the justification for
your demoralization decision. If you decide to demoralize
some of your relations, present a new set of (partially)
demoralized relations for your database.
D. Database implementation:
1. Implement the database using Oracle, MySQL or MSSQL
server.
a. Define your database using Oracle, MySQL or MSSQL
server.
(1) Create the tables needed to implement your
database.
(2) Define data types, primary keys, indexes, data
integrity constraints, and referential integrity
constraints.
b. Develop a set of test data to test your data integrity and
referential integrity constraints. Your test data should
consist of data that you expect to fail because of the
enforcement of your data integrity and referential
integrity constraints. Enter your test data and verify
that your constraints work.
c. Add sample data that does not violate your constraints
to the database tables. These data will be used to
demonstrate that the database works.
d. Design and execute at least 8 SQL-queries to retrieve
data from your database.
e. Design relational algebra queries for SQL-queries in
part d
En fråga till: kan jag få bloggen att "fungera" utan att behöva lägga upp den?