database design - Normalization to 3NF from un-normalized relation -

-

given

insurance portfolio (portfolio id, insurance company name, insurance company phone, ((agent name, agent license number, state of residence, ((policy number, policy description, annual premium, benefit, beneficiary details)),  number of policies)), number of policies in portfolio)

i'm trying 3nf. on right track?

1nf:

1nf: insurance portfolio:(portfolio id, insurance company name, insurance company phone, ,agentname, number of policies in portfolio)  agentdetails: (agent name, agent license number, state of residence, policy number,number of policies in portfolio#)  policydetails:(agent name#,policy number#, policy description, annual premium, benefit, beneficiary details)

2nf

2nf: insurance portfolio:( agent name ,portfolio id, insurance company name, number of policies in portfolio)  agentdetails: (agent name, agent license number, state of residence, policynumber,number of policies in portfolio#)  policydetails:(agentname,policy number, policy description, annual premium, benefit, beneficiary details)

3nf:

 insurance portfolio:( agent name ,portfolio id, phonenumber  , number of policies in portfolio)   agentdetails:(agent name#, agent license number, state of residence,policynumber,number of policies in portfolio#)  policydetails:(agent name#,policy number#, policy description, annual premium, benefit, beneficiary details)

any guidance appreciated

your 1nf answer skips on 1nf , tries go 3nf directly. result, seem @ loss in 2nf , 3nf answers.

1nf doesn't introduce new relations (unless have nested tables can empty). eliminate nested rows. higher normal forms decompose relation.

your original schema has form:

r = (a, b, c, (d, e, f, (g, h, i, j, k), l), m)

i'm assuming portfolios can't exist without policies, , policies can't exist without agents. converting 1nf should have form:

r = (a, b, c, d, e, f, g, h, i, j, k, l, m)

and need choose suitable primary key every row in relation uniquely identified values of primary key. @ worst, combination of columns unique (i.e. there's key) in case should able find 1 3 columns or less, depending on associations between nested levels.

for 2nf, see if can find partial functional dependencies in 1nf schema. if chose primary key single column, relation in 2nf , can skip ahead. if there partial dependencies, split them off separate relations.

for 3nf, see if can find transitive functional dependencies in 2nf schema. if there any, split them off separate relations.


Comments

Post a Comment

Popular posts from this blog

ios - RestKit 0.20 — CoreData: error: Failed to call designated initializer on NSManagedObject class (again) -

-
this error has shown on many times, seems. prominent answer issue seems restkit 0.20 — coredata: error: failed call designated initializer on nsmanagedobject class however, solution posted doesn't work me. let's start beginning: i want upload file server. want parse response make sure uploaded. if not, try again later. model has boolean variable called nsnumber *senttoserver purpose (in coredata, bool saved nsnumber ) . because don't know whether sending going successful, save entity coredata model first before sending via restkit. when post request successful, server returns json string this: {"id":14,"created":true} notice that, of course, id not set on coredata model yet, both id , created new informations model. here's model: @interface recording : nsmanagedobject @property (nonatomic, retain) nsstring * audiofilepath; @property (nonatomic, retain) nsdate * createdat; @property (nonatomic, retain) nsstring * deviceid; @...
Read more

java - Digest auth with Spring Security using javaconfig -

-
so i'm trying create digest authentication spring following documentation trying translate xml "requirements" in java requirements. let's have xml in docs: <bean id="digestfilter" class= "org.springframework.security.web.authentication.www.digestauthenticationfilter"> <property name="userdetailsservice" ref="jdbcdaoimpl"/> <property name="authenticationentrypoint" ref="digestentrypoint"/> <property name="usercache" ref="usercache"/> </bean> <bean id="digestentrypoint" class= "org.springframework.security.web.authentication.www.digestauthenticationentrypoint"> <property name="realmname" value="contacts realm via digest authentication"/> <property name="key" value="acegi"/> <property name="noncevalidityseconds" value="10"/> </b...
Read more

laravel - PDOException in Connector.php line 55: SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: YES) -

-
my .env: app_env=local app_debug=true app_key=myappkey app_url=http://localhost db_connection=mysql db_host=localhost db_port=3306 db_database=gestiontaller db_username=root db_password='root' cache_driver=file session_driver=file queue_driver=sync redis_host=127.0.0.1 redis_password=null redis_port=6379 mail_driver=smtp mail_host=mailtrap.io mail_port=2525 mail_username=null mail_password=null mail_encryption=null i've tried password ", ' , without, restarting server every time. i've tried changing localhost 172.0.0.1. yes, password correct, running mysql -u root -p introducing password root in prompt can go mysql. users table: +------------------+-----------+ | user | host | +------------------+-----------+ | debian-sys-maint | localhost | | mysql.sys | localhost | | root | localhost | | root1 | localhost | +------------------+-----------+ i've added homestead.yaml this: database_port: 3306 ...
Read more