LANrena Neustetten e.V. :: Forum > Access Normalisierung

Sonstiges >> TechTalk > Access Normalisierung

Antwort erstellen

|LR|Ro

24.06.2012 um 21:42

Antwort Benutzerprofil Nachricht senden

NEW

Clan: LANrena
Postings: 227

Hey Leute,

ich such jemand der mir ausführlich erklären kann,

was ist in Microsoft Access die Normalisierung?
und was sind die Normalisierungsstufen?

Würd mich über schnelle Antworten freuen

Liebe Grüße und vorab Danke

Ro
__________________
__________________
#LANrena Neustetten e.V. - Mitglied
#LANrena - Kleiner Stinker für Grobes
#LANrena - Handstandmarathonläufer

|LR|IcE-CoL7

24.06.2012 um 22:56

Antwort Benutzerprofil Nachricht senden

NEW

Clan: LANrena
Postings: 1629

guckst du hier:
http://de.wikipedia.org/wiki/Normalisierung_(Datenbank)

bis zur 3. ist normal
alles höher ist eher unwahrscheinlich und theoretisch

[Editiert von |LR|IcE-CoL7 am 24.Jun.2012 um 22:57]
__________________
#LANrena Neustetten e.V. - Finanzvorstand
#LANrena 10 Lost in Space - Projektleiter

Antwort erstellen

LAN-Party

27. Sep 2019 - 29. Sep 2019

18 16 / 24

Frei:: 8
Angemeldet:: 18
Bezahlt:: 16 / 24
Sitzplatz :

Anmelden/Status

Forum

16:30 Lanrena 2020? 1
LastPoster: Alba
Zeitpunkt: 28.01 16:30
21:53 Mini Maker Fair... 1
LastPoster: |LR|mag!c
Zeitpunkt: 25.10 21:53
15:53 für Lau 160
LastPoster: |LR|=quiEtschEEntchEn=
Zeitpunkt: 27.09 15:53
12:38 [V] HP Microser... 1
LastPoster: |LR|mag!c
Zeitpunkt: 23.06 12:38
09:07 Stellenanzeige ... 0
LastPoster: |LR|Ro
Zeitpunkt: 22.05 09:07
09:57 Feedback - LANr... 5
LastPoster: [mmS]CPCracker
Zeitpunkt: 02.05 09:57

Umfragen

Derzeit gibt es keine aktuellen Umfragen.

Umfragen

Partner

Suchen

------------------- found 185 debug messages 0.000017 - GLOBAL::include -> config.php 0.000487 - dotCommon::classload -> require: /www/htdocs/w00f1046/includes/class.dotDatabase.php 0.000776 - dotDatabase::getInstance -> connection: database 0.000789 - dotDatabase::__construct -> connection: database 0.000802 - dotCommon::classload -> require: /www/htdocs/w00f1046/includes/class.page.php 0.001233 - page::getInstance -> do 0.001272 - dotCommon::classload -> require: /www/htdocs/w00f1046/includes/class.dotSession.php 0.001635 - dotSession::getInstance -> do 0.001649 - dotCommon::classload -> require: /www/htdocs/w00f1046/includes/class.user.php 0.002000 - dotSession::start -> ---- init 0.002015 - dotSession::start -> start php session managment 0.002054 - dotSession::start -> finished php session management 0.002061 - dotSession::start -> check for security options 0.002066 - dotSession::start -> update current session online user infos 0.002073 - dotDatabase::connect -> d030eee4@localhost 0.002300 - dotDatabase::select -> database: d030eee4 0.002494 - dotDatabase::query -> UPDATE session SET lastactivity = 1743816051, userid = 0, site = 'https://lanrena.christoph-raible.de/forum/thread/1589', host = '3.128.172.222', dns = '3.128.172.222', countrycode = 'US', hits = hits + 1 WHERE hash = '9fb524e1bd78d9fb390e574ade601b64' 0.002762 - dotSession::start -> session found in DB 0.002769 - dotSession::load_locales -> do 0.002783 - dotSession::load_locales -> chosing language for locales: de_DE.UTF-8 0.002788 - dotSession::start -> ---- finished with session startup 0.002800 - dotSession::load_user -> id: 0 0.002805 - user::get_user -> id: >0< 0.002811 - dotDatabase::getInstance -> connection: database 0.002826 - dotCommon::classload -> require: /www/htdocs/w00f1046/includes/class.styles.php 0.003066 - styles::load -> name: >< 0.003078 - styles::load -> include: /www/htdocs/w00f1046/html/styles/lanrenav3.php 0.003366 - styles::activate -> style = lanrenav3 0.003439 - dotCommon::classload -> require: /www/htdocs/w00f1046/includes/class.admin.php 0.003603 - admin::getInstance -> do 0.003610 - dotSession::getInstance -> do 0.003616 - admin::__construct -> user_id=0 0.003621 - user::load_settings -> load current user settings to $global 0.003630 - dotCommon::classload -> require: /www/htdocs/w00f1046/includes/class.prvmsg.php 0.003888 - dotCommon::classload -> require: /www/htdocs/w00f1046/includes/class.event.php 0.004353 - EVENT::comming_event -> return 0.004371 - dotDatabase::query -> SELECT id FROM events WHERE UNIX_TIMESTAMP(end) > 1743816051 AND active=1 ORDER by begin ASC 0.004552 - dotDatabase::query -> SELECT id FROM events WHERE UNIX_TIMESTAMP(end) < 1743816051 AND active=1 ORDER by begin DESC LIMIT 1 0.004770 - dotCommon::classload -> require: /www/htdocs/w00f1046/includes/class.sitzplan.php 0.005091 - GLOBAL::end global.php -> --------------------------------------------- 0.005179 - dotDatabase::query -> SELECT * FROM sponsoren WHERE group_id = '1' AND active = 1 ORDER BY display_order DESC 0.005344 - dotDatabase::query -> SELECT * FROM sponsoren WHERE group_id = '1' AND active = 1 ORDER BY display_order DESC 0.005476 - dotDatabase::query -> SELECT * FROM sponsoren WHERE group_id = '6' AND active = 1 ORDER BY display_order DESC 0.005584 - dotDatabase::query -> SELECT * FROM sponsoren WHERE group_id = '6' AND active = 1 ORDER BY display_order DESC 0.005692 - dotCommon::classload -> require: /www/htdocs/w00f1046/includes/class.forum.php 0.006730 - FORUM::showthread -> get common forum and thread infos 0.006737 - FORUM::thread_lastvisit -> threadid: 1589 0.006746 - dotDatabase::query -> SELECT postid FROM forum_post WHERE threadid=1589 AND dateline > '' ORDER by postid ASC LIMIT 1 0.006905 - dotDatabase::query -> SELECT threadid, dateline FROM forum_post WHERE postid=17490 0.007038 - dotDatabase::query -> SELECT (COUNT(*)+1) AS position FROM forum_post WHERE threadid=1589 AND dateline < '2012-06-24 21:42:14' 0.007169 - dotDatabase::query -> SELECT f.title AS forumname, f.catid, f.closed AS forum_closed, f.moderators, t.forumid, t.title, t.closed AS thread_closed, t.invisible AS thread_invisible, t.fv_id, f.priv_access, f.private, t.replies, t.ext, t.ext_id, t.show_latest, t.sticky, t.lastposttime FROM forum_thread AS t LEFT JOIN forum_main AS f ON t.forumid=f.forumid WHERE t.threadid='1589' 0.007366 - FORUM::is_moderator -> for forumid: 45 0.007379 - dotDatabase::query -> SELECT moderators FROM forum_main WHERE forumid='45' 0.007446 - admin::getInstance -> do 0.007462 - admin::hasRight -> check for adminright: >0:0 & 32< FALSE 0.007484 - admin::getInstance -> do 0.007493 - admin::hasRight -> check for adminright: >0:0 & 16777216< FALSE 0.007499 - admin::getInstance -> do 0.007508 - admin::hasRight -> check for adminright: >0:0 & 64< FALSE 0.007527 - admin::getInstance -> do 0.007535 - admin::hasRight -> check for adminright: >0:0 & 32< FALSE 0.007539 - admin::getInstance -> do 0.007545 - admin::hasRight -> check for adminright: >0:0 & 16777216< FALSE 0.007553 - admin::getInstance -> do 0.007559 - admin::hasRight -> check for adminright: >0:0 & 64< FALSE 0.007569 - dotCommon::classload -> require: /www/htdocs/w00f1046/includes/class.html.php 0.008160 - dotDatabase::query -> SELECT title FROM forum_cat WHERE catid=3 0.008208 - dotDatabase::query -> UPDATE forum_thread SET hits=hits+1 WHERE threadid='1589' 0.008377 - dotDatabase::query -> SELECT user_id FROM user_orga WHERE display_team=1 0.008439 - FORUM::showthread -> query all postings 0.008447 - dotDatabase::query -> SELECT postid, threadid, userid, pagetext, htmltext, locked, invisible, remoteip, locked, forum_post.dateline, UNIX_TIMESTAMP(forum_post.dateline) AS stamp, user.id AS user_id, user.nick AS user_nick, user.clan AS user_clan, user.clantag, user.stats_postings AS user_postings, user.motto AS user_motto, user.female, user.countrycode, user.avatar,user.avatar_name, edit_user_id, UNIX_TIMESTAMP(edited) AS edit_unixtime, edit.nick AS edit_nick, IF(edit_user_id > 0,0,1) AS history, attachment_id, filename, filesize FROM forum_post LEFT JOIN user ON user.id = forum_post.userid LEFT JOIN user AS edit ON edit.id = forum_post.edit_user_id LEFT JOIN forum_files ON forum_post.attachment_id = forum_files.id WHERE threadid = 1589 AND forum_post.invisible=0 ORDER by postid ASC LIMIT 0,30 0.008736 - HTML::encode -> ____________________________________ [color=blue]#LANrena Ne... 0.008751 - dotDatabase::query -> SELECT `code`, `smily` FROM html_smilies ORDER by LENGTH(code) DESC 0.009035 - dotDatabase::query -> SELECT codetag, codereplacement, twoparams FROM html_code 0.009082 - HTML::encode -> replace run 1 0.009106 - HTML::encode -> replace run 2 0.009140 - HTML::template -> template: >forum_postingpart< 0.009214 - HTML::encode -> __________________[color=#0040FF]#LANrena Neustetten e.V. [/... 0.009311 - HTML::encode -> replace run 1 0.009328 - HTML::encode -> replace run 2 0.009353 - HTML::template -> template: >forum_postingpart< 0.009379 - HTML::template -> template: >forum_postingindex< 0.009419 - FORUM::showthread -> check for moderator utils 0.009425 - FORUM::update_visit -> forumid: 45 threadid: 1589 posttime: 2012-06-24 22:56:47 0.009444 - GLOBAL::end userspace -> --------------------------------------------- 0.009448 - PAGE::render -> start rendering page layout 0.009451 - USER::check_for_new_messages -> return 0.009458 - dotSession::getInstance -> do 0.009472 - PAGE::get_boxes -> -------- side=left 0.009481 - dotCommon::classload -> require: /www/htdocs/w00f1046/includes/class.cbox.php 0.010122 - PAGE::get_boxes -> -------- call: left::menu_main 0.010133 - CBOX::menu -> generate Menu Box >news< 0.010142 - HTML::template -> template: >box_menu< 0.010185 - HTML::template_exists -> search: >page_box_left< == 1 0.010204 - HTML::template -> template: >page_box_left< 0.010285 - PAGE::get_boxes -> -------- call: left::menu_site 0.010292 - CBOX::menu -> generate Menu Box >site< 0.010301 - HTML::template -> template: >box_menu_bit< 0.010329 - HTML::template -> template: >box_menu_bit< 0.010341 - HTML::template -> template: >box_menu_bit< 0.010350 - HTML::template -> template: >box_menu_bit< 0.010359 - HTML::template -> template: >box_menu_bit< 0.010369 - HTML::template -> template: >box_menu_bit< 0.010377 - HTML::template -> template: >box_menu< 0.010394 - HTML::template_exists -> search: >page_box_left< == 1 0.010405 - HTML::template -> template: >page_box_left< 0.010418 - PAGE::get_boxes -> -------- call: left::menu_verein 0.010424 - CBOX::menu -> generate Menu Box >verein< 0.010431 - HTML::template -> template: >box_menu_bit< 0.010487 - HTML::template -> template: >box_menu_bit< 0.010507 - HTML::template -> template: >box_menu_bit< 0.010525 - HTML::template -> template: >box_menu_bit< 0.010550 - HTML::template -> template: >box_menu_bit< 0.010572 - HTML::template -> template: >box_menu< 0.010604 - HTML::template_exists -> search: >page_box_left< == 1 0.010618 - HTML::template -> template: >page_box_left< 0.010637 - PAGE::get_boxes -> -------- call: left::menu_event 0.010642 - CBOX::menu -> generate Menu Box >event< 0.010654 - HTML::template -> template: >box_menu_bit< 0.010667 - HTML::template -> template: >box_menu_bit< 0.010680 - HTML::template -> template: >box_menu_bit< 0.010697 - HTML::template -> template: >box_menu_bit< 0.010709 - HTML::template -> template: >box_menu_bit< 0.010722 - HTML::template -> template: >box_menu_bit< 0.010734 - HTML::template -> template: >box_menu_bit< 0.010747 - HTML::template -> template: >box_menu_bit< 0.010759 - HTML::template -> template: >box_menu_bit< 0.010772 - HTML::template -> template: >box_menu< 0.010803 - HTML::template_exists -> search: >page_box_left< == 1 0.010818 - HTML::template -> template: >page_box_left< 0.010841 - PAGE::get_boxes -> -------- call: left::menu_login 0.010847 - CBOX::menu -> generate Menu Box >login< 0.010864 - HTML::template -> template: >box_menu_bit< 0.010882 - HTML::template -> template: >box_menu_bit< 0.010934 - HTML::template -> template: >box_menu< 0.010971 - HTML::template_exists -> search: >page_box_left< == 1 0.011002 - HTML::template -> template: >page_box_left< 0.011027 - PAGE::get_boxes -> -------- side=right 0.011038 - PAGE::get_boxes -> -------- call: right::party 0.011044 - CBOX::party -> generate Box 0.011050 - EVENT::short_event -> id >17< 0.011053 - EVENT::getevent -> id >17< 0.011058 - dotDatabase::query -> SELECT events.id, active, invite, password, events.name, anzahl, preis, konto, kontocheck, UNIX_TIMESTAMP(kontocheck) AS kontocheck_unix, event_location.name AS location, event_location.zip AS plz, event_location.city AS ort, event_location.street AS strasse, event_location.countrycode, location_id, map_template, allow_signoff, voraussetzung, minalter, turnier, netzwerk, weiteres, banner, UNIX_TIMESTAMP(begin) AS begin, UNIX_TIMESTAMP(end) AS end, UNIX_TIMESTAMP(signupbegin) AS sgbegin, UNIX_TIMESTAMP(signupend) AS sgend, UNIX_TIMESTAMP(seatreservebegin) AS seatbegin, UNIX_TIMESTAMP(seatreserveend) AS seatend, seatimage, UNIX_TIMESTAMP(canceled) AS canceled, archiv_gallery, archiv_media FROM events LEFT JOIN event_location ON event_location.id=location_id WHERE events.id=17 AND active=1 0.011172 - dotCommon::classload -> require: /www/htdocs/w00f1046/includes/class.cache.php 0.011383 - CACHE::get -> cache: >event_17::stats< found 0.011414 - HTML::template -> template: >box_event< 0.011475 - HTML::template_exists -> search: >page_box_right< == 1 0.011490 - HTML::template -> template: >page_box_right< 0.011521 - PAGE::get_boxes -> -------- call: right::forum 0.011528 - CBOX::forum -> generate forum box 0.011532 - CBOX::forum_load_threads -> load data 0.011541 - CACHE::get -> cache: >forum::topthreads< found 0.011596 - CBOX::forum_threads -> list all threads in array 0.011605 - FORUM::thread_lastvisit -> threadid: array ( 0 => 2510, 1 => 2509, 2 => 2499, 3 => 2502, 4 => 2508, 5 => 2507, 6 => 2506, 7 => 1919, 8 => 2505, 9 => 2485, 10 => 2503, 11 => 2501, 12 => 2500, 13 => 2496, 14 => 2498, 15 => 2497, 16 => 2495, 17 => 2493, 18 => 2494, 19 => 2445, ) 0.011616 - admin::getInstance -> do 0.011632 - HTML::template -> template: >box_forum_bit< 0.011684 - HTML::template -> template: >box_forum_bit< 0.011741 - HTML::template -> template: >box_forum_bit< 0.011768 - HTML::template -> template: >box_forum_bit< 0.011803 - HTML::template -> template: >box_forum_bit< 0.011824 - HTML::template -> template: >box_forum_bit< 0.011838 - HTML::template -> template: >box_forum< 0.011880 - HTML::template_exists -> search: >page_box_right< == 1 0.011893 - HTML::template -> template: >page_box_right< 0.011908 - PAGE::get_boxes -> -------- call: right::vote 0.011915 - CBOX::vote -> generate Box 0.011919 - dotDatabase::query -> SELECT v_id, UNIX_TIMESTAMP(v_ende) AS v_ende FROM vote_main WHERE v_start < NOW() AND v_ende > NOW() AND v_active=1 AND v_top=1 ORDER by v_start DESC 0.012064 - HTML::template -> template: >box_vote_nocurrent< 0.012116 - HTML::template_exists -> search: >page_box_right< == 1 0.012129 - HTML::template -> template: >page_box_right< 0.012144 - PAGE::get_boxes -> -------- call: right::banner 0.012156 - CACHE::get -> cache: >sponsoren_7::cbox_lanrenav3.de_DE< found 0.012180 - HTML::template_exists -> search: >page_box_right< == 1 0.012195 - HTML::template -> template: >page_box_right< 0.012258 - PAGE::get_boxes -> -------- call: right::search 0.012265 - CBOX::template -> generate Box with >box_suchen< as template 0.012283 - HTML::template -> template: >box_suchen< 0.012318 - HTML::template_exists -> search: >page_box_right< == 1 0.012343 - HTML::template -> template: >page_box_right< 0.012359 - PAGE::render -> final 0.012363 - PAGE::renderTemplate -> page 0.012368 - PAGE::getHead -> return 0.012371 - dotSession::getInstance -> do 0.012421 - HTML::template -> template: >page< 0.012518 - PAGE::render_template -> final PHP Includes : 19 DB Queries : 20 Rendering Time : 0.012830 Includes PHP Files: - /www/htdocs/w00f1046/forum/index.php - /www/htdocs/w00f1046/global.php - /www/htdocs/w00f1046/includes/class.dotCommon.php - /www/htdocs/w00f1046/config.php - /www/htdocs/w00f1046/includes/class.dotDatabase.php - /www/htdocs/w00f1046/includes/class.page.php - /www/htdocs/w00f1046/includes/class.dotSession.php - /www/htdocs/w00f1046/includes/class.user.php - /www/htdocs/w00f1046/includes/class.styles.php - /www/htdocs/w00f1046/html/styles/lanrenav3.php - /www/htdocs/w00f1046/includes/class.admin.php - /www/htdocs/w00f1046/includes/class.prvmsg.php - /www/htdocs/w00f1046/includes/class.event.php - /www/htdocs/w00f1046/includes/class.sitzplan.php - /www/htdocs/w00f1046/html/styles/lr.inc.php - /www/htdocs/w00f1046/includes/class.forum.php - /www/htdocs/w00f1046/includes/class.html.php - /www/htdocs/w00f1046/includes/class.cbox.php - /www/htdocs/w00f1046/includes/class.cache.php

LAN-Party

Sommerfest 2019

Forum

Umfragen

Partner

Suchen