Determine third normal form in case of two functional dependencies

Assume I’m given an entity E which has attributes A, B and C, (each of them is a candidate key, but let’s say I can introduce some EID that serves as a PK) with functional dependencies: A determines C and B determines C. How would I get this into a third normal form?

I have tried the following:

E(EID(PK), AID(FK), BID(FK)) A(AID(PK), C) B(BID(PK), C) 

but in this representation, I’m have the attribute C twice in my database. Can anyone advise on a more appropriate way of getting into a third normal form?

Do the Fire Elemental’s Fire Form trait’s and Touch attack’s ongoing fire damage stack with each other?

Inspired by the following:

  • Does the Fire Elementa's Touch attack's ongoing damage stack with itself?

I realized that my own answer to that question hinges on the idea of features having the same name, but the Fire Elemental actually has two different features that cause extremely similar effects.

Notably it has the Fire Form trait and the Touch attack which state:

[…] In addition, the elemental can enter a hostile creature’s space and stop there. The first time it enters a creature’s space on a turn, that creature takes 5 (1d10) fire damage and catches fire; until someone takes an action to douse the fire, the creature takes 5 (1d10) fire damage at the start of each of its turns.

[…] If the target is a creature or a flammable object, it ignites. Until a creature takes an action to douse the fire, the target takes 5 (1d10) fire damage at the start of each of its turns.

Do these two ongoing effects stack with each other?

Access Subdatasheet (plus sign) not showing in datasheet view form but shows in table or query

I want to show inside a form in datasheet view, the plus signs for viewing subdatasheet. I have tables properly linked, all is fine and I have subdatasheet set in table/query and it displays correctly and all information well linked.

I have a form based on that table/query that has the subdatasheet but when I open the form in datasheet view so that I can see the subdatasheet, this wont show up. The plus signs are not there.

I just want a form for looking up data, not for editing and subdatasheet view serves perfectly what I want to achieve but I don’t want to open tables or queries directly but inside a form.

Does Barkskin cast before Wild Shaping apply to your beast form?

Assume you cast Barkskin in humanoid form:

You touch a willing creature. Until the spell ends, the target’s skin has a rough, bark-like appearance, and the target’s AC can’t be less than 16, regardless of what kind of arm or it is wearing.

It is clear that under the rules of Wild Shape “transforming doesn’t break your concentration on a spell you’ve already cast”, but does the effect of the spell carry over to your new skin?

Is there a spell or item that can detect Lycanthropes while they are in their human form?

Since purchasing the Troll Skull Tavern in Waterdeep, Ichabod the Inscrutable has run afoul of the Shard Shunner wererat gang. He believes their leader to be none other than the Fellowship of Innkeeper’s guildmaster, Mister Fairkettle.

Obviously, Ichabod can’t just run to the Watch, some of them are likely on Fairkettle’s payroll! What magical means are available to him that would help him identify and prove who the wererats are?

Ichabod has access to any published, core (non-UA) item or spell that is not an artifact or 9th level.

Is there a spell or item that can detect Lycanthropes while they are in their human form?


This question is purely hypothetical. Any resemblance to characters, living or dead, actual or fictional, is purely coincidental and is in no way intended to be a spoiler.

How to setup Google Analytics Form Submission Goals in SiteCore

My website is built on Sitecore CMS.

We have a /contact-us/ page where a form is provided for users. Once the click on Submit button, the same page loads with a submission confirmation message.

I want to setup goals on how many times successful submissions are done.

So how to configure conversion goals?

I think I can use "event" from Google Tag Manager.. but not sure how to find a page-id or form-id in SiteCore.

Woocommerce custom script ajax post form data fails to be captured in backend

I am using woocommerce and I wanna customize admin page’s coupon section.

So I use the following code snippet such that I can write my own codes in my_script.js.

add_action('admin_enqueue_scripts', 'add_custom_js_file_to_admin'); function add_custom_js_file_to_admin($  hook) {     $  screen = get_current_screen();     if ( 'shop_coupon' === $  screen->id ) {         wp_enqueue_script('my_script', plugin_dir_url(__FILE__) . 'js/my_script.js');     } } 

I am successful to create a new custom field: Taxonomy as shown in the pic below. And ajax post request’s header indicates that the data should be sent correctly (the red box in the pic). I am

However, my backend code snippet below fails to retrieve the data from the post request ( eg: $ tax below is null):

add_action('woocommerce_coupon_options_save', 'save_coupon_text_field', 10, 2); function save_coupon_text_field($  post_id, $  coupon)     {       $  tax = $  _POST['wc_sc_taxonomy_restrictions[0][tax]'];       $  coupon->update_meta_data('taxonomy_tax', $  _POST['wc_sc_taxonomy_restrictions[0][tax]']);       $  coupon->update_meta_data('taxonomy_op', $  _POST['wc_sc_taxonomy_restrictions[0][op]']);       $  coupon->save();     } 

I got 2 questions:

(1) Can someone kindly share any idea on what’s wrong with my codes above?

(2) In the custom script my_script.js, I wanna call an api which serves to retrieve data from my database; the data will then be used as the options available for the taxonomy’s drop-down select box. Can anyone tell me how I can do so in my_script.js? Normally in my BE php file, I wrote sth like below, yet I don’t know how I can perform sth similar in my custom script:

 global $  wpdb;  $  result = $  wpdb->get_results('some sql here'); 

How and why use validate_username and how to secure inputs fields of registration form?

I would use validate_username to protect username and other inputs from tags, octet, and others filters and conditions from sanitize_user but these functions only remove these dangerous chars and does not warn the user to not use these chars.

Does it exist a wordpress function of the same kind as validate_username that allow to warn and restrict user to use the same chars and conditions than those used in validate_username function ?

Could you help me to write a regex which fulfills the same conditions as validate_username to display error if one of conditions is positive.

And how I must do to add this regex |%([a-fA-F0-9][a-fA-F0-9])| to this one /^[A-Za-z0-9]$ / I don’t understand the use of | and / . In php.net this | is use to say "or" . For example this /^[A-Za-z0-9]$ / does not take into account octet (or exadecimal ?) as it define here : WordPress sanitize_user/

Knowing that hackers always discover solutions to hack what is to date the best solution to protect a registration and login form. If this last question is duplicate could you please post the link of existing response ?

Does Wind Walk grant stealth benefits due to gaseous form?

There has already been some helpful discussion about whether wind walk in D&D 5e also gives the extra effects associated with gaseous form (Just how gaseous is the "gaseous form" of the Wind Walk spell?). I understand the past consensus was that RAW says probably not, but that there is an acceptable basis for house rules to say otherwise.

In my group, we seem to have opted for the interpretation that being in wind walk’s gaseous form gives us all the benefits of gaseous form. For example, we’ve been able to do do things like flow through small cracks in wind walk.

Under my group’s interpretation of a wind walk that allows gaseous state benefits, would being a gas also make us more difficult to see, which would grant a stealth bonus? For context, we have a tentative plan to infiltrate a warehouse by slipping through a keyhole in wind walk, so we may need to resolve how easy it is for the guards on the other side to see us come in.